I am writing an excel VBA program which needs to open or access various files
I need an if statement to do the following:
If the file is already open then choose Window.Select."file mane"
Else open the file."file name"
I have currently coded the program so that it will open the file. I need to introduce the If bit of the statement. Also I would like to automatically choose the option of not updating any extrenal links which the file to be open may have.
I would be grateful to hear from anyone who knows how to do this