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: Samuzragore Mezticage
Country: Saint Lucia
Language: English (Spanish)
Genre: Technology
Published (Last): 8 November 2015
Pages: 36
PDF File Size: 14.52 Mb
ePub File Size: 19.72 Mb
ISBN: 614-6-57602-785-8
Downloads: 13989
Price: Free* [*Free Regsitration Required]
Uploader: Shashicage

Member List Calendar Forum Rules.

eAsFilename HELP

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. We may share certain information about our users with our advertising and analytics partners. Anyone got any good suggestion as to how I could allow users to change the filetype based on what they select with the GetSaveAsFilename dialogue?

Title Optional Gtesaveasfilename Specifies the title of the dialog box. There were no file filters to choose from:. This example displays the Save As dialog box, with the file filter set to text files. FilterIndex Optional Variant Specifies the index number of the default file filtering criteria, from 1 to the number of filters specified in FileFilter.


Selecting NO raises Run-time error ”: Can it be used in an Access module? Help Contact Us Go to top.

eAsFilename – Free Excel\VBA Help Forum

The returned name getsaveafilename include a path specification. Thanks for the help. This is very good functionality. Sign up or log in Sign up using Google. Notify me of followup comments via e-mail.

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

You may have to register before you can post: Login or Sign Up. Jon Fetsaveasfilename 4, 1 17 It started to work immediately, without any changes. In your code write either of these three: Stack Overflow works best with JavaScript enabled.

I would like to be able to use it in Access.

This method may change the current drive or folder. Login or Sign Up.

Afternoon, I’m currently using the following basic code, but for some reason it doesnt actually save to any location. This method returns the selected file name or the name entered by the user. November 2nd, Originally Posted by VoG. If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me.

At the end of this macro I want a save as dialogue that opens up in a default folder with a default filename. Other times I get a more generic syntax error.


There may be times when you need to ask the user to select a location to save a file. You can download the file and code related to this article here. Forums Blogs Articles Groups. Specifies the suggested file name. 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. If so how do i go about checking if a file exsists?

The user can then navigate to the appropriate subfolder getsavessfilename change the name accordingly before saving. If this argument is omitted or greater than the number of filters present, the first file filter is used.


Leave a Reply Cancel reply Your email address will not be published. The example below creates 2 filters a. There are several different methods for creating a save file dialog. Ozgrid is Not Associated With Microsoft. Your email address will not be published.