| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro <iif</i 001.xls exists
Aidan, apologies for my macro shortcomings. Although all the order spreadsheets are in the same folder, other files are in there too, including a few spreadsheets. Can you show me how to incorporate the ON ERROR command into the following abbreviated code that is in my Macro Workbooks.Open Filename:="\\Server\common\50000.xls" etc Workbooks.Open Filename:="\\Server\common\50001.xls" etc Workbooks.Open Filename:="\\Server\common\50002.xls" etc Looking it up online, there seems to be an ON ERROR GOTO NEXT option which I imagine moves to the next line of code. I have tried incorporating it myself without success. -- okanem ------------------------------------------------------------------------ okanem's Profile: http://www.excelforum.com/member.php...fo&userid=9301 View this thread: http://www.excelforum.com/showthread...hreadid=546681 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to move files gets an error if it already exists... | Excel Worksheet Functions | |||
| MACRO VBA TO SAVE EVEN IF FILE EXISTS | Excel Programming | |||
| Macro help - "Save As" when a file already exists | Excel Programming | |||
| Exists? | Excel Programming | |||
| within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming | |||
![okanem[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
