file path error

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

Hi all, I am really struggling to find an answer to my question so hoping someone here might be able to help. I have a set of Excel documents set up as a template for new jobs each time a new job comes in. When we get a new one in I copy and paste the "template" file and rename it as the new...

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

Hello! I'm fairly new to VBA coding (and this site), and I'm having a little problem that I'm hoping someone can help me with. I'm trying to get my workbook to open up a second workbook that is saved on the user's desktop and copy information into that second workbook. I found code in a...

Hi I've requirement wherein the user chooses the workbook to be open from the excel sheet and then a mathematical calculation is made. The issue is I'm able to run the first part of the code properly and the fNameAndPath has the workbooks name and path but I need to open this workbook in the...

Hello all I am having problems with a colleague sometimes being unable to run a macro which saves PDFs to the desktop. I haven't found a solution online, so I'm hoping someone here might know what is going on. The macro picks up the file path (sUserPth) from a cell in the active worksheet...

I am having a problem with VBA code related to the file path name. In Macro1 - the files are located on the C: drive with no folders and it works. In Macro2 - the files are in folders as shown in code below and does not work. Please help - I need someone to show me the code to allow the file...

Hi all, I'm trying to update the links to a new file and Excel 2007 is saying "xxxxx file cannot be found. Please check your spelling or try a different path". The file path is definitely correct. No folders have had their names changed etc. The file was used a new user who has her network drive...

Hopefully this isn't too confusing... So I'm trying to open a outside xls file (File 2) from within a workbook (File 1), copy the contents of File 2 and paste it back into File 1. The only snag is the File 2 is automatiicaly FTP'd to me daily in a custom folder. Everyday a new folder is...

Hi Guys, Usually I can find answers by searching the site, but couldn't seem to find an answer to this one.. Any Ideas as to why this VB Code is resulting in the Clicked SaveAs action dumping the file into the "*******s" part of my File path rather than into "1 QUOTES" Which is where I need it...