I have this idea that I could use a text box entry as a document object which would become the save as file name, but my idea of how it should work and reality appear to be two different ideas.
I'm thinking this would be an update event, the textbox is filled out, and as soon as it is, the file is automatically saved into a destination folder of my choosing with the textbox text already in the save as dialog. Two problems- I can't seem to figure out how to store the text, and the save as dialog is not showing up, perhaps because I am not sure how give it focus or show it on top of my own user form dialog. Any suggestions?
*************************************
In an Information Age, knowlege is no longer power. Knowing the difference between useful data and useless data, THAT'S Power! -Me
************************************