Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hidden Column A Problem | Excel Discussion (Misc queries) | |||
Hidden sheet problem | Excel Worksheet Functions | |||
Excel. I am having a problem with hidden text | Excel Discussion (Misc queries) | |||
Excel Workbook Hidden Problem | Excel Programming | |||
Hidden hyperlinks giving me a problem... | Excel Programming |