L
Lenonardo
HI.
I have a macro installed in my Personal.xls file that does some formatting
on the current activesheet.
I have assigned this macro to a button command button on an Excel toobar.
If I open spreadsheets I can use this button to format layout with no
problems.
There is one application I use which opens Excel and exports it's CSV data
into a spreadsheet.
When this appliction opens Excel my Personal.xls file is loaded,
but the macro button points to the Personal.xls file using a system path,
so that when I click on the button to run the macro Excel complains that
'Personal.xls' is already open - and won't open this second instance.
Can anyone tell me how this application can open Excel and confuse the
macro button association so that it thinks it is pointing to another
Personal.XLS?
(or how to get round this problem?)
Many thanks.
I have a macro installed in my Personal.xls file that does some formatting
on the current activesheet.
I have assigned this macro to a button command button on an Excel toobar.
If I open spreadsheets I can use this button to format layout with no
problems.
There is one application I use which opens Excel and exports it's CSV data
into a spreadsheet.
When this appliction opens Excel my Personal.xls file is loaded,
but the macro button points to the Personal.xls file using a system path,
so that when I click on the button to run the macro Excel complains that
'Personal.xls' is already open - and won't open this second instance.
Can anyone tell me how this application can open Excel and confuse the
macro button association so that it thinks it is pointing to another
Personal.XLS?
(or how to get round this problem?)
Many thanks.