LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
------------------------------------------------
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from Access 2007 Johnnie Excel Discussion (Misc queries) 0 September 25th 09 02:12 PM
Import Access data into Excel 2007 rick Excel Discussion (Misc queries) 0 April 28th 09 09:34 PM
how do I import data from iSeries in Excel 2007? Towers Excel Discussion (Misc queries) 0 September 10th 07 07:44 PM
Import sharepoint data to Excel 2007 [email protected] Excel Programming 0 July 6th 07 08:43 PM
Excel 2007 Data Import from txt files deblmd Excel Discussion (Misc queries) 0 February 21st 07 05:33 PM


All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"