asked on

Check for tab in another workbook

Hi, if i have a WB in path in

R:\XYZ\BORRIS INFO\CURRENT.XLS

Can i have formula in a cell which contains a an IF, asking, IF current.xls contains tab "Combined Data", "You have not saved file", ""

Thanks

Seamus2626

ASKER

PS i am checking this from another wb called xyz.xls

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Seamus2626

ASKER

problem here Rob, is that when i process my file and Combined Data dissapears, my error message turns to

=IFERROR(('X:\YOK\Boris Info\ME_Voris_Project\ME Downloads\[CurrentMonth.xlsx]#REF'!$A$1),"New Data saved")

Maybe i could use code and a button?

Thanks

Rob Henson

Well that is a change to the original question.

Yes you could use VBA to check if the other workbook includes a sheet called Combined Data.

The code would attempt to select the sheet in the other Workbook and if it produces an error rather than throwing you out of the code it returns an error message.

Thanks
Rob H

Seamus2626

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for Seamus2626's comment #a40229137

for the following reason:

Il repost the VBA Q

Rob Henson

The question was answered as originally worded.

Seamus2626

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for Seamus2626's comment #a40229418

for the following reason:

Sorry! That was meant to be award points!

Seamus2626

ASKER

Trying to award points

Rob Henson

When raising the VBA question, include a link to this question.

About to travel for the rest of the day so may not see the VBA question come in, but if I do I will see if I can make a suggestion.

Thanks
Rob H

Seamus2626

ASKER

Okay, i see, the VBA q was answered quickly by Randy

Thanks Rob

Seamus2626

ASKER

Please award Rob 500 points
Rob Henson2014-07-30 at 09:18:20ID: 40229509

http:#40229509

Thanks