file path

Hi, this is the vlookup I currently have (that works) VLOOKUP(F2,'\\documents\August\[File Name 30.08.22.xlsm]Sheet 1'!$F:$Z,21,0) The issue is that everyday I have to reset the formula with the prior working day so that it's pulling through the latest comments. I'm trying to create a static...

I'm trying to open a specific folder on a network based on the information entered by user. This entered information updates the header info, so cell values won't be accessed. The input corresponds to a number and a name, that would also be part of Folder Name and Workbook Name as well. I've...

Hi All, I'm hoping for some help please? Ive been trying to create a button in excel that saves the file for the current workbook with the name as cell value and a path (Sharepoint). below is what i have so far, but doesn't work. HELP PLEASE Private Sub CommandButton1_Click() Dim path As...

When I use ThisWorkbook.path I get back a URL (https://...) instead of a file path (C:\...). How do I use VBA to get the local file path? For context, the workbook I'm using is saved in my OneDrive folder.

Hi everyone, I want a button in Excel that allows user to choose an image in their personal drive, through browsing the file location. Once they select the photo, it should create and save a copy of this photo into a shared folder, then put the new file path of the image into a cell. (This new...

I have a sheet with 3000 links to different pdf files. All listed in the same column. I'm trying to copy each file to the same folder. This is what I have so far. I works when I define each row but I need it to move to the next row. Any help is much appropriated. Private Sub File_Copy()...

Hello, The below VBA code populates a series of cells in a table, using A2 to update the file path. Column A contains an order number. It will also generate an error message if the fil path specified does not exist. I would like the range "ordnum" to update as users insert new rows into the...

Hi I am trying to create a macro that picks up the file path that is entered on my Spreadsheet and save it as a PDF with in this File Path along with a specific file name: The File Path is below - I need it to go to R1\R2\R3 (S:\Finance\F19\03 SEP 2018) <tbody> Q R 1 File Path S:\Finance...

I was trying to add a couple line in the code below to have a link that would take someone to the file location. I have the problem area highlighted in Red. I cant seem to get the info entered without an error. Sub REVISED_REQ() 'For Tips see...

Hi guys, saw something weird today. I wrote code that goes into my network at work and grabs a file from a specified folder for our current month "03 - Mar" and does a copy paste to another report. The issue that I saw today is that if another user runs the file the macro is grabbing the file...

Hi all, Could you please tell me how to reference the value in a userform text box as part of a file path? The file path would be C:\Users\MWa\Desktop\VBA Test\”text box value" Many thanks in advance, Mike

Apologies for the noobiness, I'm a CAD technician who's been roped into helping with some excel stuff. I'm trying to accomplish this using functions as I haven't used VBA before (although I'm open to trying it out). Problem: I have a 'master' workbook that contains hundreds of sheets, each...

Hi, I'm trying to write some code that will check if a file path exists = if yes continue macro, = if no try an alternative file path = if yes continue macro = if no exit with error msg. Basically my organisation has a strange network structure. For c90% of users the file path for the...

Hello, I am building a calibrated equipment tracker and it is a centralized file on a shared drive for out workplace. However there are 3-4 different drive names for the same folder and file path. But when i try to load an image from the centralized folder on someone elses computer it doesnt...

Dim HINTE As String: HINTE = Sheets("Temp").Range("T18").Value Dim Pathf As String: Pathf = Sheets("Temp").Range("T15").Value ChDir _ "filep" ActiveWorkbook.SaveAs Filename:= _ "Pathf " & HINTE& ".xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled...

Dear Forum Users, I have a question about returning parts of a file path from a formula that references the path as it exists in another cell on a worksheet. I have tried using 'Find' and 'Search' within a formula to search for the slashes and return the item between the slashes. My problem...

I am looking for a macro that will populate the save as dialogue box to a specified file path and with a custom save name based on the cell value of (d4) of sheet2 . I want the user to be able to review one last time and manually click the save button. In other words, I want the populate the...

Hello, I need a VBA code to open a file in a specific file path, copy the set of the data, paste into another workbook then close that file. Here's the following criteria: File path: S:\NPH Accounting\NPH Accounting Department\Allocations\2016\Employee Allocation - The files in this folder...

Hi all, I am using the code below to upload a .xlsx file to sharepoint and it seems to only work a handful of times. My questions is there a difference is one uses \\ or // ? And why does this only work sometimes and not all of the time? Sub uploadtosharepoint() Dim SharepointAddress As...

I need help on capturing the file Path and making it into a link to the source. I have a Workbook were I import a sheet from an external workbook using VBA. I would like to be able to capture the path of the source and enter the file path into another cell with a link to the source. Hope I...