File association to Excel spreadsheet

  • Thread starter Thread starter rci
  • Start date Start date
R

rci

Hi all,

I would like to do something a bit tricky with Excel 2002.

I would like to associate a file extension in such a way as to launch
a specific excel spreadsheet for parsing (via its macros).

For example:

Myfile.txt ---> launches ----> ExcelTextParser.xls (and launching excel in
the process)

Related:
Can arguments be passed to excel on startup?


All the best,

Mike
 
Hi Tom,

That seems to begin to work... but I can't seem to see how to pass the
file that was clicked on (that initiated this whole process) to the
spreadsheet.

The series of events needs to be:

User double clicks on a myfile.txt which is associated to my
exceltextparser.xls file.

Excel opens automatically, which opens exceltextparser.xls, which somehow
gets the path and name of "myfile.txt" as an argument so that the text
parser can open it.

Can we get from here to there?

(and o make matters worse, the text parser actually lives in a Userform, but
I think we can skip that for now :-)

Thanks again,

Mike


: excel.exe exceltextparser.xls

: should do that.

: --
: Regards,
: Tom Ogilvy

: :>
:> Hi all,
:>
:> I would like to do something a bit tricky with Excel 2002.
:>
:> I would like to associate a file extension in such a way as to launch
:> a specific excel spreadsheet for parsing (via its macros).
:>
:> For example:
:>
:> Myfile.txt ---> launches ----> ExcelTextParser.xls (and launching excel in
:> the process)
:>
:> Related:
:> Can arguments be passed to excel on startup?
:>
:>
:> All the best,
:>
:> Mike
 
Back
Top