path change

I have a form that has several modules that print screen to the desktop and modules that print a PDF to a determined path. I want to change that to look at a cell in the sheet so I can change between five different people and the folders they need to print to. I want to change the path to look...

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...

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...

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...

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...

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...

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...

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...