.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? |
.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? |
All times are GMT +1. The time now is 05:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com