Search results

I’ve have see something strange. when i use this code after compile : spath = ActiveWorkbook.Path msgbox(spath) I obtain: “J:nm4/” the hardisk J doesn’t exist on my PC But if i code the path clearly like this: strPathLocation = “C:\Users\Kevin\Downloads” it’s working. you know why? Thanks...

Thanks a lot Steven i’m trying today

Hi i have to export a pdf with this code but it’s not working after compile: Sheets(“report”).ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ strPathLocation & strFileName & “.pdf” _ , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _ :=False, OpenAfterPublish:=False...