Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excel 2007 (xlsm format)

    Hi,

    I have noticed recently that only "xls" and "xlsx" excel formats are allowed. What happens if the 2007 workbook contains a macro to user requires and they use 2007. Must the person replying to the post save the workbook in 2003 (xls) format to retain the macro? Will this not affect the macro if it contains references to objects not available in 2003? Why is this xlsm fomat not available in the lounge?

    Thought I'd just ask out of curiosity!
    TX
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2007 (xlsm format)

    Adding .docx, .xlsx and .pptx to the allowed extensions was a quick fix to accomodate Office 2007.
    If you need to attach a macro-enabled Office 2007 document, you can always zip it; it won't compress the file (since Office 2007 files are zip files already) but it will allow you to attach it.
    The same goes for templates for any Office version (.dot, .dotx, .dotm etc.)

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel 2007 (xlsm format)

    Of course... I forgot about the humble zip format. That answers it all.

    Tx Hans
    Regards,
    Rudi

Posting Permissions

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