Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Execute replaced in Excel 2007?
I have a macro which does a data backup from hard drive to disk. It works
fine on my old computer which has Excel 2003 but not on my new one with Excel 2007. I get an error implying that .execute is not a valid term. Is there a substitute for .execute that I have not discovered yet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Execute replaced in Excel 2007?
..Execute is for commandbars object. New way for ribbon. example-
CommandBars.ExecuteMso "FileNew" "Jim Jackson" <Jim wrote in message ... |I have a macro which does a data backup from hard drive to disk. It works | fine on my old computer which has Excel 2003 but not on my new one with Excel | 2007. I get an error implying that .execute is not a valid term. | | Is there a substitute for .execute that I have not discovered yet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 link is invalid after referenced book is replaced | Links and Linking in Excel | |||
Excel 2007 won't execute 2003 VBA code | Excel Programming | |||
MROUND replaced with #N/A in Excel 2007 | Excel Worksheet Functions | |||
How can I execute Shape drawing Excel 2007? | Excel Programming | |||
Formula replaced with =#N/A in 2007 - why? | Excel Discussion (Misc queries) |