Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for opening new files and copying from them - please help!
Hi, I'm designing a macro that, among other things, has pop-up windows that allow the user to enter data. I'd like the user to be able to input a number and, based on what they put in, open a file and copy and paste from it. E.g something like Code: -------------------- Get number from user If number = 1 Open file1.xls If number = 2 Open file2.xls Copy column F from file that was opened Paste into column K of original file -------------------- I'm pretty new at VB macros, and also don't know if I need to be opening a new workbook, sheet or what. Any help really appreciated! Thanks. Mary -- Mary T ------------------------------------------------------------------------ Mary T's Profile: http://www.excelforum.com/member.php...o&userid=30151 View this thread: http://www.excelforum.com/showthread...hreadid=498337 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Files - Macro | Excel Worksheet Functions | |||
Opening Files Using a Macro | Excel Discussion (Misc queries) | |||
Macro for opening files that changes names | Excel Discussion (Misc queries) | |||
Opening Multiple files and Copying the info all to one other sheet | Excel Discussion (Misc queries) | |||
Opening CSV files with VBA/macro | Excel Programming |