open document with parameter from web

[Sean McPoland]

Hi everyone, and many thanks in advance by the way...

Office 2003...

I have a intranet that has a word document as a link for
opening....

I want to pass a parameter with the document that can then
be used within the word document to get its data
dynamically etc and fill in the form;

does this make sense?

for example - in the web page I want

click to open this document --> "word.doc parameter"

then (providing user has word and selects Open) the
document_open macro runs to get the parameter value and
fill in the data

is this possible and how do I do it?

Many thanks once again
regards
Sean

 

[Jean-Guy Marcil]

Bonjour,

Dans son message, < Sean McPoland > écrivait :
In this message, < Sean McPoland > wrote:

|| Hi everyone, and many thanks in advance by the way...
||
|| Office 2003...
||
|| I have a intranet that has a word document as a link for
|| opening....
||
|| I want to pass a parameter with the document that can then
|| be used within the word document to get its data
|| dynamically etc and fill in the form;
||
|| does this make sense?
||
|| for example - in the web page I want
||
|| click to open this document --> "word.doc parameter"
||
|| then (providing user has word and selects Open) the
|| document_open macro runs to get the parameter value and
|| fill in the data
||

Why can't the Document_Open read a Document Variable instead? Would that
work?

If not, How would that parameter be set? Where does it come from?
What is this Data you are referring to?
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Sean McPoland]

Bonjour Jean-Guy,

commont alais vous, Bien? Pardon le francais.....

A document variable would not work as the parameter is a
variable value...as in from a select list.

for example a user selects a job profile from the intranet
(which is stored on a database) and wants to print it -
the job profile key is in a select list. Clicking on the
link opens the document which should accept the key
parameter, retrieve the data and make it available for
printing.

I hope that makes my requirement clearer,

basically I want to

open a document with a parameter which the document
accepts

like word can accept a parameter of document name...


regards
Sean

 

[Jean-Guy Marcil]

Bonjour,

Dans son message, < Sean McPoland > écrivait :
In this message, < Sean McPoland > wrote:

| Bonjour Jean-Guy,
|
| commont alais vous, Bien? Pardon le francais.....
|
| A document variable would not work as the parameter is a
| variable value...as in from a select list.
|
| for example a user selects a job profile from the intranet
| (which is stored on a database) and wants to print it -
| the job profile key is in a select list. Clicking on the
| link opens the document which should accept the key
| parameter, retrieve the data and make it available for
| printing.
|
| I hope that makes my requirement clearer,
|
| basically I want to
|
| open a document with a parameter which the document
| accepts
|
| like word can accept a parameter of document name...
|
|

If I understand correctly, you have a Web-based select list from which the
user selects a value. Then, after clicking on a hyperlink to launch a Word
document, you want to populate the said document with data from a database
based on the key word that was selected on the Web?

Sounds awfully complicated. Since you will be opening the document anyway
why not pop up a userform when the document opens? Let the user select the
job profile key from within the document after it is opened instead of
before. This way all you need is some very simple VBA code. Otherwise, I
think you will need some complicated scripting on your Web page... if it is
at all possible...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org