Macro opens word doc, want file path referenced from spreadsheet

[Butcher1]

I have this macro (I only posted the sections that contain a file path) that will open and modify a word document. I would like to have the file path inserted in into the spreadsheet, the sheet Admin Sheet cell A2. The purpose is so that I can give it to someone else and they can insert the file path for their own word doc and not have to actually go into the macro code to change it.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Crooza]

Totally untested as I don't have your full code or your spreadsheet but give this a go

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Butcher1]

It didn't work. This macro would be executed from a different sheet than the "Admin Sheet" where the file path is, does the macro need that mentioned?

Please Login or Register  to view this content.

With this line of code, if the user decides to name their word document something other than journal, wouldn't it fail to function for them?

[amphinomos]

This probably doesn't directly resolve your issue but I've found that using the GetOpenFilename method works well as it doesn't require any typing from the user (thus mistakes & error handling).

Please Login or Register  to view this content.

[Crooza]

It didn't work. This macro would be executed from a different sheet than the "Admin Sheet" where the file path is, does the macro need that

You'll need to name the sheet then I'm that same line of code above

So range("h2") will look like range("sheet1!h2") where sheet1 is your sheet name

[Butcher1]

Please Login or Register  to view this content.

Here is my code in it's entirety. I am guessing I am misunderstanding something you said. I am getting an error at this line,

Please Login or Register  to view this content.

[Crooza]

Sorry gave you a bum steer.

Try this

Please Login or Register  to view this content.

Merry Christmas

[Butcher1]

That got it to work, thank you! Merry Christmas to you too.