[2007] Any way to transparently import data from txt ?

[Steve JORDI]

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)

 

[Gary Keramidas]

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



Gary Keramidas
Excel 2003

 

[Steve JORDI]

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

Thanks!

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)