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

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).

--
Regards,
Tom Ogilvy

"rocket" <rocket@discussions.microsoft.com> wrote in message
news:AFB2EB74-F922-4745-A060-AAA1AB1F6A2A@microsoft.com...
> 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

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("A1").Value
>
> then in other code where you have hard coded values, you can replace them
> with MyVar (as an example).
>
> --
> Regards,
> Tom Ogilvy
>
> "rocket" <rocket@discussions.microsoft.com> wrote in message
> news:AFB2EB74-F922-4745-A060-AAA1AB1F6A2A@microsoft.com...
> > 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
>
>
>