Hi guys,
Sorry if this has been asked and answered, but I couldn't find it anywhere. I am creating a VBA invoice for my newspaper carriers (I am the manager of the company that delivers them) for when they do each other's papers. I have gotten everything to work so far and I am now programming "clear" and "reset" buttons. I have the "clear button working. I just sets the values of the cells on the active sheet to their original values. I can't seem to find a way to reset the entire book. The problem is if a carrier has already delivered a route on a certain day, the spreadsheet automatically creates a new sheet for the invoice. When the user clicks the "reset" button, I wanted everything to go back to the way it was on the original file. I had thought of trying to open the original file and discard changes, but I won't know the filename on the user's computer so I can't just call the file and open it. Is there any way to either call the file dynamically or find the file on the user's computer? It also has to be compatible with 2003 as a lot of my carriers have very old computers.
Thanks in advance
kazlady
Sorry if this has been asked and answered, but I couldn't find it anywhere. I am creating a VBA invoice for my newspaper carriers (I am the manager of the company that delivers them) for when they do each other's papers. I have gotten everything to work so far and I am now programming "clear" and "reset" buttons. I have the "clear button working. I just sets the values of the cells on the active sheet to their original values. I can't seem to find a way to reset the entire book. The problem is if a carrier has already delivered a route on a certain day, the spreadsheet automatically creates a new sheet for the invoice. When the user clicks the "reset" button, I wanted everything to go back to the way it was on the original file. I had thought of trying to open the original file and discard changes, but I won't know the filename on the user's computer so I can't just call the file and open it. Is there any way to either call the file dynamically or find the file on the user's computer? It also has to be compatible with 2003 as a lot of my carriers have very old computers.
Thanks in advance
kazlady