There may be times when you need to ask the user to select a location to save a file. This can be done using a save file dialog. Keep in mind. Morning All, I have a macro that modifies a standard template. At the end of this macro I want a save as dialogue that opens up in a default. Trying to set filename to cell A1 Value, but this does not work. what am I doing wrong please. TY Sub Move_Copy_Save() Dim varResult As.
|Published (Last):||4 September 2006|
|PDF File Size:||17.40 Mb|
|ePub File Size:||7.70 Mb|
|Price:||Free* [*Free Regsitration Required]|
Can you point me to the bit you were trying to show me? The code below opens a save file dialog with getsaveasfilenam. Does this sound about right? All times are GMT I’m trying to set a path location so the user can select a file from that location and copy “A1” at the file name.
Email Required, but never shown. Thread Tools Show Printable Version. Resources saved on this page: Sign in to give feedback. Interesting…I amended this code so that instead of the filename being blank, it returns the ActiveWorkbook. Using the GetSaveAsFilename dialog box, is not a save function, it is used to get the string you want to save as, you will still have to use a saveas line to complete the action.
Originally Posted by VoG.
The code below runs fine, BUT, it isn’t actually saving the file. I can see it in the library with I press F2 and search for getsaveasffilename, but when I enter it into code, no intellisence and I get and I get a compiler error — syntax error. Note the save file dialog will not actually save the file.
Last edited by Getsxveasfilename ; November 2nd, Trying to set filename to cell A1 Value, but this does not work.
GetSaveAsFilename – Daily Dose of Excel
Thank you very much. Specifies the suggested file name. Ok I’ve kind of got somewhere with this.
I have code, that only runs when a user chose “Save As”. I’ve populated the “” with the desired filename prefix and this now works great. For example, the following string specifies two file filters, text and addin: I’ve got this to work now, but I get the dialogue box asking if I’m sure I want to save as a macro free workbook.
I’ve been thinking, to use ActiveWorkbook.
Results 1 to 7 of 7. Easy to get working and modify to suit my individual needs.
Post as a guest Name. Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting. I’m very much a novice when it comes to VBA! Use code tags around code. Last edited by k13r4n; at Other times I get a more generic syntax error. Leave it to Microsoft…. Last edited by Artik; at This example displays the Getsaveasrilename As dialog box, with the file filter set to text files. I feel stupid, I didn’t think to use variant. Hi Davesexcel, think I was typing as you posted.
vba – Cancelling GetSaveAsFilename – Stack Overflow
Thank you – I will do. I agreed to these rules. Just like with GetOpenFilename, you can test whether the result getasveasfilename False to determine getaaveasfilename the user clicked the Cancel button.
The problem I came across was a type mismatch while checking if the user clicked on Cancel when he did not do that. And on Windows, it does not work the way the help claims. Ozgrid is Not Associated With Microsoft.