Hi all,
I'll spare you the long version of what I'm building, I have most if all of that working to spec. I know how to use the docmd.outputto without specifying a save to location in order to prompt the user to select a location and file name...what I don't know how to do is save that name and path so I can call it later in the function to do some manipulation on the output excel file. Is it even possible to do what I'm asking, or do I need to revisit hard coding in the file path and name?
Bookmarks