I can reference the files if I keep the files in the same directory as the excel file that is running the macro. I just wish there was some way of getting references to the file on the NAS
I am trying to reference cells in Excel to Excel file on a NAS. I need to take the file names the user enters in and put them cell to have those equal the values. Is this the best way of doing this? I ...