I am having a Strange situation which I was hoping someone could explain why it is occurring. I am trying to use a simple macro variable to count from 1 to 57 in order to import 57 files. I initially was given files with the name "Simple_toothhistory_1" "Simple.....2" etc. I used the variable j and had a working macro using "C:\location\Simple_toothhistory_&j..csv" An issue was found with the files and they were re-converted into csv files with a new name "Prac1_simple_toothhistory" "Prac2_....." etc. I tried to use the macro"C:\location\Prac&j_simple_toothhistory..csv" but with no luck. I also tried adding an additional underscore "C:\location\Prac_&j_simple_toothhistory..csv" But this also did not work. I have at this point renamed all 57 files 😞 But I was hoping to understand why it is working at the end but not within the file name! Thanks!!!
... View more