Can you save options selected in Text Import Wizard?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Importing text with the Macro Recorder on gives me a macro like...
Workbooks.OpenText Filename:="D:\Test\Data\Test.txt", _
Origin:=xlWindows, StartRow:=1, _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, _
Tab:=True, Semicolon:=False, _
Comma:=False, Space:=False, Other:=False, _
FieldInfo:=Array(Array(1, 3), _
Array(2, 1), Array(3, 2))

Does anyone know of a way to capture the settings such as Origin, StartRow,
DataType, TextQualifier, Tab, etc...

I want the user to be able to pick several text files that will be
imported to Excel. The files for any one 'picking' session will have the
same format. I want to be able to have the user import the first file using
the Import Wizard. I'm fine up through here.
With that information, I can then automatically import the rest of the
files. BUT, I don't know how to capture the information entered by the user
in the Import Wizard. ie what the user put for StartRow, Arrays, etc.
Any help would be appreciated.
Sincerely,
Gary Brown

--
gary.DeleteThis2SendMeAnEmail.Brown@xxxxxxxxxxxx
.

Relevant Pages

  • Errors when trying to capture
    ... when im trying to capture i go to the capture wizard I select my camera ... choose the name and then when i get to video setting page in the wizard i ... and then when i close the wizard i get a message saying 'the video device can ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: web page screen capture utility?
    ... capture of a web page? ... so far the only thing i can think of is to have a firefox window ... "KSnapshot is a simple applet for taking screenshots. ... Unofficial "Wizard of Odds," A.H.P. ...
    (comp.os.linux.misc)
  • MM2 locks up!
    ... Movie Maker 2 locks up on me if I use the wizard to capture video from my ... Task manager reports it as non-responding. ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: Index on high update column
    ... You could use profiler to capture the activity and then use the index tuning ... wizard to see what recommendations you get. ... always trust the wizard to get it right, but it is usually pretty good. ...
    (microsoft.public.sqlserver.server)