Local Text File Reading in Excel

[dac5039]

A text file is created in the same directory as my .mxls file, which I want to be automatically read-in upon opening. How do I specify the location of the file without using an absolute path (I want to be able to send a folder with the excel file and the text file to another machine)?

Thanks,

Dave

 

[macropod]

Hi Dave,

This sounds like a vba question, which you should post in the vba forum.

However, to answer your question, you could specify the text file's path as the workbook's path (which you can always retrieve).


Cheers
[MS MVP - Word]

 

[dac5039]

macropod, thank you for your input. I will move this post on to the VBA forum.

In response to your answer, I'm confused by what you mean exactly, so I want to explain my problem a bit better. What my VBA script does is get external text data and store it in the first few columns. Then this data is used to create several graphs which are exported as .png images.

The problem is that I need to be able to pass my Perl, Fortran, and VBA scripts to another machine within a folder, have the Perl and Fortran code create the text file within that folder, and then have the .mxls file retrieve the text file and produce the graphs. So knowing the exact location of the text file won't be possible for other machines. So I tried simply using the VBA code for getting external text data with just the text file's location as the path name, hoping that VBA would look in its working directory by default. This apparently is not the case.

Thanks again for the input,

Dave

 

[macropod]

Hi Dave,

Use something like:

Dim strFilePath as String, strFileName as String, strFullName as String
strFilePath = ThisWorkbook.Path
strFileName = "MyFile.txt"
strFullName = strFilePath & "\" & strFileName

Cheers
[MS MVP - Word]