View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Can I start the text import wizard automatically?

" I`d like to have a solution for all versions of MS Excel."
I can't thing of a response to this that would be appropriate.

However, I just pieced this together; see if gets you started...
'--
Sub DoItMyWay()
Dim vResult As Variant
On Error Resume Next
vResult = Application.Dialogs(xlDialogImportTextFile).Show
On Error GoTo 0
If vResult = False Then
Exit Sub
Else
'do it
End If
End Sub
'--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"pahan"
wrote in message
Hi everybody!
I have a file format which is actually CSV but has my own extension. I`ve
manually registered it in the windows registry to be opened by MS Excel. If I
open these files from Windows Explorer (not from Excel "Open file" dialog) I
need to start Text import wizard manually to properly format data from them.
Is there a way to launch Text import wizard automatically and with desired
settings in it? If yes, I`d like to have a solution for all versions of MS
Excel.