Invoking "Convert Text to Columns Wizard" in Excel using Late Binding -
01-04-2005
, 09:08 PM
Does anyone have an idea of how to invoke the Convert Text to Columns
Wizard (the one you see when you load a file that excel thinks could be
comma separated). It has to be done using late binding as I need to
support Excel 2003 -> Excel 2003.
For win32 this is done like:
FExcelObject.Dialogs[$000001A6].Show( huge params list )
I've tried all combinations (that I can think of) for getting the
correct Dialogs object, but have hit a dead end.
cheers,
Jeremy |