patgenn123 Posted October 21, 2007 Report Share Posted October 21, 2007 Does anyone know how to save a Word or Excel document without using the dialogue box? I want to name a Word or Excel file from information in a clipboard without having to go to "File", "Save As" and then putting the file in a certain location. The location of the file(after it is saved)will be based on parameters loaded in from the clipboard. Any ideas? Pat Quote Link to comment Share on other sites More sharing options...
joe Posted October 22, 2007 Report Share Posted October 22, 2007 You will need to create an internal Excel VBA macro for the workbook and run it at the point you want to save. Quote Link to comment Share on other sites More sharing options...
patgenn123 Posted October 24, 2007 Author Report Share Posted October 24, 2007 OK. This is a good start, but how can the internal VBA macro grab the info from the clipboard to automatically rename the file? I need a start in the right direction.. Maybe more, but who knows... Thanks! Pat Quote Link to comment Share on other sites More sharing options...
Cory Posted November 2, 2007 Report Share Posted November 2, 2007 I can't tell you how but I have seen commands for this in VBA macros that grab the contents of the clipboard and stuff it in a variable. Another thought is that if the file you're working from could be named c:\temp.doc or something generic like that you could do a CTRL+S and then rename/move-copy the file with ME when it becomes ready. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.