J
James_G
Hello,
How do I find the name of the active workbook and use it in the following
connection string? I have tried several different things and nothing seems
to be working....i believe I have been looking at it for too long now. Any
ideas?
Private Const glob_s_Connect = "Driver={Microsoft Excel Driver (*.xls)}
;DriverId=790;Dbq=" & path_to_open_file & ";DefaultDir=C:\GelcoData;"
How do I find the name of the active workbook and use it in the following
connection string? I have tried several different things and nothing seems
to be working....i believe I have been looking at it for too long now. Any
ideas?
Private Const glob_s_Connect = "Driver={Microsoft Excel Driver (*.xls)}
;DriverId=790;Dbq=" & path_to_open_file & ";DefaultDir=C:\GelcoData;"