I have in a server dir a wbook with one sheet
My problem is to read and write on this wbook without open it.
For example the wbook is in the path:
READ FROM THE CLOSED WBOOK
read from a macro the value in A1 of the closed wbook
with this condition:
If in the A1 is value "TEST1" goto on the MACRO1
If in the A1 is value "TEST2" goto on the MACRO2
If in the A1 is value "TEST3" goto on the MACRO3
WRITE THE THE CLOSED WBOOK
Simply write in A1 of the wbook closed a value "TEST1"