LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Import data from multiple excel files in one folder

Thanks

I will update the text



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"WingZero" wrote in message ...
No, it is fairly clear, I just had my mind somwhere else I suppose.

A slightly better wording however, would be:

Change the following two lines of code before you run the macro. Each
workbook that is selected with GetOpenFilename should contain a sheet name
and data range that matches your changes.

Note: If the sheet does not exist in a selected workbook, that row will be
highlighted in yellow.

ShName = "Sheet 1" '<----------Change sheet name
Set Rng = Range("A1,D5:E5,Z10") '<----------Change selected cells


Thanks again for the help.

 
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
Open many *.tsv files in folder and import the data into Excel SunRace Excel Programming 1 March 16th 06 10:40 PM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven Excel Discussion (Misc queries) 1 January 24th 06 03:28 PM
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? Raven[_2_] Excel Programming 1 January 24th 06 04:23 AM
Import data from multiple excel files Arlan Excel Programming 1 December 22nd 05 08:19 PM
Excel VBA - Import Data for manipulation from multiple text files ZX210 Excel Programming 2 January 13th 04 02:38 PM


All times are GMT +1. The time now is 03:17 AM.

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"