VBA for Excel, automatic link password protected
- From: "tp" <szostek@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Jul 2005 10:33:10 +0200
Hello!
I have problem with VBA for EXCEL. In formulas there are links to other
files . When it's open it normally connects with other files and everything
is OK, but the other files are open protected with a password, so each time
I have to put the password manually. There are MANY files so it is not very
convenient. All files are protected with exactly the same password.
I use such code:
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LINKSOURCES
How to write the code so that it can automatically use the same password
during
connecting to these files?
Can anybody help me?
thks.
Adam
.
- Follow-Ups:
- Re: VBA for Excel, automatic link password protected
- From: AustinMN
- Re: VBA for Excel, automatic link password protected
- Prev by Date: Re: Printing with Common Dialog Control
- Next by Date: VB5 - WriteProperty Error
- Previous by thread: Simple way to loop a directory's files and put the file's text into string variable
- Next by thread: Re: VBA for Excel, automatic link password protected
- Index(es):
Relevant Pages
|
