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.

Author: Daigul Kigarr
Country: New Zealand
Language: English (Spanish)
Genre: Spiritual
Published (Last): 10 November 2011
Pages: 263
PDF File Size: 18.89 Mb
ePub File Size: 7.90 Mb
ISBN: 741-2-79940-686-3
Downloads: 25458
Price: Free* [*Free Regsitration Required]
Uploader: Zulkijin

For additional details, refer to our Privacy Policy. My procedure is not likely to be optimal, but it works. The majority of my users will currently be usingbut we are ungoing a move to As you can see this time the.

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!

Thank you again and all the best. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


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.

We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. Thanks for the help. Can it be used in an Access module?

Line that threw the error when Cancel was not clicked: Help Contact Us Go to top.