Solved

Macro stopping on different drive

Posted on 2013-11-08
3
162 Views
Last Modified: 2013-11-08
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
0
Comment
Question by:Justincut
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39633446
Hi,

Yhave to give the UNC File Path which is the same for both of you

Open Windows Explorer / Computer on the side of the Drive letter is the UNC address which is like
\\something.in.the.address\

and use it to replace the drive letter

Regards
0
 

Author Comment

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

so how do I adapt the code?
0
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 39633533
Hi,
In Windows 7 you can select 'network location' if you right click the columns in explorer

to have the network location

Regards
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Manipulate Data Quickly 2 15
formattig excel from access 3 18
Add macros on Open 9 33
Added a column screws up code 5 17
What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now