Problem with hidden file
I an using Windows 98 and Excel 2000.
Following are the first few lines of code of a program that runs at night
unattended. If "quotes.xls" happens to have been hidden when Excel was last
closed then line 3 opens it as a hidden file and this program stalls when
the code ( line 4) tries to activate one of the several sheets in the file
..
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
Workbooks.Open "d:/allyears/quotes.xls"
Worksheets("Current Quotes").Activate
I have tried to follow the "open" instruction with every version of
"visible" I can think of without success.
Can someone help me with this problem?
Thanks.
Jim
|