HighTechTalks DotNet Forums  

Invoking "Convert Text to Columns Wizard" in Excel using Late Binding

Dotnet Framework (Interop) microsoft.public.dotnet.framework.interop


Discuss Invoking "Convert Text to Columns Wizard" in Excel using Late Binding in the Dotnet Framework (Interop) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
JED
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.