Variable Word URL Printout

**Lexx Diggler** · 11-27-2008, 04:01 PM

Hi;

I'm in a bit of a predicament;

I have set up a macro which prints a word document stored on my HD, however, i need to be able to change the file im printing within excel easily; is there a way in which i can use a variable URL in the code, i.e. make the macro print the URL stated in cell A1 for example??

Im really struggling with this one so any help would be much appreciated!

Thanks in advance...

**royUK** · 11-27-2008, 04:02 PM

It would help if we could see the code that you are using

**Lexx Diggler** · 11-27-2008, 04:20 PM

Originally Posted by royUK

It would help if we could see the code that you are using

Appologies, thanks for pointing that out; heres the code...

Please Login or Register  to view this content.

I want to make the "sFile" description variable if possible..

Thanks

**royUK** · 11-27-2008, 04:48 PM

Try this

Please Login or Register  to view this content.

**Lexx Diggler** · 11-27-2008, 05:05 PM

Hey thanks for that Roy!; however; this isnt exactly what i was trying to achieve (but nice coding nonetheless! ill use that)

The aim of the macro i want to create is to enable me to issue people with standard templates to use, but with an easy way for them to change the "DOCUMENTS" folder (in which all the project specific word docs are saved, T's & C's etc).

The filenames can stay the same (xxx.doc) but the docs folder needs to be variable as ive about 40 macros printing from the folder.... i want to be able to print the docs using a form button straight from the sheet.... if possible

The code i submitted works ok until i want to set up another "DOCUMENTS" folder for a different project; at the moment i have to edit the URL's manually which takes ages!!

Sorry to sound stupid, im quite new to this, this forum scares me, seems to be some seriously knowledgeable people on here after reading some of the threads...!!

Really interested in learning some tricks though!

EDIT - my first post was wrong, i actually want to make the path variable! sorry!

**Lexx Diggler** · 11-27-2008, 06:37 PM

SORTED!

Please Login or Register  to view this content.

**royUK** · 11-28-2008, 03:53 AM

Please remember to use Code Tags in future

Variable Word URL Printout

LinkBack

Thread Tools

Rate This Thread

Display

Variable Word URL Printout

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions