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):||10 November 2011|
|PDF File Size:||18.89 Mb|
|ePub File Size:||7.90 Mb|
|Price:||Free* [*Free Regsitration Required]|
If you need assistance escel your code, or you are looking for a VBA programmer to hire feel free to contact me.
Solved: eAsFilename question
If you excek to save an excel file using that path you will end up with an unrecognized file type:. Interesting…I amended this code so that instead of the filename being blank, it returns the ActiveWorkbook. If the user chooses a file name, the example displays that file name in a message box.
For instance, if your code sets out the following: Do you want to replace it? This method also has some pros and cons:. Read about this change in our blog post. ButtonText Optional Variant Macintosh only.
eAsFilename – Free Excel\VBA Help Forum
You can also subscribe without commenting. The macro cannot be run. Thanks for the help so far!
Any help would be greatly appreciated. Easy to get working and modify to suit my individual needs. There was a problem with Example 1. There the VBA is a bit translated, thus the saveName is translated to Falsch and not False as in the rest of the world.
Sign up or log in Sign up using Google. 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. We may share certain information about our users with our advertising and analytics partners.
Any help would be appreciated! This string passed in the FileFilter argument consists of pairs of file filter strings followed by the MS-DOS wildcard file filter specification, with each part and each pair separated by commas. Resources saved on this page: I must have gotten the information I needed from Google, but if anyone wants, I could try to remember which project it was, and hunt down the code.
Share it with others Like this thread? Originally Posted by VoG.
Line that threw the error when Cancel was not clicked: Help Contact Us Go to top.