Macro to automatically import an excel file in a certain poisition???

[lere]

Hello everyone! I'm working on Access trying to create a system to elaborate orders of a small company and generate offers.
I'd like to create a Macro connected to a button which enables the user to automatically import datas from an excel file without specifying which excel file : in other words, I want to tell the system just where to grab the file and not which file, because the button should work for multiple files (orders) that I recieve and not just one, or, eventually, I want t be able to choose which file to import after I click the button.
I'm sorry for my english! I hope you can help me


R.

[ranman256]

you cant have it both ways,
do you want to pick the file ?
or
import all files in the folder?

the macro can do either.

[lere]

I'd prefer to pick the file!

[aytee111]

Here are some step-by-step instructions: http://smallbusiness.chron.com/impor...cro-42538.html

[lere]

Thank you, but that doesn't answer my question: I already know how to import a file with a macro, what I wanna do is Create a Macro which imports a file in a specific folder, without saying which file, meaning that I can change that file in that folder and the macro still opens it.

[aytee111]

I am not a macro user, but after some research I have found that this cannot be done in a macro. If you want to be able to browse for a file then it has to be done in VBA. Another way is to prompt the user for a file name and they type it in.

[lere]

Thank you! and how can I write in VBA in Access? and then Create a sort of "BUTTON" that enables me to choose which file to import?

[aytee111]

First, convert your macro to VBA (there is a button for that). Then use this code: http://www.minnesotaithub.com/2013/0...cess-with-vba/
In VBA, you would add this:
Dim FileName as String
FileName=SelectFile()
If IsNull(FileName)
MsgBox "Cancelled"
Else
....import the file
End If