Excel VBA Macro - Hard Task

[vijaychennai]

Hello all,

I have excel file in my C Drive......

Folder Name : Excel

In that folder i have more than 100 excel file.

I want to convert all the excel file in to PDF.

Can you please help me to provide VBA Code.

Thanks....

 

[vijaychennai]

Any Reply........

 

[vijaychennai]

Hello Guru's ...

Please Help.....

 

[Blade Hunter]

Do you have a PDF converter installed so you could save or print to PDF?

 

[vijaychennai]

Yes I Installed 'ScanSoft PDF Professional 4" in my system.
I my c folder i have more than 100 excel workbook. i want to convert all the excel file in to PDF.....

 

[Blade Hunter]

Record a macro where you save one of them as a PDF then post the resulting code on here and we can loop it through files for you.