| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
test file - is open?
Hi,
I made a macro which does some changes in the workbook and saves it with a new name. But I forgot one possible error - the file with the new name still exists, macro will rewrite it. Someone in network can have opened it at the moment I want do rewrite. Is there possibility of testing, if the file is able to rewrite? I don!t want to go through Error Statement. Thanks karmela |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Assistance needed to test for open file in a different direct | Excel Programming | |||
| VBA Assistance needed to test for open file in a different direct | Excel Discussion (Misc queries) | |||
| Open Test file with VBA with a changing file number | Excel Programming | |||
| Open file - How to test the path ? | Excel Programming | |||
| Test for Open File | Excel Programming | |||
Threaded Mode
