psw
09-21-2006, 04:00 AM
Hi to everyone, i need your help. I have a problem.
I have VBA function, which connects to Oracle database and returns value from some select, e.g. select sum(inv_value) from sales.
1. User in location 1 connects to database and recalculates spreadsheet. Values are OK.
2. Then user sends this spreasheet to another location, where there is no possibility to connect to that database.
3. Then user2 in location 2 has to input some values manually, in cells without any formula's. And then, when user2 accidentally runs recalculating of sheet or cell formula(s) my VBA function returns #ARG error.
Is there any way to retain original value of cell, which has a formula, when functions returns #ARG error (because of no connection) ??? Thank you in advance (and sorry for my terrible english).
Piotr
I have VBA function, which connects to Oracle database and returns value from some select, e.g. select sum(inv_value) from sales.
1. User in location 1 connects to database and recalculates spreadsheet. Values are OK.
2. Then user sends this spreasheet to another location, where there is no possibility to connect to that database.
3. Then user2 in location 2 has to input some values manually, in cells without any formula's. And then, when user2 accidentally runs recalculating of sheet or cell formula(s) my VBA function returns #ARG error.
Is there any way to retain original value of cell, which has a formula, when functions returns #ARG error (because of no connection) ??? Thank you in advance (and sorry for my terrible english).
Piotr