I’ve got a script that I’ve written that does some Excel automation. It takes three spreadsheets, does a variety of vlookups/formatting etc and then saves all the data in one sheet. It’s working fine.
However, the file paths for the three reference spreadsheets within the script are currently static - i.e.:
I want to give my script to a friend, have him create a folder in any location, put the script and his three spreadsheets in the same folder and just run the script so that he ends up with the final spreadsheet in the same folder.
How do you essentially put a ‘.\sheet1.xls’ file path into your script so it will locate the files that are in the same directory as the script (and also output the final data to that folder too?)