..... help required on Macros........ thnx

orcl · Post by **orcl** » Mon Mar 20, 2006 10:05 am

Hi all
May i know how to Merge the Excel Files.
I daily recieves around 12 Files and all of them have same number and name of sheets.
All i need to do is to Merge them and make a single file.
I have tried using VBA but the code stops while copying the sheet which contains charts.
I have a code which is

If Name= "Bchart1" then

go to again:

but still the problem persist.

Secondly the problem is even worse if the number of sheets vary.
I believe in that case we have to match the names of the sheets.
ANy help, code or part of code would do a great deal

Regards

Post by **Marcus Tettmar** » Mon Mar 27, 2006 7:51 am

This would appear to be an Excel/VBA/Microsoft Office query rather than a Macro Scheduler query? If the former you should try posting to one of the relevant newsgroups or Microsoft forums. If the latter I would say this is still primarily an Excel/VBA issue - the coding needs to be inside Excel. It could be in a Macro Scheduler macro using VBScript and OLE, but the code you need is still Excel code. I can help you convert VBA code into code that would run in Macro Scheduler, but I am unable to provide Excel specific support.