| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Data Excel Macro
Hey!
I'm trying to create a macro that will import data from another excel file, into my current excel file. Basically, I see the process going as follows: 1. Run Macro via Button 2. Pop-Up Window asking for File Location (importBook) 3. Import Data from importBook into sheet entitled Data 4. Click OK once import is complete I've got some knowledge of coding but macro coding knowledge is limited. If anyone has an existing code or can whip one up, I would be very appreciative. Regards, Kam Moolani Toronto, ON |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data Excel Macro
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data Excel Macro
Just use the record macro feature and import the data. That should give you the code you need for it " wrote: Hey! I'm trying to create a macro that will import data from another excel file, into my current excel file. Basically, I see the process going as follows: 1. Run Macro via Button 2. Pop-Up Window asking for File Location (importBook) 3. Import Data from importBook into sheet entitled Data 4. Click OK once import is complete I've got some knowledge of coding but macro coding knowledge is limited. If anyone has an existing code or can whip one up, I would be very appreciative. Regards, Kam Moolani Toronto, ON |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import Data Excel Macro
Kam,
I've been working on the same type of macro, but am stuck. Did you have any luck? I tried recording the macro, but when I go back to my destination file, Excel crashes. Thanks in advance, Amy " wrote: Hey! I'm trying to create a macro that will import data from another excel file, into my current excel file. Basically, I see the process going as follows: 1. Run Macro via Button 2. Pop-Up Window asking for File Location (importBook) 3. Import Data from importBook into sheet entitled Data 4. Click OK once import is complete I've got some knowledge of coding but macro coding knowledge is limited. If anyone has an existing code or can whip one up, I would be very appreciative. Regards, Kam Moolani Toronto, ON |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
| Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
| save original data after macro is run again | New Users to Excel | |||
| Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions | |||
Linear Mode
