I've searched through here and found all of the references for workbooks.open but can't find a reference to this:
I want to open an existing .xls file for the purpose of copying data from there to the currently open file. The procedure/form to query the user for the file name (allowing them to browse for it) works fine and I am opening it for ReadOnly access.
The difficulty is that the file has a startup macro that attempts to run when I open the file. Is there a way of stopping this? I can't seem to find a parameter in the workbooks.open command to allow for it.
Thanks as always!!!!