Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    saving from excel2010 to excel2003 - sheet contains macros

    I am having trouble saving files from excel2010 to excel2003 format
    I work with people using older copies of Excel and we use files which use a lot of Macros written in Ecel2003

    On my excel2010 machine:
    In FILE>OPTIONS>SAVE
    I have set SAVE FILES IN THIS FORMAT to Excel 97-2003 Workbook (*.xls)

    In the TRUST CENTER>MACRO SETTINGS
    I have set ENABLE ALL MACROS

    when I save, it saves as .xls but the VB Project is removed from the file.

    How can I set things so it doesn't remove the VB Project.

    Kind Regards Paul

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    I can't reproduce this behavior.

    I assume the original file is an .XLSM file.

    When you do the first SAVE AS do you pick "Excel 97-2003 Workbook (*.xls)"?

    Steve

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Steve, thanks for your reply

    Unfortunately the original is .xls not .xlsm
    it is created from .xlt and saved as .xls on excel2003
    then when it is worked on and re-saved on the later version of excel as .xls the VB Project is not included in the save

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    I still can't recreate the problem in XL2010.

    I create a file with a macro, save As an XL97-2003 XLT file. I close the file and when I later reopen the template file, and save as an XL93-2003 xls file and it still has the macro...

    Steve

  5. #5
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,525
    Thanks
    32
    Thanked 180 Times in 174 Posts
    I can't replicate it either.
    1. I create a test file using Excel2003, which includes vba module with some code, and save it.
    2. I open the .xls file in Excel2010 and get the usual security warning that macros have been disabled, so I click the 'Enable Content' option button.
    3. I make changes to the file while in Excel 2010. I just click 'Save' as I am in compatibility mode and don't need to change the filename.
    4. I open the file in Excel 2003 and see the changes I made, and still have the VBA module and code.

    zeddy

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •