Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refresh an Excel workbook from VBA
I want to run a number of scenarios through a business model in Excel.
I have all my input values in an Access table and can load them into the relevant cells of my Excel sheet through Access-VBA. I can also pick the resulting values from my Excel sheet. Only thing I need to do is to refresh the calculations as a result of my new input. How is that done from VBA? I link to my Excel through this code: Dim xlBook As Object Set xlBook = xlApp.Workbooks.Open(path & "\" & filename, 0, True) and then I can access cell values. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refresh an Excel workbook from VBA
you can just add
Calculate for the whole workbook, or [Object.]Calculate where the object can be worksheet or range "RSunday" wrote: I want to run a number of scenarios through a business model in Excel. I have all my input values in an Access table and can load them into the relevant cells of my Excel sheet through Access-VBA. I can also pick the resulting values from my Excel sheet. Only thing I need to do is to refresh the calculations as a result of my new input. How is that done from VBA? I link to my Excel through this code: Dim xlBook As Object Set xlBook = xlApp.Workbooks.Open(path & "\" & filename, 0, True) and then I can access cell values. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to refresh an Excel workbook from VBA
xlapp.Calculate
"RSunday" wrote: I want to run a number of scenarios through a business model in Excel. I have all my input values in an Access table and can load them into the relevant cells of my Excel sheet through Access-VBA. I can also pick the resulting values from my Excel sheet. Only thing I need to do is to refresh the calculations as a result of my new input. How is that done from VBA? I link to my Excel through this code: Dim xlBook As Object Set xlBook = xlApp.Workbooks.Open(path & "\" & filename, 0, True) and then I can access cell values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
How to refresh Share workbook in excel someone can see changes | Excel Programming | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |