palbiro
06-01-2012, 01:43 AM
Hi,
I have an Excel VBA macro, I run it from C:\temp.
I have a problem with the following line:
Sheets(F).Shapes("M").OnAction = "2012.xlsm!Copy"
In the F sheet to the button M the macro assigment is "C:\temp\2012.xlsm!Copy"
1. question: why put it the path (C:\temp) there (I can see from the debugger)
2. question:
Under 2003 it worked perfect.
In Excel 2010 it doesn't work, it can't find the 2012.xlms!Copy. How can I correct it?
Thanks very much
I have an Excel VBA macro, I run it from C:\temp.
I have a problem with the following line:
Sheets(F).Shapes("M").OnAction = "2012.xlsm!Copy"
In the F sheet to the button M the macro assigment is "C:\temp\2012.xlsm!Copy"
1. question: why put it the path (C:\temp) there (I can see from the debugger)
2. question:
Under 2003 it worked perfect.
In Excel 2010 it doesn't work, it can't find the 2012.xlms!Copy. How can I correct it?
Thanks very much