How to create Pdf filename base on ws Range.Value

[tuongtu3]

Hi,
There's several post in this forum that I can use for my work but I don't know how to make the file name base on the ws range.

Please Login or Register  to view this content.

Regards,
tt3

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[tuongtu3]

Hi TMS<
I tried but it didn't work. Can you take a look.

Please Login or Register  to view this content.

[TMS]

In what way does it not work? Have you got a Documents folder at the root level of Drive C:\


Regards, TMS

[tuongtu3]

Hi TMS,
Yes, I did have a Documents folder at the root level of Drive C:\

In cell B3 = Reference# xxxxx
and it work if I entered "Filename:="C:\Documents\Reference#" & ".pdf"

Regards,
tt3

[TMS]

I suggest you post a sample workbook with some typical data and the code you are working with.


Regards, TMS

[tuongtu3]

Hi TMS,
Please take a look at the file in attached.

Regards,
tt3

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[tuongtu3]

Hi TMS,
Still got an error message "Compile error: Variable not defined" and "Dest =" was
highligh. I tried the code on other win7 and that works.
Thank you very much for your time and help.

Regards,
tt3

[TMS]

Clearly, Dest is defined ... did you copy and paste the code or did you retype it?

I tested it on a Windows 7 machine with Excel 2007. And i set up a folder structure on my C: drive to emulate your environment. I then copied and pasted the code from the VB Editor into the thread.

Sorry it doesn't work. I can only assume it is something to do with the MAC.

Regards, TMS

[tuongtu3]

Hi TMS,
Thank you very much for your time and help.

Regards,
tt3

[TMS]

You're welcome