Run-time error 1004 - save as pdf problem

**vvujke** · 03-05-2013, 02:26 AM

Hi guys,

I have a problem when I run this script. don't know what the problem. Debugger gives me Run-time error 1004 and when I stop debugger excel crashes.

Please Login or Register  to view this content.

Highlighted code is

Please Login or Register  to view this content.

Can you help, please? truly don't know what the problem tnx

**haripopuri** · 03-05-2013, 08:14 AM

Will you be able to upload your file as sample?

**JBeaucaire** · 03-05-2013, 08:43 AM

When the crash occurs and you DEBUG, hover your mouse over pdfName.... what is the exact current value of that variable?

**vvujke** · 03-05-2013, 10:43 AM

Invoice Blank.xlsm

Hi haripopuri,

here is the file.

tnx for help

**vvujke** · 03-05-2013, 10:52 AM

Value is root\PDF Archive\100 Invoice Name.pdf

It manages to save pdf version of the file but then show popup with Run-time error with debug and end options. When I chose debug code is highlighted if I chose end, Excel crashes.

Tnx

**haripopuri** · 03-05-2013, 12:04 PM

Hi vvujke,

In the pdfname variable value, "PDF Archive" folder is already existing in your system? What I see is when excel tries to save in the exact path given in pdfname, if it could not find the PDF Archive folder, its causing a run time error. You will have to first create the folder and then try to save the file.

**vvujke** · 03-05-2013, 10:03 PM

Hi haripopuri,

I have PDF Archive folder created. It creates pdf in that folder and after that it crashes. In VBA line OpenAfterPublish:=False is marked with the arrow...

tnx