| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How open multiple file using vba then later combined into oneworkbook
Hi,,
I wanted to create excel macro when we run 1- Can browse file 2- Open multiple file at one time 3- Merge into single workbook Meaning file one goes to 1st sheet and subsequently Please help..Anyone.. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How open multiple file using vba then later combined into one workbook
What do you have so far ?
Start with application.getopenfilename() - there's a paramter which allows for multiple file selection Also - http://www.rondebruin.nl/tips.htm see under Copy/Pate Merge examples Tim "geniusideas" wrote in message ... Hi,, I wanted to create excel macro when we run 1- Can browse file 2- Open multiple file at one time 3- Merge into single workbook Meaning file one goes to 1st sheet and subsequently Please help..Anyone.. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How open multiple file using vba then later combined into oneworkbook
On Nov 21, 1:26*am, "Tim Williams" wrote:
What do you have so far ? Start with application.getopenfilename() * - there's a paramter which allows for multiple file selection Also - *http://www.rondebruin.nl/tips.htm*see under Copy/Pate Merge examples Tim "geniusideas" wrote in message ... Hi,, I wanted to create excel macro when we run 1- Can browse file 2- Open multiple file at one time 3- Merge into single workbook Meaning file one goes to 1st sheet and subsequently Please help..Anyone.. Thanks TQ Tim So far can open all but can't merge into a different sheet.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open file with multiple types of delimiters | Excel Worksheet Functions | |||
| Open a file by multiple users | Excel Discussion (Misc queries) | |||
| Multiple copies of Excel file open - :1, :2 | Excel Discussion (Misc queries) | |||
| Conditional formatting combined with multiple IF statements | Excel Worksheet Functions | |||
| batch file to open multiple worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
