fixing error save file as pdf

alhagag · Jun 24th 2020

i appreciate if somebody finds out where is the problem

i have three macros about save invoice as pdf but it gives me error and highlight this line

Code

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=savename

**royUK** · Jun 24th 2020

Try

Code

savename = Range("savefolder") & Application.PathSeparator & "Statement" & " - " & cusname & ".pdf"

Your variables are declared incorrectly.

Code

 Dim email, cusname, emailtext, savename As String

email, cusname, emailtext, will be declared as type Variant. This will not cause major problems but should be

Code

 Dim email as String, cusname as String, emailtext as String, savename As String

alhagag · Jun 25th 2020

thanks but i do not find the file when save as pdf where is saved?

**royUK** · Jun 25th 2020

Your named range savefolder should contain the folder name

alhagag · Jun 25th 2020

i have this name in drive c:\savefolder nothing happens

**royUK** · Jun 26th 2020

What is in the range of the worksheet?

alhagag · Jun 29th 2020

sorry about delaying to respond you actually my PC has exposed virus

so the range in this A3:E46

**royUK** · Jun 29th 2020

You need to check the named rang called savefolder to see if the drive is enterd correctly

Participate now!