Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not able to export data from IE6,7 to MS Excel | Excel Discussion (Misc queries) | |||
export data to Excel?? | Excel Discussion (Misc queries) | |||
Export Excel data to XML | Excel Programming | |||
Export Data from Excel to SQL | Excel Programming | |||
Excel VBA data export | Excel Programming |