Hello,
I have a form on an excel file. On the form, there are buttons to run reports using VBA. The data is stored in a Excel tab on the same file, pushed through an Access DB, and the results are spit back out onto the original Excel tab with the form. In order to run any report, the VBA needs to read the location of the Access DB which I typed in cell D1. The problem is that when I run a report, the DB location text in D1 moves over a couple cells to H1. I have to keep moving the text back to cell D1 in order to run another report. Its a tad annoying since I have to run multiple reports quite often. Is there any way I can make sure that the DB location text never moves from cell D1? Thanks
Bookmarks