You can modify your code to get value from cells like this

Dim MyVar as Variant
MyVar = WorkBooks("Bob.xls").Worksheets("Inputs").Range("A 1").Value

then in other code where you have hard coded values, you can replace them
with MyVar (as an example).

--
Regards,
Tom Ogilvy

"rocket" wrote in message
...
I have set up a button on excel so that when pressed it opens another
application and performs some actions to obtain some data. I used VBA
record
to copy my actions in the other application and used preset figures to use
for inputting. However, I now need to know how to instead use figures I
will
be inputting in cells in excel. any help would be greatly appreciated.

thanks