<div>
it says &quot;finance on 'Cluster Node 2 (sgbmmg001) DFS,Bltechley (mercury)' (v:)&quot;<br />
<br />
so how do I adapt the code?
</div>


it says "finance on 'Cluster Node 2 (sgbmmg001) DFS,Bltechley (mercury)' (v:)"

so how do I adapt the code?

<div>
Hi,<br />
In Windows 7 you can select 'network location' if you right click the columns in explorer<br />
<br />
to have the network location<br />
<br />
Regards
</div>


Hi,
In Windows 7 you can select 'network location' if you right click the columns in explorer

to have the network location

Regards

<div>
<div class="content wysiwyg-content">
Hi Guys, I have a Macro, which is on the w drive, but if my colleague wants to run it on the v drive, it will stop. How do you find out the exact server name so everyone can use the same program? Here's my code:<br />
<br />
&nbsp; Workbooks.Open Filename:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;w:\Treasury Finance Controls\Ledger v SS Recs\Recs - Murex_GBO\2013 Recs\11_2013 Recs\OBS\Full Ledger\&quot; &amp;&nbsp;PrevDay &amp;&nbsp;&quot;\ALM OBS &quot;&nbsp;&amp; PrevDay &amp;&nbsp;&quot;*.xlsx&quot; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; , Origin:=xlWindows<br />
&nbsp; &nbsp; Rows(&quot;3:3&quot;).Select
</div>
</div>


Hi Guys, I have a Macro, which is on the w drive, but if my colleague wants to run it on the v drive, it will stop. How do you find out the exact server name so everyone can use the same program? Here's my code:

  Workbooks.Open Filename:= _
        "w:\Treasury Finance Controls\Ledger v SS Recs\Recs - Murex_GBO\2013 Recs\11_2013 Recs\OBS\Full Ledger\" & PrevDay & "\ALM OBS " & PrevDay & "*.xlsx" _
        , Origin:=xlWindows
    Rows("3:3").Select

Macro stopping on different drive

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.