Rename all files in the same folder then print in order?

[HXIO]

Hi,

I'm trying to rename all the files in the same folder then print all the worksheets in all files is this possible in vba? I'd attached how I want it to be rename and what it was before.

Thanks

[PCI]

For the first step (rename files) see my personal tool: Macro is uggly, old etc.. but it's working.
Put the file in the folder where files are and open it

[HXIO]

@PCI,

Apologised where might I be able to see your personal tool?

[davesexcel]

For the first step (rename files) see my personal tool: Macro is uggly, old etc.. but it's working.
Put the file in the folder where files are and open it

Can you clarify this answer?

[PCI]

Houps, I forgot the file: See attached
As mentioned, record the file in the folder where are the files to rename.
Open the file, and a macro inside will initialize the path.
See button in the menu to make the list of the files

[HXIO]

@PCI

Thanks for the help.

Is there anyway to print all the files in the same folder? I came also a code that let me combine all the files within the same folder into one workbook then print all worksheets out at once. But is there anyway to speed up the process?

Please Login or Register  to view this content.

[davesexcel]

Are you able to print each workbook at the same time as you are looping through the workbooks?

[HXIO]

@davesexcel

No, this only let me combine all the files into one workbook. If I want to print I would need to click print after it finished combining, but the things is that sometime there's more than 100 files and combining them takes awhile.

[davesexcel]

Yes, it will take a while.

Use code to print the workbook.