VBA problem with table refresh

[mcmunoz]

I don't know what is the problem with my code.

Scenario:
I've use a code that will trigger the table

Please Login or Register  to view this content.

After I've use this code(above) and use another macro (like copy/paste - import new value on each table referring to the header) - the process is very slow. And I don't know why?

Do I need to change my code? or REFRESH the table?

P.S: If I don't use the code above - the process is fast but I cannot change the date. If I change the date the process is slow.

[mcmunoz]

Is there a refresh table all about?

[hulpeloos]

this should work fine , but will error out if one of your request can't be executed or even on some tables where the refresh option is not active.

Please Login or Register  to view this content.

[mcmunoz]

this should work fine , but will error out if one of your request can't be executed or even on some tables where the refresh option is not active.

Please Login or Register  to view this content.

I don't have a refresh table because I don't know how to refresh a table.

[mcmunoz]

My problem is when I run this macro the following macro process become slow.

Like:
dateTable then copyPasteTable import[data]

NOTE:
copyPasteTable macro->import data values base to each there date.

[mcmunoz]

My problem is when I run this macro the following macro process become slow.

Like:
dateTable then copyPasteTable import[data]

NOTE:
copyPasteTable macro->import data values base to each there date.