Importing CSV into workbook and creating listobject

Hi Guys,

i am using this function:

Please Login or Register  to view this content.

to import CSV into main workbook.

what i want to do is to listobject to used range:

Please Login or Register  to view this content.

i am getting error:

Screenshot_18.png

Why this is happening? I am cleaning last created connection in function.
Please help,
Jacek

What is interesting.

Here:

Please Login or Register  to view this content.

ThisWb.Connections.Count ==> before run this = 1, after = 0 (so it seems to be working).

Please Login or Register  to view this content.

i added this code to check if in worksheet when i imported data i have still connection...
And...it is!

So how to explain this "Excel Magic" ?

Jacek

Hello,

can anyone help why this statement is not deleting last connection?

Please Login or Register  to view this content.

Jacek

Hello,

up

please help and explain

Can anybody help?

Jacek

Crossposted here:

https://www.mrexcel.com/board/thread...ction.1132919/