Because people can't save files properly for me, I had to automate saving for them, based on cell data, to keep our files organized. I pieced this together a few years ago and it has worked great. On a single computer. But, now I'm trying to use it in conjunction with the Google Drive. My problem is static destination doesn't exist anymore. Every computer saving there will have a different location.
(ex "C:\users\wkemmerer\Google Drive\Summaries" on one computer and "C:\users\CW313-B\Google Drive\Summaries" and so on)
With a batch file I just use "%~dp0Summaries" and I would be fine. But I know that isn't going to work in VB. So... What can I do here to deal with the floating directory names? Keep in mind, this isn't off of a template. I need to be able to open the last saved file, make this quarters changes, and SaveAs again. Creating an organized history.
Bookmarks