ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,737
- Office Version
- 2007
- Platform
- Windows
Hi,
As per title compile error when i go to print.
This line of code is in yellow when i debug
Path to folder is,
DESKTOP, GRASS CUTTING, CURRENT GRASS SHEETS, PAUL GODDARD
On my work is the following info.
Invoice Number cell L4
Date cell L13
As per title compile error when i go to print.
This line of code is in yellow when i debug
Path to folder is,
DESKTOP, GRASS CUTTING, CURRENT GRASS SHEETS, PAUL GODDARD
On my work is the following info.
Invoice Number cell L4
Date cell L13
Rich (BB code):
strFileName = "C:\Users\Ian\Desktop\GRASS CUTTING\CURRENT GRASS SHEETS\PAUL GODDARD\" & "INVOICE" & Range("L4").Value & " " & Format(Range"L13"), "dd-mm-yyyy") & ".pdf"