Problem with VBA-Excel-Hyperlink and search for strings

[michpapas]

Hello boys and girls!

I am new in VBA and Excel-macros, with only some small programming experience in my past.

So, my project might look very easy for you-and I will be very happy if you have any suggestions.

My project is:

I have to create an excel worksheet "A", that will have the following properties and do these tasks:


0) Cells of A will have values that will be automatically updated, when A is opened, depending on cells of another Workbook "B"

1) From A, access another excel Workbook "B"

2) Go inside a Hyperlink of the Workbook "B", which is another excel Worksheet "C"

3) Inside C, scan a whole column range (let's say A1-A1000) that have certain string values (compare it with some certain strings - let's say Basketball, Football, Volleyball)

4) Count how many results were found, returned True

5) For each one that returned true, check at that row, for a string at another column (let's say colour of ball, green, red, yellow)

6) Count those results and return the percentages (on cells of A) of how many balls were green, red or yellow

7) Also check the date of the moment that A is opened, calculate the difference of days to another cell of C, and return the results on A

Thank you very much for any suggestions,
Cheers