I have submitted this request to mrexcel dot com/forum/excel-questions/1048844-better-way-access-2-worksheets.html (I'm too new to post a link, I trying this work around) but feel their answer was not adequate, so I came here. Sorry for the cross posting without notification.
I have 2 workbooks, Roster.xls and Response.xlms. The Response file has a list of last name that need an email address. Roster has the full name and has the email address. I have the code that allows me to find the location of the email address in Roster and insert it into Response. As it stands now, I have to activate Response to get the last name, then I have to activate the roster file to get the email address and then I have to activate the response to place the email. Man, you should see the screen flip back and forth between Workbook.
Questions:
Can I access Roster.xls without activating it or, if not, can I prevent the screen from updating the screen.
Your thoughts are appreciated.
Tom
The code is in Response.xlms:
This code gets the info from roster.xlsPlease Login or Register to view this content.
I have created a routine that shows what is going on. Both Workbooks are open (Roster.xls and Response.xlms). When I activate a Workbooks it moves to the screen's foreground and creates a "flash" during the change. Application.ScreenUpdating does not make a difference.Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks