I've put together a macro, that transfers the data from MS Access database into prepared MS Excel Worksheet.
As a part of this code, I've added the line below:
which makes sure, that all the data, that are copied over into the Excel (within the range C10:K100) are formatted as numbers (not formatted as text as would be the case without this line).
Please Login or Register to view this content.
However, once I added new quarterly data into the Access database, macro breaks down referring to the line above and giving this error message:
Would any of you had an idea, what might be causing these break downs? Before the last update, it worked just fine...
Run-time error '6':
Thank you for any help!