Excel Macro - Steering to a directory/file

[ZOR]

I have a macro which opens a text file and imports into spreadsheet. Can someone tell me how to add code to make the macro go to the drive C:Temp, and look for .txt files.

Thanks very much

 

[ZOR]

Sorry, ommited this bit. The code to open the file selection dialogue box.

I have tried putting ChDir everywhere but nothing seems to change it from going to the applications directory. Thanks

FileName = Application.GetOpenFilename(FileFilter:=Filt, FilterIndex:=FilterIndex, Title:=Title)

 

[ZOR]

It's sorted, thanks. It must have been the macro was not resetting itself during editing step through, as it works when fired up. Thanks