export data from excel using VBA
 

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

export data from excel using VBA
 

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

export data from excel using VBA
 

thanks Tom

"Tom Ogilvy" wrote:

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