Open workbook based on cell value

[gs_triumph]

Hi,

I am trying to write macro that, depending on the value in a particular cell, opens a specified workbook.

What i need is a macro that, when run,checks the value of cells in column GC. If the value is more than zero, opens the workbook specified in row GD. It should check until there is no more data.

GC GD
2 0 book1.xlsm
3 1.07 book2.xlsm
4 0 book3.xlsm
5 3.98 book4.xlsm

I hope that makes sense. Any help would be appreciated.

gs.

[Kenneth Hobson]

Welcome to the forum!

What are the 2nd column numbers?

What path are the workbooks in, thisworkbook.path?

[joao.amancio87]

Hello, attached is an example that will help you.

Example.xls

Below is the code:

Please Login or Register  to view this content.

[gs_triumph]

Thank you very much! Works a treat!

I can do basic macros where i can record the actions, i woiuld not have maged this without you.

Cheers.