file path

I am planning on implementing a new files server in the upcoming weeks. A few people that we support have excel spreadsheets that have multiple drives and file paths hyperlinks and I want to change those links into there UNC paths. Then this will allow me to then just replace the old server path...

Hi all! I found this code online a while back and have been using it and it works great, but now I'd like to remove the user input from the process and instead derive the folder path from variables that were assigned earlier in the macro... The previous version... Sub GetFileNames() Dim...

I have a Summary Workbook that I paste links from other Client workbooks into. Depending on how I open the file, the linked file path pasted is different. The links also behave different when updating the original source file.</SPAN> If I use a hyperlink in the Summary Workbook to open a...

Hello, I've been working on this for hours, and I'm ready to ask for help. I'm a relative VBA beginner, and have been teaching myself over the past month. I know exactly what steps I want this program to take, but am having trouble implementing those steps in a way that is concise, because I...

Hello everyone, I´m trying to analyze several measurements in one excel Worksheet. Attached you find the xls sheet and a picture showing the folder structure where the measurement data is stored. https://www.dropbox.com/s/7dvmtv458cpumb4/Capture.JPG?dl=0...

Hi, I have a spreadsheet (call it 'Central reporting') that I want to act as a kind of central store for the first sheet (call it 'progress report') of several of workbooks which are spread around various file locations. All the workbooks have an identical layout for the first sheet; however...

I have searched through several threads already posted and some of them "touch" upon what I have trying to do, I try out some of the suggested solutions, but nothing seems to work the way I need it to. So let me start off by explaining what I am "trying" to do. I have to track employee...

I am trying to figure out how to combine 2 macros. The first macro allows me to select the file path I need, and the second macro will use the file path from the first macro and pull the worksheets from all files in the file path and combine them into 1 summary workbook. What is the best way to...

Hello, I made a macro to save a file with todays date in a folder. I'll be doing this everyday and I don't want the folder to fill with workbooks. I would like to keep yesterdays and delete the file dated the day before yesterday. Also If anyone can give me a tip for adding in holidays to the...

Hi I've created a workbook with tables that are refreshed on opening the workbook, their source is queries on other workbook sheets. In order to facilitate the distribution of the workbook I need to set the Connection properties of the MS Query on opening. I have the script below, which when...

We have multiple macros that have been developed by various users in the company. Many of these macros have file paths hard coded into the macro to reference file locations with networked drives. We are planning on making some changes to the network file structure which will break these macros...

Hey guys, I'm trying to use INDIRECT.EXT to reference a cell in another workbook. However, I keep getting a #REF! error. In cell L2: '\\IN-ACCOUNTING1\Accounting\EOP_workpapers\Books\AAL\2012\04\[CN3008R_CGS.csv]CN3008R_CGS'!F9 L2 is a concatenation as follows...

I need a script to capture the A file path, as my macro opens named files which reside in a different location to the master file that contains the macro, I want to avoid hardcoding the paths and end users having to change the VBA code every month for example Master file resides in...

Hi all, again I am still working on this rather massive excel tool hence the questions which I hope you guys do not find irritating or stupid. The macro currently creates hyperlinks in cells, but the text displayed is only the file name, not the full file path. Now I am trying to write another...

Hi! I'm finding it difficult to do one specific thing. I want to open a workbook that has the same filename on 2+ different computers, all of these computers being Macs (OSX version 10.5 and later). The problem is when I use the following code to open a specific workbook, it will only open on...

I have written a macro that copies worksheets from a workbook to a new workbook and saves it. I want the new workbook to save to the same network file folder as the original. It seems like everytime i run the macro it saves in a different location. Sometimes in the correct location. Often...

I have workbook setup that uses a set of variables stored into stings. The way I have this script working right now is the variable becomes part of the file name when saving . Ex. File Name: "2010-Assessment-Data- For-" & (Var1) & (var2) & ".xmls" I was able to make this set-up work and...

Hello, This is my first post here at MrExcel, but I have been using the forum for some time now to search for answers. I haven't been able to find an answer to my latest question: When I move files/folders referenced in my VBA script, the script obviously fails since the path mentioned is no...

Is there a way to have a macro pop-up a box with the file path of the excel workbook. I'm know that this is easy but there's a catch! PROBLEM: I need the file path for the workbook to be copyable. The user needs to copy and paste the file path into a separate program. THOUGHT: I was thinking...

Windows XP Home / Professional Excel 2003 / 2002 VBA 6.5.1024 MS Query 11.8164.8172 Question (concise version): I have several QueryTables in an Excel Workbook. The Query for each was created from the User Interface, and with Microsoft Query, (not VBA so far). During development, I am changing...