| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"File Already Exists" MsgBox when opening Workbooks
I keep getting a msgbox popping up when I open some workbooks saying "File
Already Exists". What does this mean? As far as I know the workbook that is opening is the only workbook with that filename. -- Cheers, Ryan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"File Already Exists" MsgBox when opening Workbooks
Try emptying the temporary folder and remove all temp files in the folder
where your document is (make sure to display hidden files also when browsing the folder). "RyanH" wrote: I keep getting a msgbox popping up when I open some workbooks saying "File Already Exists". What does this mean? As far as I know the workbook that is opening is the only workbook with that filename. -- Cheers, Ryan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"File Already Exists" MsgBox when opening Workbooks
You may have a workbook open macro running. You can check to see if a macro
is running by typing Cntl - Break when the msgbox appears. Then press the OK button on the message box. If a macro is running the code should stop running in the VBA window at the line after the message box. "RyanH" wrote: I keep getting a msgbox popping up when I open some workbooks saying "File Already Exists". What does this mean? As far as I know the workbook that is opening is the only workbook with that filename. -- Cheers, Ryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel "Save as" dialog - when file already exists | Excel Programming | |||
| Leftover Workbooks Named "Object" When Opening Excel In IE | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Macro help - "Save As" when a file already 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 | |||
Hybrid Mode
