I need to know of a way to code for the "Sales Sheet". Right now I have a code that will allow you to select the "Balance Sheet" in the folder on your drive. And when you open the Balance sheet I was planning on it to open the "Long Form" and what ever the "Sales sheet" is. That is why I wanted to know how to look for the Sales sheet.
Do want to be able to select the "Sale Sheet" then have the code run. Or, I can set the code that would allow you select the files that you want to update.