Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plz help me ...
Hi,
I am trying to open an excel sheet by using VBA in Excel. But, this particular sheet is maintained by other person in the company and is password protected. My code works perfect when the file is opened by the other person in the editing mode but fails to open the file when its closed or not in the editing mode. I am not able to trace the reason. I am left with this error message when the file is closed by the other person. "Microsoft excel is waiting for other program to finish OLE action" Code: Dim xls as New Excel.Application xls.workbooks.open("G:\sample.xls") Excel fails when I try to open this location ... why does it do so ??????????/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plz help me ...
i think the raison is that you will open a file that i paswordprotected. in the helpfile from Excel you find how to protec the file but not to open the file ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|