twiceborne
New Member
- Joined
- Jul 17, 2010
- Messages
- 1
I'm looking for some specific assistance regarding the webiress excel add-in feature. Those familiar with the add-in would know you can import historical time series of share prices and these can be refreshed or updated by double clicking the particular cell which is set to retrieve the information. As your spreadsheet increases in size, this double clicking on a daily basis becomes tedious. I've attempted to create a vba macro to automate the process. Here's a generic example with commentary.
Sub RefreshRawData()
Worksheets("HistoricalData").Activate
'Activates the spreadsheet tab containing the data to be refreshed
Range("A1").Select
'Targets the particular cell to be double clicked
Application.DoubleClick
End Sub
There appears to be a problem. I believe it's related to the cell not being identified as an object, so although the double click command occurs it doesn't provide the desired result. Thus, it doesn't refresh. I'm wondering if other users have found a way around this.
Sub RefreshRawData()
Worksheets("HistoricalData").Activate
'Activates the spreadsheet tab containing the data to be refreshed
Range("A1").Select
'Targets the particular cell to be double clicked
Application.DoubleClick
End Sub
There appears to be a problem. I believe it's related to the cell not being identified as an object, so although the double click command occurs it doesn't provide the desired result. Thus, it doesn't refresh. I'm wondering if other users have found a way around this.