Open and impirt file ?

[shariefoo]

Hi all,

Can anyone help with this ? I created a button that imports a file normaly using Macros. But i was thinking....

Is there a way where you can click a button and then browse for the file ?? you know like choosing the location of the file and then selecting it ?

Thanx

 

[mvos]

You can use an api call

See here

 

[shariefoo]

Thanx.. But

Thanx for the link. IT WORKS PERFECTLY.

However i am facing another problem.
How can you import the seleted file.

I mean what i am getting now is "Please select the file" and then nothing happens.. How can i import that file into my form ?

 

[mvos]

Once you have selected the name of the file, you can use that to do whatever your macro did to import.
The only difference is you'll need to do it in vba.