If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Redirecting
Anyone know how to create a file which when opened by Excel 2003 causes it
to redirect itself and open a second (csv) file? I know how to get a web browser to do this using http-equiv="REFRESH" but cannot do it within Excel. Many thanks T |
#2
|
|||
|
|||
Redirecting
You can have a macro that in the first workbook that opens the .CSV file and
then closes itself: Option Explicit Sub auto_Open() Workbooks.Open Filename:="C:\my documents\excel\book1.csv" ThisWorkbook.Close savechanges:=False End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm tishoo wrote: Anyone know how to create a file which when opened by Excel 2003 causes it to redirect itself and open a second (csv) file? I know how to get a web browser to do this using http-equiv="REFRESH" but cannot do it within Excel. Many thanks T -- Dave Peterson |
#3
|
|||
|
|||
Redirecting
"Dave Peterson" wrote You can have a macro that in the first workbook that opens the .CSV file and then closes itself: Thanks for the response but what you suggest doesn't fit the bill. I won't have access to the workbook once it's distributed and I want to keep changing the destination file. |
#4
|
|||
|
|||
Redirecting
You could have the macro reads a text file to get the name and then open that
file. tishoo wrote: "Dave Peterson" wrote You can have a macro that in the first workbook that opens the .CSV file and then closes itself: Thanks for the response but what you suggest doesn't fit the bill. I won't have access to the workbook once it's distributed and I want to keep changing the destination file. -- Dave Peterson |
#5
|
|||
|
|||
Redirecting
"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? |
#6
|
|||
|
|||
Redirecting
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 |
Thread Tools | |
Display Modes | |
|
|