Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force current directory
Hi All.......
I am using the following code to open a non-excel file so I can manipulate and extract the data from it I need. I would like to force Excel to look in the same directory that the file I'm using to open the non-excel file came from........rather than some directory that some default figures I should use........problem is, the file "is not found" in that default directory. Note, the actual file has no extention. Workbooks.OpenText Filename:="q261pxda.*", _ Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _ Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), _ Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)) Any help would be much appreciated, TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
current directory | Excel Discussion (Misc queries) | |||
Current Directory | Excel Discussion (Misc queries) | |||
How do I force an Excel macro to ask me which file and directory? | Excel Discussion (Misc queries) | |||
changing current directory to that of the current open file | Excel Programming | |||
Set The Directory to the Current WB Path | Excel Programming |