+ Reply to Thread
Results 1 to 6 of 6

code in office 2003 does not work in 2007

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    code in office 2003 does not work in 2007

    I Have used the following code in office 2003 but cannot get it to work in office 2007
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    How doesn't it work?

    Errors? Incorrect results?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: code in office 2003 does not work in 2007

    Which line errors out for you?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Registered User
    Join Date
    02-09-2010
    Location
    knottingley england
    MS-Off Ver
    Office 365 Excel
    Posts
    53

    Re: code in office 2003 does not work in 2007

    I have managed to get the code working down to the save bit by removing the removing protection.It now errors on the following
    Please Login or Register  to view this content.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Try specifying the file format and check B5 on 'MANUAL TS' has a valid filename.

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: code in office 2003 does not work in 2007

    Why the "" after range("B5") ?

    Also does range B5 already have the extension?

+ Reply to Thread

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