CookieMonster76
Board Regular
- Joined
- Apr 30, 2015
- Messages
- 200
Hi
I have a spreadsheet that has a table that is linked to an external database.
I've recorded the refreshing of the table manually, but i'd like to to is as part of my VAB script.
The extract of the code I have is this:
AND (oa_nltrans_0.period<=2)
The "2" refers to month 2 - I'd like the end user to be able to type in a cell (Say A1) any number (say 3) and it then refresh the table to period 3.
Basically how do I replace the absolute value "2" with a cell reference?
Thanks
Paul
I have a spreadsheet that has a table that is linked to an external database.
I've recorded the refreshing of the table manually, but i'd like to to is as part of my VAB script.
The extract of the code I have is this:
AND (oa_nltrans_0.period<=2)
The "2" refers to month 2 - I'd like the end user to be able to type in a cell (Say A1) any number (say 3) and it then refresh the table to period 3.
Basically how do I replace the absolute value "2" with a cell reference?
Thanks
Paul