path change

  1. E

    My Dir is not working

    When i change the sheet i need to go to a different path. But the Dir does not work?? This line shows "" strFolder = Dir(strPath, vbDirectory) Private Sub OpenFolder_Click() Dim SourcePath As String Dim SubPath As String Dim strFolder As String Dim strPath...
  2. C

    VBA Code to path based on a cells contents.

    I have a VBA Code that retrieves info from a path that is in the VBA coding itself. I need to be able to let other users change the path regularly with having to know how VBA works. I would like it to be able to read the path from a cell where the user can paste the path (cell L2) and not have...
  3. W

    Good practice for workbook referencing and storing files

    Hello! I'm pretty new to VBA and was hoping someone could give me good practices for how to reference workbooks. My main concern is that if I write a lot of code that references different workbooks with a full file name path, if I were to have to move these workbooks to another folder, I would...
  4. 9tanstaafl9

    Use VBA to update ODBC path of Visual FoxPro query table connection

    Many years ago, I found this wonderful code on mrexcel.com that let me update all the query tables just by changing the connection string. A few Excel versions later, my code is no longer working for all the queries. It works with all the tables created in older versions of Excel, but not the...
    • 9tanstaafl9
    • Thread
    • odbc connection path change query tables querytable vba & excel 2013
    • Replies: 7
    • Forum: Excel Questions
  5. L

    ChangeFileOpenDirectory "Q:\03. BTF Lab\LR Reports"

    Hi all, I'm hoping this is a nice and simple question; I have the below statement in my MS word Macro which has pulled data from MS Excel and then automatically saves it to a designated directory. Part of the VBA is shown below. ChangeFileOpenDirectory "Q:\03. BTF Lab\LR Reports" The...
    • lance01
    • Thread
    • changefileopendirectory directory filepath path change
    • Replies: 0
    • Forum: Excel Questions
  6. L

    Open Excel document from same file path using Word

    I have a Word document that Opens an Excel document for Mail Merge but the directory and path changes for different people it may be X:\File or Q:\File for e.g The recorded macro I have calls a document called TEMPDATADUMP.xlsm Is there a code I can place before the text below highlighted in...
    • lance01
    • Thread
    • directory mail merge path change word automation
    • Replies: 5
    • Forum: Excel Questions
  7. A

    Change path of a file on shared network drive

    Hi All, I've come back with yet another problem. I know I can get the accurate answers here. I have resume file in PDF format placed on a shared drive on a network and it is assigned letter Z (Z:\). I access my path as Z:\WFM\Resumes. I have close to 60K resumes there. I have a link to each...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top