Results 1 to 3 of 3

Thread: Macro in 2007

  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I recorded three macro using excel 2007, and save it in 2003 compatible, but when I run it in excel 2003,

    from 1st macro, appears error in line

    .ThemeColor = xlThemeColorLight1

    2nd macro, appear error in line

    ActiveWorkbook.Worksheets("01-General Ledger").AutoFilter.Sort.SortFields.Clear

    which those problem do not appears when I run this macro using excel 2007

    please find file as attached

    thanks

    Indra
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The ThemeColor property doesn't exist in Excel 2003 and before, themes were introduced in Excel 2007. So you will have to remove that line and the two below it, for TintAndColor and ThemeFont are new in Excel 2007 too.

    The Sort method of the AutoFilter object is new too, you can't use it in Excel 2003 or before.

    If you want to develop workbooks for Excel 2003, you should do so in Excel 2003, not in Excel 2007 - there's too much danger of using new features.

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Jakarta, Indonesia
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks for the reply, Hans

    regards

    Indra

Posting Permissions

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