C
Colin Steadman
I have a template that connects to a database in order to produce and
automated quote.
The user is likely to print the finished quote and then request
another. Because of this I need to store their username and password
somewhere between quotes. I have therefore written an AntoNew macro
to get username and password when the template is first opened.
Once the template is open, nothing happens until the user clicks a
quote button. When the quote button is clicked the main macro needs
the username and password in order to connect to the database.
The problem I have is that I dont know how to store the username and
password within Word between getting it from the user and the user
clicking the quote button.
Any ideas? I've toyed with encrypting it and storing it in the
registry, but I'd much rather have word store it somewhere and avoid
the registry altogether. Can this be done? Is it possible to create
a custom property within a Word document for this kind of thing?
TIA,
Colin
automated quote.
The user is likely to print the finished quote and then request
another. Because of this I need to store their username and password
somewhere between quotes. I have therefore written an AntoNew macro
to get username and password when the template is first opened.
Once the template is open, nothing happens until the user clicks a
quote button. When the quote button is clicked the main macro needs
the username and password in order to connect to the database.
The problem I have is that I dont know how to store the username and
password within Word between getting it from the user and the user
clicking the quote button.
Any ideas? I've toyed with encrypting it and storing it in the
registry, but I'd much rather have word store it somewhere and avoid
the registry altogether. Can this be done? Is it possible to create
a custom property within a Word document for this kind of thing?
TIA,
Colin