Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import data from Access 2007 | Excel Discussion (Misc queries) | |||
Import Access data into Excel 2007 | Excel Discussion (Misc queries) | |||
how do I import data from iSeries in Excel 2007? | Excel Discussion (Misc queries) | |||
Import sharepoint data to Excel 2007 | Excel Programming | |||
Excel 2007 Data Import from txt files | Excel Discussion (Misc queries) |