share an excel spreadsheet

  • Thread starter Thread starter Erik Foreman
  • Start date Start date
E

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.
 
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
 
¤ 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)
 
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?
 
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.
 
I finally got it to work.

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

saved and shared in VB.net
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Excel Excel spreadsheets opening at top instead of bottom. 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
opening / modifying Excel spreadsheets in VB.Net 2
Excel Spreadsheets keep moving 0
Opening an 2003 Excel spreadsheet 3
Displaying zeros in cells 2
Excel Access - importing an excel spreadsheet 0

Back
Top