View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve JORDI Steve JORDI is offline
external usenet poster
 
Posts: 4
Default [2007] Any way to transparently import data from txt ?

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
------------------------------------------------