Forum Discussion
Boris_Z
Nov 18, 2022Copper Contributor
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 thi...
Charla74
Nov 18, 2022Iron Contributor
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_ZNov 22, 2022Copper Contributor
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.
- HansVogelaarNov 22, 2022MVP
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.