Unshare an Excel sheet with VB.Net

[Erik Foreman]

I use the line

XLwkb.ExclusiveAccess()

to unshare the workbook and it works. the problem is it sends up a
prompt for confirmation. When I run this there will be noone around to
confirm it. how do we unshare the workbook without being prompted to
confirm.

I tried
XLwkb.ExclusiveAccess() = True
and that did not work.
I tried
XLwkb.ExclusiveAccess(True)
and
XLwkb.ExclusiveAccess(1)
both those said invalid number of parameters.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Phil]

Paul, thank you for this post! It allowed me to get around the prompting issue and now everything works great.

From http://www.developmentnow.com/g/38_2...ith-VB-Net.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com