Pls help! How can i direct and open a file based on the value in the cells?

[htoh2]

Greetings to the expert!


I'm a novice in visual basic macro and would like to seek help from the experts. Pls kindly help me with it, thank you in advance.

These are some sample data:

In my source.xls, i have 2 columns of data with value as shown below:


Functions | Business Positions
Procurement Manager



And i want a macro that runs like that:

When the value e.g. in range("A2") under column "Functions" = "Procurement"
AND values e.g. in range ("B2") under column "Business Positions" = "Manager"

THEN, it will direct to the workbook procurement.xls

I had tried to use IF..ELSE statement but to no avail.

Please guide me on this.
Thank you very much

Your help will be greatly appreciated

Best regards,
htoh2

 

[Andrew Poulsom]

You can use the HYPERLINK function. What's the full path to your workbook?

 

[htoh2]

Hi, thank for your quick response

This is my full path to the document:

C:\Documents and Settings\htoh2\Desktop\BookA.xls

Thank you for your kind assistance

Best regards,
htoh2

 

[Andrew Poulsom]

You said it was named procurement.xls. How does that relate to BookA.xls?

 

[htoh2]

Hi

Sorry for my mistake!

It was my mistake. It should be C:\Documents and Settings\htoh2\Desktop\procurement.xls

By the way, the problem is solved!

thank for your kind attention once again.


Regards,
htoh2