unbound text box (1 Viewer)

[dreamz]

hi

i've created a unbound text box and for my default value i've put the path of a spreadsheet i wanna import.

How would i get my macro to select fromt the form as apposed to the default path i put in manually.

 

[Rickster57]

import

If your code for importing uses the form's text box name then a user can put what ever they want in the text box and the import should work.

Make sure you assign a variable to that form field such as :

Dim MyImportFile as string

MyImportFile=Forms![myform].[mytextbox]

Then in your import code use MyImportFile for the file you want to import.

Hope this helps

 

[dreamz]

thanks, it did help.