Access vba open file

Should be as simple as possible. Improve this question. Julius Julius 1 1 gold badge 1 1 silver badge 8 8 bronze badges. Same error message. Maybe I have to add some special reference? Sorry just checked it further. The correct syntax is Workbooks.

I get the same error message. I save this file before and this procedure should just open the file for reading. For a better understanding, I have a access database with a form which shows some questions for every question you have to give an answer.

To make sure your answer is not just created by yourself you can add an document or picture where your answer is based on. But if you want to read this file you have to reopen it and this is the point where I get this error message.

Add a comment. Active Oldest Votes. To open a word, excel, jpg, pdf or any file, simple use: Application. FollowHyperlink "path to file name". Improve this answer. Step 5: Once you have the developer tab, click on Visual basic as shown in the below screenshot. Step 7: Enter the code which can open the workbook saved in the D drive of the computer.

Step 8: Run the code by pressing the F5 key or by clicking on Play Button. After running the macro, you will find the excel file is automatically opened. The path mentioned above is quite simple because there are no folders and subfolders to get the Workbooks. The macro will not work even if the Name of the file changes by a single letter.

This makes the Job tedious and it is not error-free as well. As you know the challenges we face in the First method of the change in path and the File name, this method avoids both of the challenges. This method gives the option to browse in your computer to the location where your file is saved and opens that particular Workbooks which you want to open. The first part of this method is Application.

This Part allows you to browse through your computer and select the path where your file is saved. The first part does not open the file which you want to open. There are 5 arguments in the Application. GetOpenFileName but will only look at the basics like we did it in the first method. Now let us try to understand this method with the help of an example. Step 3: Enter the below code. This statement declares the Filename as Variable because here we are not specifying any path or file name because it can change from time to time.

Step 4: Enter the below code. So you merely would like to navigate to a given folder! Well, as usual, there are numerous ways to accomplish this. The first method is to use the FollowHyperlink Method. The code would look something like:. You can use the Shell Function to specify which program to use and pass it whatever variable that application accepts. So for our needs, we can merely use Windows explorer to open the folder we are interested in.

Your email address will not be published. Skip to main content. Looking For Assistance or Customizations?