Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Import macros from Excel 2003 to 2007

Hi
I have many workbooks in Excel 2003 containing macros.
When I tried to save them in Excek 2007 format yje macroa are removed.

If there is any way to keep my macros in Excel 2007?

Thanks
--
Eli Kedar
Israel
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Import macros from Excel 2003 to 2007

You must save the workbook as a "macro enabled workbook".

*.xlsm format

Also set your security to "disable all macros with notification" or "enable
all macros"...................not recommended.


Gord Dibben MS Excel MVP


On Tue, 14 Apr 2009 07:21:02 -0700, Eli Kedar
wrote:

Hi
I have many workbooks in Excel 2003 containing macros.
When I tried to save them in Excek 2007 format yje macroa are removed.

If there is any way to keep my macros in Excel 2007?

Thanks


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Import macros from Excel 2003 to 2007

Thank You
--
Eli Kedar
Israel


"Gord Dibben" wrote:

You must save the workbook as a "macro enabled workbook".

*.xlsm format

Also set your security to "disable all macros with notification" or "enable
all macros"...................not recommended.


Gord Dibben MS Excel MVP


On Tue, 14 Apr 2009 07:21:02 -0700, Eli Kedar
wrote:

Hi
I have many workbooks in Excel 2003 containing macros.
When I tried to save them in Excek 2007 format yje macroa are removed.

If there is any way to keep my macros in Excel 2007?

Thanks



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
How do I import a database from excel 2003 to 2007? Theresa59 New Users to Excel 3 January 17th 09 02:01 PM
Excel Macros from 2003 to 2007 brihyanna Excel Discussion (Misc queries) 1 December 14th 07 03:29 PM
Excel Macros - Any Major Differences Between 2003 and 2007 bk Excel Worksheet Functions 1 November 20th 07 03:56 PM
Excel Macros 2003 into 2007 Lyndsey Wood Excel Worksheet Functions 1 November 8th 07 02:49 PM
I was using Excel 2007, now 2003 and my Macros won't work Jaynemoggy Excel Worksheet Functions 2 September 21st 07 11:14 PM


All times are GMT +1. The time now is 09:45 AM.

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

About Us

"It's about Microsoft Excel"