| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing multiple workbooks through a macro
Hi guys, Just so that you know in advance, I am a beginner at writing macros. I fact, this is the first macro I've tried to write. Basically I have tw workbooks and I would like to access both of them through a macro tha I plan on running on one of the workbooks. I'm not even sure where t look, and I know the first workbook can be accessed throug ThisWorkbook, but I'm not sure how to get to the other one. Can anyon help? Thanks in advance. PS - Both workbooks are open in Excel and if possible I would like t be able to access a cell selection I have made in the second workbook but it is not imperative. Rama -- Raman32 ----------------------------------------------------------------------- Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474 View this thread: http://www.excelforum.com/showthread.php?threadid=38315 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Workbooks using same macro | Excel Discussion (Misc queries) | |||
| Need Help Creating a Macro Multiple Workbooks to One | Excel Worksheet Functions | |||
| How do I run a macro program for multiple workbooks at one time? | Excel Programming | |||
| Help with Macro (copying data from multiple workbooks) | Excel Discussion (Misc queries) | |||
| Opening Multiple Workbooks from a macro with a twist | Excel Programming | |||
Threaded Mode
