Results 1 to 6 of 6

Accessing multiple workbooks through a macro

Threaded View

Raman325 Accessing multiple workbooks... 06-29-2005, 10:58 AM
Rich_z The easiest way to see how to... 06-29-2005, 11:08 AM
anilsolipuram suppose what a.xls is the... 06-29-2005, 11:08 AM
Raman325 Thanks, that fixed it. One... 06-29-2005, 11:33 AM
anilsolipuram yes you can use for... 06-29-2005, 11:37 AM
Raman325 Great, thanks. I may have a... 06-29-2005, 11:43 AM
  1. #1
    Registered User
    Join Date
    06-29-2005
    Posts
    46

    Accessing multiple workbooks through a macro

    Hi guys,

    Just so that you know in advance, I am a beginner at writing macros. In fact, this is the first macro I've tried to write. Basically I have two workbooks and I would like to access both of them through a macro that I plan on running on one of the workbooks. I'm not even sure where to look, and I know the first workbook can be accessed through ThisWorkbook, but I'm not sure how to get to the other one. Can anyone help? Thanks in advance.

    PS - Both workbooks are open in Excel and if possible I would like to be able to access a cell selection I have made in the second workbook, but it is not imperative.

    Raman
    Last edited by Raman325; 06-29-2005 at 11:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1