LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Include password in VBA code to open file problem


Hi

I have a workbook that is initially opened by the user with a modifying
password. Then when a macro is run I want to be able to close and then
re-open this workbook without having to input the password again.

I have tried:

Workbooks.Open Filename:="D:name.xls", Password:="My_Password"

but I am still asked to enter the password.

How do I do this?

Paul


--
PaulC
------------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=274042

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
open ftp file with password Kevin Excel Worksheet Functions 1 September 5th 07 05:02 PM
Include password in formula that links to a protected excel file PR2000 Excel Discussion (Misc queries) 1 June 26th 07 07:16 PM
Include a password in VB code. GA Excel Discussion (Misc queries) 6 March 23rd 06 07:36 AM
Password to open file dcknie Excel Discussion (Misc queries) 3 June 29th 05 03:49 PM
Open file without Password Steph[_3_] Excel Programming 1 October 26th 04 08:53 AM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"