+ Reply to Thread
Results 1 to 3 of 3

convert vba written in excel 2010 to excel 2003

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    convert vba written in excel 2010 to excel 2003

    Hello. Newbie and a dummy in vba here.

    I have completed the vba codes for my current excel file of course with the help of this forum especially #coreytroy. However i have written it in 2010 and some of the users of this file will open it in 2003. Is there a way for the written code to be converted and work in 2003? please please help.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,442

    Re: convert vba written in excel 2010 to excel 2003

    Hi excelandclard,

    If you save your workbook as a .xls file it should convert the VBA to 2003 code.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

    Re: convert vba written in excel 2010 to excel 2003

    Saving as an xls file doesn't change any code, but that code should run fine in 2003 (he said, without testing) when you do.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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