Using VBA to convert file to Excel
 

Hi-

I'm new to VBA programming.. here's what I would like to do- I'
wondering if someone can tell me if it's possible.

I would like to be able to read the contents of a file the user i
opening before it is displayed in the worksheet- more specifically, th
user opens a file of certain type (for example .xml), the VBA macr
converts the file into a workbook, and then it is displayed in Excel.
would also then like to be able to save the file back into the origina
format from Excel.

So basically a converter xml - excel - xml (just using xml as a
example here)

There is a mysterious collection called 'FileConverters' under th
Application object, but there is no way to add a converter to this- no
is there any documentation on how to create one of these 'converters'.

Can anyone shed some light on this issue?

Thanks a lot
ric

--
rich_lov
-----------------------------------------------------------------------
rich_love's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26190