Query on VBA macro no longer working

what is strSavePath, fileprefix and filesuffix?

Thanks for response. Unfortunately as I did not write the macro I do not know.

I'm assuming they are defined somewhere else in the code? maybe try posting all of the code - uploading a workbook would be best.

That is the enitre code I was given for the macro. I think they might be something to do with the location the newly created file is saved into along with the.xls bit

If that is all the code you have then those are all blank variables and would be empty, therefore you would be trying to save the files as just the name of the worksheet with a space either side, this might be causing you problems. There is nothing to tell it the file should be .xls.

If you could provide a bit more information on what you are trying to do then maybe we can rework the code as it looks like you have not been given the full thing. For example, where should the sheets be saved? what file type? If you could maybe provide some examples of the sheet names and some examples of what the file paths and names should be for each sheet?

Thanks again for your help.

To answer your questions :-

The path for the saved files should be in the same folder as the source document.
In the attached examples the files would need to be called Tester 1, Tester 2 & Tester 3 with only that relevant information on.

The files ideally need saving as either .xls or microsoft excel worksheet format.

Do you want each saved workbook to contain just the sheet it is named after?

Yes please - that would be great.

Please Login or Register  to view this content.

try that.

Fantastic! Seems to have worked brilliantly. Thanks for your help. Now to apply it to our file with 500 worksheets!!

aaaaaaah. you might want to take a look here:
http://support.microsoft.com/kb/210684

I seem to recall you can run into issues copying worksheets repeatedly in vba... I'm not sure whether it would apply to you though because you are copying different sheets each time.