#1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a Macro in Excel 2007 Ken Excel Discussion (Misc queries) 1 December 6th 07 08:00 PM
Macro buttons in Excel 2007? Brian - Golfing Programs Excel Discussion (Misc queries) 3 September 13th 07 07:00 PM
Excel 2007 recording macro Dan[_3_] Excel Discussion (Misc queries) 1 August 16th 07 04:16 PM
Sorting Macro in Excel 2007 Kevin K[_2_] Excel Worksheet Functions 1 June 28th 07 01:54 PM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"