Vba settings file

Log in. Sign up. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.

Solved: VBA - Ways to store some settings. Status This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site. Joined Jan 16, Messages Is there any easy way in VBA to store some settings these would most likely be 2 arrays, a string and a long variable and keep them permanently?

When I say permanently I mean, when the application is closed and then reopened, even after a full restart, the values are reloaded. I'm creating something for Outlook using UserForms and the settings the user chooses on the form need to be saved.

I haven't used file search type code before like this so would like to avoid it if possible. Is it possible to just set a variable and then make it stick permanently?

Will UserForm properties allow this to work? By setting the properties in the form will it hold them? Joined Jul 29, Messages 21, What sort of settings? If these users are on a domain you cancontrol most settings in Outlook with Group Policy. It will be something different to that as I have no access to Group Policy from my end. Its similar to an e-mail checker, i. That's why I suggested a. Keebellah Hans. Trusted Advisor. Joined Mar 27, Messages 6, You could use a text file which is read every time you open the Excel sheet, and that you can also update from Excel as well as manually.

Privacy policy. Saves or creates an application entry in the application's entry in the Windows registry or on the Macintosh information in the application's initialization file. The SaveSetting statement syntax has these named arguments :.

The following example first uses the SaveSetting statement to make entries in the Windows registry or. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. Active 4 years, 2 months ago. Viewed 3k times. Community Bot 1 1 1 silver badge.

Gusti Gusti 13 1 1 silver badge 2 2 bronze badges. Does your text file look like the above, or is it comma separated? Do you want to open and see the file before making changes? Is there a way to do this using excel VBA? I would write Yes and make that an answer, but it would not be very fair to anyone. If you read how to ask and edit your question to show your efforts and where they fail, you'll get much more helpful response from the community.

Add a comment.