Forum Discussion

Boris_Z's avatar
Boris_Z
Copper Contributor
Nov 18, 2022

Wanna try to copy and filter other csv files data

Dear experts,

 

I tried to create a macro with index sheet and several sheets(a,b,c sheet etc.).

The index sheet described another csv file's postion and name(names T_data).

And I want to let this macro read the index and filter  T_data.csv first then copy the data and paste to a,b,c sheets.

 

But I met a problem here, when trying to run the function of copy and paste data to different sheets, it always unsuccessful to finish this step.

 

Hope experts could give me a hand to make it success.

Thanks all.

Macros and VBA
  • Charla74's avatar
    Charla74
    Iron Contributor
    Nov 18, 2022
    Have you tried running your VBA step by step (F8 from the VBA window)? This usually helps me identify where / what the issue is.
    • Boris_Z's avatar
      Boris_Z
      Copper Contributor
      Nov 22, 2022

      Hi, Charla74

      It shows fail to execute '53': could't find the data.

      In this way, I want to ask experts for some references or informations about filter, copy, and paste from other excel in VBA or template.

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Nov 22, 2022

        Boris_Z 

        Runtime error 53 indicates that the path and filename is not correct. So you'll have to check those very carefully - even the tiniest spelling error in the path or filename will cause this error.

Resources