chrismarshall81
New member
- Local time
- Today, 20:17
- Joined
- Feb 25, 2016
- Messages
- 3
Hi,
I seem to have forgotten a lot of my vba coding knowledge as I haven't used it for years so thought I would reach out for some help
I have a small database that I am using to do some integrity checks to a large datafile on a monthly basis. The name and location of the file changes each month and therefore I would like to know what coding I should put in to be able to click on a button on a form, select the file that I want and have it import into my main data table. If possible I would also like the location of the file selected to appear in a text box on the form but that is not a major need.
Can anyone help?
Thanks
Chris
I seem to have forgotten a lot of my vba coding knowledge as I haven't used it for years so thought I would reach out for some help
I have a small database that I am using to do some integrity checks to a large datafile on a monthly basis. The name and location of the file changes each month and therefore I would like to know what coding I should put in to be able to click on a button on a form, select the file that I want and have it import into my main data table. If possible I would also like the location of the file selected to appear in a text box on the form but that is not a major need.
Can anyone help?
Thanks
Chris
