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.
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.
How doesn't it work?
Errors? Incorrect results?
If posting code please use code tags, see here.
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]
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.
Try specifying the file format and check B5 on 'MANUAL TS' has a valid filename.
Why the "" after range("B5") ?
Also does range B5 already have the extension?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks