Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Reading the file name and path from cells
I want to read different text files by running a macro. The code for a
"test" file is: Workbooks.OpenText Filename:="c:\data\test.dat", Origin:=720, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=True, Tab:=False, Semicolon:=False, Comma:=False _ , Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array _ (3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), TrailingMinusNumbers:=True Now, the path of this file is always "c:\data" , the file name will be on the cell A1(test) and the file extention is always "dat". what are the changes in the code? Many thanks in advance Fazl --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Reading the file name and path from cells
Workbooks.OpenText Filename:="c:\data\" & _
Range("A1").Value & _ ".dat", Origin:=720, _ StartRow:=1, DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=True, Tab:=False, Semicolon:=False, _ Comma:=False, _ Space:=True, Other:=False, FieldInfo:= _ Array(Array(1, 1), Array(2, 1), Array _ (3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), _ TrailingMinusNumbers:=True -- Regards, Tom Ogilvy "fazl " wrote in message ... I want to read different text files by running a macro. The code for a "test" file is: Workbooks.OpenText Filename:="c:\data\test.dat", Origin:=720, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=True, Tab:=False, Semicolon:=False, Comma:=False _ , Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array _ (3, 1), Array(4, 1), Array(5, 1), Array(6, 1)), TrailingMinusNumbers:=True Now, the path of this file is always "c:\data" , the file name will be on the cell A1(test) and the file extention is always "dat". what are the changes in the code? Many thanks in advance Fazl --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
reading from another file and pasting to current file, "combobox" | New Users to Excel | |||
Reading from file | Excel Programming |