Forum Discussion
jamesson_kaupanger
Nov 08, 2019Copper Contributor
Excel macro runs 1/12th as fast when run from Access
I have a macro that I've written to "reformat" some data in Excel (not font types and colors and such, but how the data is laid out in the spreadsheet). I found a macro that records how long it takes...
tsgiannis
Nov 11, 2019Iron Contributor
jamesson_kaupanger Well Excel Automation is not that fast...thats a fact...try hiding the Excel while performing the manipulation...this should help in performance..
- jamesson_kaupangerNov 12, 2019Copper Contributor