export data from excel using VBA

[Guest]

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

 

[Tom Ogilvy]

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

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

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

 

[Guest]

thanks Tom

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

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

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