Hi,
Hopefully this is a relatively straightforward query, would be obliged for any tips on same.
I have the following piece of code:-
Workbooks.Open Filename:="test.xls"
If test.xls is already open when the code is executed I get the expected message: test.xls is already open... Reopening will cause any changes you made to be discarded. Do you want to re-open etc...etc...
Question: Is there a switch on the open method, or some other technique that I can use that will force the re-opening of the workbook without confirmation?
Many thanks in advance.
Orson.
Bookmarks