"Dave Peterson" wrote in message
...
You could have the macro reads a text file to get the name and then open
that
file.

that could work. Any idea how I might do that?

Option Explicit
Sub Auto_Open()

Dim TextLine As String
Open "C:\myfile.txt" For Input As #1
Line Input #1, TextLine
Close #1

Workbooks.Open Filename:=TextLine
ThisWorkbook.Close savechanges:=False

End Sub

You should add some validity checks to it.

C:\myfile.txt
is a plain old text file that contains one line of data--the full name of the
..csv file.



tishoo wrote:

"Dave Peterson" wrote in message
...
You could have the macro reads a text file to get the name and then open
that
file.

that could work. Any idea how I might do that?

--

Dave Peterson

"Dave Peterson" wrote
C:\myfile.txt
is a plain old text file that contains one line of data--the full name of
the
.csv file.

Thanks - works great if c:\myfile.txt is a local file. Doesn't work if it is
a network file - like http://www.mywebspace.com/myfile.txt

Unfortunately needs to be network for users to access it.

Maybe you can put it on a common network share. I don't speak the http stuff.

tishoo wrote:

"Dave Peterson" wrote
C:\myfile.txt
is a plain old text file that contains one line of data--the full name of
the
.csv file.

Thanks - works great if c:\myfile.txt is a local file. Doesn't work if it is
a network file - like http://www.mywebspace.com/myfile.txt

Unfortunately needs to be network for users to access it.

--

Dave Peterson

Ps. You may want to give all the requirements in your original posts. Then
someone who actually knows how to help may jump in.

Dave Peterson wrote:

Maybe you can put it on a common network share. I don't speak the http stuff.

tishoo wrote:

"Dave Peterson" wrote
C:\myfile.txt
is a plain old text file that contains one line of data--the full name of
the
.csv file.

Thanks - works great if c:\myfile.txt is a local file. Doesn't work if it is
a network file - like http://www.mywebspace.com/myfile.txt

Unfortunately needs to be network for users to access it.

--

Dave Peterson

--

Dave Peterson

"Dave Peterson" wrote

Ps. You may want to give all the requirements in your original posts.
Then
someone who actually knows how to help may jump in.

Apologies. I took it for granted that it would have to be a network file.
You're right though - I should have been more detailed.

I think the only way to do this would be a minor variant on your first
ingenious suggestion. If I program the distributed sheet1.xls to open a
second on the network (www.myswebspace.com/sheet2.xls) which I can alter at
will. Sheet2.xls can, as you suggested, be programmed to open
www.mywebspace.com/data.csv file and then close itself.

My only problem then is how to auto-switch back to sheet1.xls once that
procedure is complete. Users don't want to see the csv file - it just needs
to be open.

Any ideas gratefully received.

T

I should add for completeness I have no idea what directory the users will
be installing sheet1.xls in.

Workbooks("Sheet1.xls").activate

Might do it.

tishoo wrote:

"Dave Peterson" wrote

Ps. You may want to give all the requirements in your original posts.
Then
someone who actually knows how to help may jump in.

Apologies. I took it for granted that it would have to be a network file.
You're right though - I should have been more detailed.

I think the only way to do this would be a minor variant on your first
ingenious suggestion. If I program the distributed sheet1.xls to open a
second on the network (www.myswebspace.com/sheet2.xls) which I can alter at
will. Sheet2.xls can, as you suggested, be programmed to open
www.mywebspace.com/data.csv file and then close itself.

My only problem then is how to auto-switch back to sheet1.xls once that
procedure is complete. Users don't want to see the csv file - it just needs
to be open.

Any ideas gratefully received.

T

--

Dave Peterson