Excel 2010 vba open word file

But it's difficult. My needs are not so big to use such a code. Better to use the method: copy-paste, in my case because its only a simple address 2 or 3 lines.

I can do it with Ctrl-C - Ctrl-V. Your email address will not be published. Copy worksheet information to Word using VBA Google serves cookies to analyse traffic to this site. Information about your use of our site is shared with Google for that purpose. This website uses cookies so that we can provide you with the best user experience possible.

Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. If you disable this cookie, we will not be able to save your preferences.

This means that every time you visit this website you will need to enable or disable cookies again. Toggle navigation. Comments Steve George November 4, at pm. How do I identify an open Word file from excel? That is The Word file is already open when the excel macro is initiated.

Hi all I was using the following code within an AddIn that I created which was working fine with office Application" Wordapp. Interesting when I step through the code in VBA it works fine, it's just when the code is executed from the dropdown menu that I get this error.

Any suggestions? Excel Facts. Pivot Table Drill Down. Click here to reveal answer. Double-click any number in a pivot table to create a new report showing all detail rows that make up that number.

NdNoviceHlp Well-known Member. Joined Nov 9, Messages 2, Thank you for the reply. Unfortunately the document I am opening is still a. Any more ideas guys and girls? Can you clarify what exactly you mean by "when the code is executed from the dropdown menu"? Coincidentally I have just solved the issue, well found a workaround at least. I have entered an application. Thanks for your help guys. HunterN Active Member. Joined Mar 19, Messages Now back in January we moved to Office and the creating of the Word document refused to work or that's what I thought.

Therefore, the second part of this tutorial analyzes both of these methods and goes through each of their parameters. The purpose of this section is to help you get some basic awareness of some of the things you can do when using these methods in your macros. In addition to help you open workbooks using VBA, the Application. GetOpenFilename method allows you to specify the paths and names of particular Excel workbooks. You'll likely encounter situations where knowing this how to allow the user to specify a path and filename can come in handy.

And let's start by taking a look at what is, perhaps, the simplest case of opening an Excel workbook using VBA:. Open method. The Workbooks.

Open method has 15 optional arguments. Each of these 15 optional arguments allows you determine a different aspect of how the Open method opens an Excel workbook. Since taking a look at 15 arguments at once can get a little overwhelming, let's start by taking a look at the most basic case: opening an Excel workbook whose name you know. You specify which workbook you want to open by using the Filename argument. More specifically, the basic VBA statement syntax to open a particular workbook is :.

As shown in the example below, when specifying the workbook's file name, you must provide the full path and name of the file. I explain how to make this easier below. For the reasons that I explain here , this is my preferred syntax.

This workbook is saved in the D drive. As mentioned above, notice that when specifying the filename, you must provide the whole file path, name and extension. The sample file path above is relatively simple. In particular, there's no need to go through several sub-folders in order to get to the sample workbook. Probably not many people are able to remember the exact file paths, names and extensions for the files in their laptop.

And even then, few would want to type the whole thing every time a new Excel workbook is to be opened. In other words: Having the user type the filename without browsing is both:. Let's take a look at the simplest way to do this: replicating the way Excel usually works when you browse the computer drive in order to find the particular file you want to open.

This is the Open dialog box. Excel displays this dialog whenever you browse for purposes of finding and selecting a file to open. You'll probably agree with me that using this method of choosing the particular Excel workbook that you want to open is much easier than remembering the full file path.

Fortunately, you can replicate this way of operating with VBA. More precisely, you do this by using the Application. GetOpenFilename method. The Application. GetOpenFilename method doesn't open the file chosen by the user.

You still need to rely on the Workbooks. Open method explained above for purposes of actually opening the chosen file. The fact that GetOpenFilename doesn't actually open the file makes this a very versatile method. Therefore, in order to open an Excel workbook through the Open dialog box while using VBA, you need to use both of the following methods:. GetOpenFilename method has 5 variables. However, just as we did with the Workbooks.

Open method, let's take a look at a very basic piece of VBA code that allows you to:. This particular statement is a variable declaration statement. The purpose of declaring a variable in this macro is to store the file name chosen by the user. As I explain in this macro tutorial , the Dim statement is the most common way to declare a VBA variable. This variable is declared as a Variant because the Application. GetOpenFilename method can return different types of data.

For purposes of carrying out a closer examination of this statement, I divide it in the following 3 items:. Therefore, it doesn't represent an equality. This item is the reference to the Application. As explained above, this particular method:. FileFilter is one of the different parameters of the GetOpenFilename method. As implied by its name, this argument allows you to specify criteria for file-filtering.

It's an optional argument. However, I include it for purposes of specifying file filtering criteria. In the sample VBA code that appears above and throughout the rest of this Excel tutorial , I use named arguments. However, that's not mandatory. If you don't want to use named arguments, you can use the following statement syntax:. As explained above, FileFilter determines what are the criteria used for filtering files when the Open dialog box is displayed.

In more practical terms, the FileFilter argument determines what appears in the Files of type drop-down list box on the lower-right corner of the Open dialog box. The appropriate syntax of the FileFilter Argument is determined by the following rules :. The purpose of the Workbooks. Open method is to open an Excel workbook. In other words, if the user selects a file when the Open dialog box is displayed, the If… Then… Else statement opens that file.

As explained at the beginning of this Excel tutorial, Workbooks. Open is the method that you'll generally use to open Excel workbooks using VBA. We have already seen the basics of the Workbooks. Open method and its most basic use above. However, in that particular case, I mentioned that this method has 15 different parameters.

So far, we've only checked one: FileName. I assume that, if you're reading this, you want to learn about some more advanced cases of opening Excel workbooks using VBA. In order to do this, let's take a closer look at the Workbooks. Open method and its different parameters. The full syntax of the Workbooks. Open method in Visual Basic for Applications is as follows:. All of the parameters of the Workbooks. Open method, which appear within parentheses above, are optional.

Let's take a look at them! Determines the delimiter character.