Automation error from RTD
I am trying to snapshot data that comes from a RTD feed. My code
iterates through a bunch of rows and inserts the data into a datbase. It works at times for the first record but when I believe when the fields change, the code crashes and I get an automation error. My thought, therefore, was to snapshot using a macro, place the data in a separate place, iterate through the rows, and then do it again. However, is there a way to get around the automation error? What is it? |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com