By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,032 Members | 1,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,032 IT Pros & Developers. It's quick & easy.

share an excel spreadsheet

P: n/a
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!
Nov 21 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Nov 21 '05 #2

P: n/a
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)
Nov 21 '05 #3

P: n/a
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!
Nov 21 '05 #4

P: n/a
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!
Nov 21 '05 #5

P: n/a
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!
Nov 21 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.