<div>
still trying to figure this out!!
</div>


<div>
Got this work, thank you all for your help!!
</div>


Got this work, thank you all for your help!!

<div>
<div class="content wysiwyg-content">
I this code in excel, How do I get pass the &quot;password&quot;.<br />
<br />
At this point, click the command button and it open Access and bypass the password and go directly to a form. <br />
<br />
'opens access<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Range(&quot;Q23&quot;).Select<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; ActiveSheet.Hyperlinks.Add<wbr /> Anchor:=Selection, Address:=&quot;Volume.mdb&quot;, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; TextToDisplay:=&quot;Volume.mdb<wbr />&quot;<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp; Range(&quot;Q23&quot;).Select<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Selection.Hyperlinks(1).Fo<wbr />llow NewWindow:=False, AddHistory:=True<br />
&nbsp; &nbsp; Set App = GetObject(&quot;\\Dtcnas-ilsp00<wbr />2\mandator<wbr />y\Analysts<wbr /> - Working Files\Carol\Demo\Volume.md<wbr />b;pwd=OPPs<wbr />;&quot;)<br />
App.Application.DoCmd.RunM<wbr />acro &quot;Macro2CloseSwitchboard&quot;<br />
App.Application.DoCmd.open<wbr />form &quot;Form&quot;<br />
<br />
<br />
&nbsp;Any help would greatly be appreciated!<br />
<br />
<br />
<br />

</div>
</div>


I this code in excel, How do I get pass the "password".

At this point, click the command button and it open Access and bypass the password and go directly to a form. 

'opens access
    
    Range("Q23").Select
    
    
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="Volume.mdb", _
        TextToDisplay:="Volume.mdb"
   
    Range("Q23").Select
    
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    Set App = GetObject("\\Dtcnas-ilsp002\mandatory\Analysts - Working Files\Carol\Demo\Volume.mdb;pwd=OPPs;")
App.Application.DoCmd.RunMacro "Macro2CloseSwitchboard"
App.Application.DoCmd.openform "Form"


 Any help would greatly be appreciated!





Get pass a password-Excel to Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.