share an excel spreadsheet

[Erik Foreman]

I am trying to use vb.net to programatically share an excel spreadsheet.
is there any way to do that? I can't find it. help.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Cor Ligthert]

Erik,

When you want to do this than you first have to know how.
One of the most active Microsoft newsgroups is

microsoft.public.excel.programming

In your case I would first ask it there and than try to convert the answer
to VBNet.

Probably than you have a better change on a good solution.

I hope this helps anyhow

Cor

[Paul Clement]

On Wed, 23 Mar 2005 14:46:29 -0800, Erik Foreman <Er**@devedx.com> wrote:

¤ I am trying to use vb.net to programatically share an excel spreadsheet.
¤ is there any way to do that? I can't find it. help.
¤

You have to open the Workbook via automation and then save it (SaveAs), specifying the shared mode
parameter (AccessMode).
Paul
~~~~
Microsoft MVP (Visual Basic)

[Erik Foreman]

I tried to enter microsoft.public.excel.programming into Outlook and I
get server not found. I am on a LAN with a DSL Modem acting as a router
giving out ip addresses. the IP of the modem is 192.168.1.1 and the
subnet mask is 255.255.255.0 any idea where I can get help connecting to
the news group?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Erik Foreman]

I tried all of these lines of code and they were all unsuccessful at
sharing the excel document from vb.net application:

XLwkb.Saveas("c:\filename.xls", , , , , , xlshared, , )
XLwkb.Saveas("c:\filename.xls", , , , , , "xlshared", , )
XLwkb.Saveas("c:\filename.xls", , , , , , xlshared)
XLwkb.Saveas("c:\filename.xls", , , , , , "xlshared")
XLwkb.Saveas("c:\filename.xls", , , , , , AccessMode:=xlshared, , )
XLwkb.Saveas("c:\filename.xls", , , , , , "AccessMode:=xlshared")
XLwkb.Saveas("c:\filename.xls", , , , , , AccessMode as xlsaveaccessmode
= "xlshared")
activeworkbook.SaveAs("c:\filename.xls" ,,,,,,AccessMode as
XlSaveAsAccessMode = xlShared)

I also tried all of these variations without the 6 commas inbetween
filename and access mode. None of them shared the workbook.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Erik Foreman]

I finally got it to work.

XLwkb.SaveAs(filename, , , , , , 2)

saved and shared in VB.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!