Adding a new excel file type

[Wim Glassee]

Hi all,

I have a certain type of tab seperated file that I would like to load
in Excel.

I have a macro that will do the trick for me, but I'd like to make
things a bit easier on my users, by allowing them to open these files
transparently.

Ideally, I would like to have:

myfile.myextension

registered to be opened by microsoft excel on double click

And, here it comes, add the .myextension file type to the list of
default file types in excel, and hook up my macro when it wants to
open a file of this type.

Can this be done?

Thanks in advance,

Wim

 

[AA]

Windows Explorer + Tools + Folder Options...

Then

File Types + New, type extension in the box, Click
Advanced, Select Microsoft Excel Application.

 

[Wim Glassee]

Hi Mike,

thanks for your speedy answer, but it didn't seem to work
unfortunately.

I added the piece of code to the a hidden worbook I keep in XLStart
that also holds the parse macro, but it doesn't seem to jump in when
it should.

I've been reading some more on the groups and it seems it might be
possible to create a fileconverter, but there is hardly any
information available on the fileconverter API. This solution would be
the cleanest of course, this way no matter how you open a file, it
will be parsed correctly.

Another solution for me would be to 'override' text import wizard. The
default for each cell is 'general', and I would like it to be text.
Does anybody have any idea how this can be accomplished? Is it in the
registry somewhere?

Thanks,

Wim