Macro not working while running multiple others macro..

[calvinle]

Hi,

I am actually using 1 macro to open a folder using a command button and run multiple macro on the file. The macro that run on the file does split worksheet, and split each worksheet into separate excel file. But when I try to do it, it doesnt work.

This is the open macro:

Please Login or Register  to view this content.

and the part that is not working is:

Please Login or Register  to view this content.

Any help will be thankful!

[Norie]

The SplitFiles sub is setup to work on the workbook the code is in, ThisWorkbook, not the workbook that's been opened, wbk.

Try passing wbk to SplitFiles as an argument.

That might look something like this, though I can't be sure as you've not posted the header for SplitFiles.

Please Login or Register  to view this content.

You would now call SplitFiles from Split like this.

Please Login or Register  to view this content.

[Leon V (AW)]

you can replace all the sheet copy, paste and delete stuf with just.

Please Login or Register  to view this content.

[calvinle]

The SplitFiles sub is setup to work on the workbook the code is in, ThisWorkbook, not the workbook that's been opened, wbk.

Try passing wbk to SplitFiles as an argument.

That might look something like this, though I can't be sure as you've not posted the header for SplitFiles.

Please Login or Register  to view this content.

You would now call SplitFiles from Split like this.

Please Login or Register  to view this content.

Sorry, I did not totally paste the whole format macro, these doesn't work after I change the sub to wbk1:

Please Login or Register  to view this content.

[calvinle]

I have tried to add this but it doesn't work..:

Please Login or Register  to view this content.