Having Two Excel Workbooks Open at a Time

Hello, to all ...... This is my 1st post here in this forum.

My question is if I have two open Excel workbooks without knowing the either path of each workbook and there named differently but in the same folder.

Is it possible to reference one to the other workbook only in sheet1 of each workbook for matching cells from, or the other with out know the any file path?

I would either manually open the two workbooks which is ok. or maybe a popup and enter there names might be ok.

If so, could you please help me out.

I like only to highlight matching cells. Weather they are text or numeric values in the cells. only thru C11:H25 Except for blanks cells.

I not sure if it can be done. I been trying so many codes on the net and in other forums but cant accomplish this.

Thanks So Many, Tom

This prompts you to open two workbooks then compares C11:H25 on sheet1 of both opened workbooks.

Please Login or Register  to view this content.

Hi ,Thanks for all the quick replies.....

AlphaFrog, I believe you are on to somthing but its not working for me as of yet.

I place your code in a module and ran it. It will promt you to open another file ok.

But does not highlight any cells nor a message box does not appear.

After I open a second workbook from the folder it promts again. When canceled button is clicked to not open a thrid workbook I think it fails and doesnt highlight anything.

the code does not error

Any ideas from this write back


Regards Tom

AphaFrog, That is Awesome, Many Many Thank's...... I been in other forums ect... trying to mend codes and ask for help for weeks now.

This is really special for me thank's to you! Plus, with a quick response time. I will try this out completely. I will let you know how I make out.

Thank's a million and As said I can't thank you enough Tom

Hi once more,
Then I will not bug you anymore with this code, Can the highlighted cells be unhighlighted upon closing the workbooks?

Regards Tom

If you don't save the workbooks, the highlights are lost.

Or just record a macro. While recording, select range C11:H25 and then select no fill from the menu interior color-picker.

Thanks AlphaFrog, I will try this out. I never recorded a macro but I will try.


Regards, Tom

AlhaFrog, I recorded My 1st macro

It certainly work upon closing the workbooks.

Also,
I created a masterbook as your 1st Reply code was to be

This works much better than I even wished for now I know what you had meant.

Thank's for all your help with this

"Considered Accomplished "
Tom