| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open excel file and copy data to another file
I would like to create a macro that would do the following:
1- Open a closed Excel file located on my drive named "A" and select the sheet named "Sheet1" 2- Copy all data from this sheet starting on cell A1 to the already opened master Excel file named "B" on sheet named "Sheet2" cell A1. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open external data (varying file names) and closing file once data is retrieved | Excel Programming | |||
| Open CSV file, format data and write output to a text file. | Excel Programming | |||
| Use ADO to transfer data from open excel file to closed excel file | Excel Programming | |||
| How do I import text file, analyze data, export results, open next file | Excel Programming | |||
| Open delimited text file to excel without changing data in that file | Excel Programming | |||
Threaded Mode
