Hi there Excel developers,

Is there any way to transparently import data into a sheet using the
same parameters than when you do it manually but without asking for
anything and without displaying the import wizard, just pass its
parameters?

The operation consists of:
- Data - Import from TXT
- Then tell it "Fixed Width" and "Start at row 40"
- Then set the column separators (break lines) by positions
- Then import the data

Is this possible programmatically? Without recording a macro?

Thanks for any help.


Sincerely,
Steve JORDI

(Remove the K_I_L_LSPAM from my email address)
------------------------------------------------
1197 Prangins Email:
Switzerland WWW: www.sjordi.com
------------------------------------------------
Volcanoes at www.sjordi.com/volcanoes
MovieDB at www.sjmoviedb.com
------------------------------------------------

you could write the code, but just record the macro, save it and that will be
your code.



Gary Keramidas
Excel 2003


"Steve JORDI" wrote in message
...
Hi there Excel developers,

Is there any way to transparently import data into a sheet using the
same parameters than when you do it manually but without asking for
anything and without displaying the import wizard, just pass its
parameters?

The operation consists of:
- Data - Import from TXT
- Then tell it "Fixed Width" and "Start at row 40"
- Then set the column separators (break lines) by positions
- Then import the data

Is this possible programmatically? Without recording a macro?

Thanks for any help.


Sincerely,
Steve JORDI

(Remove the K_I_L_LSPAM from my email address)
------------------------------------------------
1197 Prangins Email:
Switzerland WWW: www.sjordi.com
------------------------------------------------
Volcanoes at www.sjordi.com/volcanoes
MovieDB at www.sjmoviedb.com
------------------------------------------------

Mhhh,
shame on me, I should have thought about that.
Simple solutions are always the ones forgotten...

Thanks!
:-)


On Mon, 4 Jan 2010 02:50:30 -0500, "Gary Keramidas"
<GKeramidasAtMSN.com wrote:

you could write the code, but just record the macro, save it and that will be
your code.



Gary Keramidas
Excel 2003


Sincerely,
Steve JORDI

(Remove the K_I_L_LSPAM from my email address)
------------------------------------------------
1197 Prangins Email:
Switzerland WWW: www.sjordi.com
------------------------------------------------
Volcanoes at www.sjordi.com/volcanoes
MovieDB at www.sjmoviedb.com
------------------------------------------------