Hi,
I am currently using the following line as part of code importing various files into an excel workbook. I now need to update the filename to import 'BSCEL P10 0910', where the numbers "10 0910" are variable.
"Sheets("EL Data").QueryTables("BSCEL").Connection = "TEXT;" & ActiveWorkbook.Path & "\BSCEL.TXT"
Sheets("EL Data").QueryTables("BSCEL").TextFileCommaDelimiter = True"
I have so far tried changing the filename to the following. Any help would be much appreciated!!
1 - "\BSCEL P" & Format(GeneralNumber,"##",Date,"yyyy") & ".TXT"
2 - "\BSCEL P" & "*.TXT"
3 - "\BSCEL P" & Format(1233456,"## ####") & ".TXT"
4 - "\BSCEL P" & Format(GeneralNumber,"## ####") & ".TXT"
Bookmarks