I am using a macro (called save_it see below) to save a file with a specific format as illustrated below. My problem is that when I execute this macro file, save as the File Name box is populated with the specific file format BUT enclosed in quotation marks. Naturally this does not allow me to actually save the file.
Can you please help me in fixing this issue?
"Customer site - Technology & Mobile (without Satellite) Event Request for 2010 Feb 2 - Abc test co. - V 20090813 Time 10 20 28.xls"
With:
strTest = Customer site - Technology & Mobile (without Satellite)
strDate = 2010 Feb 2
strCustomer = Abc test co.
strVerDate = V 20090813 Time 10 20 28
Bookmarks