[ExcelVBA] Swap Active Workbooks

 

Hi

I am working on a macro to copy data from one spreadsheet to another. All file names are variable, but the structure of the data is not.

My goal is to have the macro run and simply jump back and forth between the two files to process the data. These will be the only workbooks opened.

Is there a line of code to swap focus between active workbooks (almost a relative reference) without using a filename?

Thanks
David

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___