Create pdf file

[rizmomin]

Hello:

Please refer to attached sheet.
I need a VB Code to create a pdf file (Print Pages 1-2) of the attached excel sheet with File Name in cell F4 and location F5

Please let me know if you have any questions.
Thanks
Riz

[Kenneth Hobson]

Recording a macro and inserting a concatenated string should suffice.

With a bit more bling...

Please Login or Register  to view this content.

[rizmomin]

Hi Kenneth:

Thanks a bunch, this works, however i want to save the pdf file in location F5 with file name as in cell F4.
Please let me know if you have any questions.
Thanks.
Riz

[rizmomin]

Hi Kenneth:

I am very sorry, it does save the file correctly.
Thanks a lot.....and if any problem i will let you know after further testing.
Riz

[Kenneth Hobson]

Good deal.

[rizmomin]

Hi Kenneth:
I am facing a small problem when i implement the code in my sheet.
I am seeing in your code it first find ("TOTAL LIABILITIES & EQUITY").
Here in my worksheet, teh string : ("TOTAL LIABILITIES & EQUITY") is coming from different part of the sheet and i have formula in the cell which will show the word : ("TOTAL LIABILITIES & EQUITY").
If i leave the formula then your code will not work.
If I change it to copy and paste special value ("TOTAL LIABILITIES & EQUITY") then it will work.
For example in cell B51 i have formula : =IF(AB51="","",AB51) which brings the text string TOTAL LIABILITIES & EQUITY.

Please let me know if you have any questions.
Thanks.

Riz

[Kenneth Hobson]

Recording a macro will show you the syntax if you don't know it.

Please Login or Register  to view this content.

[rizmomin]

Hi Kenneth:

Thanks a lot, this works great.
Riz