Logically thinking:
I do not need any connections and external data after importing CSV using presented method above.
Query tables can not be refreshed after using importing code like that.
can anybody confirm?
So should I delete connection created and also named range created?
If Yes how to do this?
After deleting named range query table has no connection inside in VBA code and this part of code causes error:
I am getting queryTable is not valid.
When i deleted WorkbookConnection i am getting error: Workbook Connection has been deleted.
How to do it properly?
p.s. powerquery is not solution for me here because i would have to build queries formulas on the fly from code and this works only from 2016 Excel
Please help,
Jacek
Bookmarks