ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Macro (https://www.excelbanter.com/excel-discussion-misc-queries/168947-excel-2007-macro.html)

Ken

Excel 2007 Macro
 
I have a program which includes a macro which was written for an earlier
version of Excel. The program doesn't seem to work efficiently with Excel
2007. Do macros need to be written differently for Excel 2007? Also, a newer
version of the program (including the old macro) takes about 3 minutes to
load using 70% to 75% of CPU usage in doing so. Is this likely due to the old
macro or a programming error (infinite loop) ?
--
Ken

Pete_UK

Excel 2007 Macro
 
If you post the macro here then someone will be able to advise on how
it can be improved/adapted.

Pete

On Dec 8, 4:38 am, Ken wrote:
I have a program which includes a macro which was written for an earlier
version of Excel. The program doesn't seem to work efficiently with Excel
2007. Do macros need to be written differently for Excel 2007? Also, a newer
version of the program (including the old macro) takes about 3 minutes to
load using 70% to 75% of CPU usage in doing so. Is this likely due to the old
macro or a programming error (infinite loop) ?
--
Ken




All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com