Hello,
Can someone help me? I have a macro for my purchases and have two references that make up the file name i.e Purchase order number and supplier name; the problem is that they show as one complete word and i wanted them to show with a break i.e 125358 Dave's Supplies
this is what i have at present
PURCHASING\PURCHASE ORDERS\PURCHASE ORDERS PDF\PC00" & Range("F15").Value & Range("A18").Value & ".pdf"
thanks in advance
Rich
Can someone help me? I have a macro for my purchases and have two references that make up the file name i.e Purchase order number and supplier name; the problem is that they show as one complete word and i wanted them to show with a break i.e 125358 Dave's Supplies
this is what i have at present
PURCHASING\PURCHASE ORDERS\PURCHASE ORDERS PDF\PC00" & Range("F15").Value & Range("A18").Value & ".pdf"
thanks in advance
Rich