Results 1 to 15 of 15

Excel 2007 code that doesn't crash 2002 compiler?

Threaded View

foxguy Excel 2007 code that doesn't... 08-15-2010, 01:39 AM
royUK re: Excel 2007 code that... 08-15-2010, 02:27 AM
royUK Re: Excel 2007 code that... 08-15-2010, 02:32 AM
foxguy Re: Excel 2007 code that... 08-15-2010, 01:20 PM
royUK Re: Excel 2007 code that... 08-15-2010, 01:28 PM
foxguy Re: Excel 2007 code that... 08-15-2010, 02:19 PM
romperstomper Re: Excel 2007 code that... 08-15-2010, 03:39 PM
DonkeyOte Re: Excel 2007 code that... 08-16-2010, 03:05 AM
foxguy Re: Excel 2007 code that... 08-16-2010, 01:25 PM
shg Re: Excel 2007 code that... 08-16-2010, 01:27 PM
foxguy Re: Excel 2007 code that... 08-16-2010, 01:48 PM
romperstomper Re: Excel 2007 code that... 08-16-2010, 01:47 PM
foxguy Re: Excel 2007 code that... 08-16-2010, 01:55 PM
shg Re: Excel 2007 code that... 08-16-2010, 02:03 PM
foxguy Re: Excel 2007 code that... 08-16-2010, 02:08 PM
  1. #1
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Excel 2007 code that doesn't crash 2002 compiler?

    I'm trying to write a macro that will work in Excel 2002 and Excel 2007. But sometimes I would like to take advantage of the 2007 commands that won't work in 2002.

    I know about the compiler directives #IF ... #ELSE ... #END IF, but I can't find a constant that can tell the difference between the 2 versions.

    How can I write code that takes advantage of the 2007 language, but won't crash the 2002 compiler?
    Last edited by foxguy; 08-16-2010 at 02:29 PM.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1