path

Hi, I've got a total of 3 files I'm working and I want to save one of them in the current folder. For starters, I am brand new to writing VBA so I'm sure this is all wrong. My process starts with copying a master file called "template" into a customer's folder, the customer's excel file will...

I need help creating a dynamic file reference in Excel (Please let me know the correct terminology as well). Currently, it is "='[SDR2021_AFG_NN.xls]Forecast NN 29 -- T5B5 -- AFG'!C2" I want to do something like this: "='[SDR2021_$P$94_NN.xls]Forecast NN 29 -- T5B5 -- $P$94'!C2" In cell...

Hello everyone I have a question regarding the path for a file in a dropbox folder in excel VBA: Currently, I use path = "C:\Users\" & Environ("username") & "\PVAP Dropbox\..." I use Environ("username") because it has to work on multiple computers. But is it also possible to make a changeable...

Hello all bright minded people, please allow me to ask a question: I have a complicated excel project that uses Power Query to read data from different directories. To indicate the source I have a drop down menu (with all the sources) and a FilePath named in name manager. The project outputs...

' I need some way to determine whether or not a given file exists. The past couple of days have been spent searching the internet and ' trying different pieces of code I've found. None of them work for me.The second workbook, "MasterDataFile.xlsm" was created by me ' and works okay. The problem...

Hello, I have the following code that I got with the help of this wonderful forum. I have modified a little but it is not working. Would it be possible to get your help? Private Sub PicToSheet1(picControl, sht As Worksheet) Dim PCAR As String CAR = Me.TextBox1.Value Dim p As String...

Hello Friends, I need a VBA code to copy all files from a folder located at From Path to a folder located at To Path but only those files which are new or have a modification date other than the files which already exists in To Path. For example CASE # 1 There are 25 files in the folder...

I have been using a macro successfully for sometime now, but I have just bought a new machine and I am running W10 and 365 E3 and now the macro will not see the path of the file The files are all stored in the cloud (Office 365, OneDrive for Business) but are also synced with File Explorer When...

I was wandering if someone could help me edit the code below to open the pdf in the file that has the letters GGS in the file name? Public Sub openJOBLIST() Dim path As String Dim PDFfile As String path = "\\hq\dfsdata\Data\UserHomes\jamey.eerson\My Documents\pdf-NEW\Latest...

Hello, I am running into an issue where when I tried to enter data in access database, it keeps showing up the pop-ups "name of the data.accdb" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides". I have...

Hello all, In have a file path saved as the variable "File_Path". Now I want to save a workbook to that path. I'm using the following code: WB2.SaveAs Filename:= _ File_Path _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False It is not recognising "File_Path" as...

hi sir i have a code here but when i use the path on network the code can't find it but if i use a path not on network it works fine the Bold code is the network path,

When you install Dropbox, it generates a folder path that incorporates your Windows username. So on my main computer, the path is: C:\Users\peter\Dropbox\files\ but on my secondary computer (different Windows username but access to the SAME dropbox folder), it's: C:\Users\david\Dropbox\files\...

Hi guys, i'm not amazing with VBA but can take stuff and change it to suit my requirements, although this code isn't finding the next empty row, it's just pasting data on top of data, so instead of getting 20 rows of data, i'm just getting 1 and it's really infuriating!! I have a multitude of...

This is what I want to do. Can someone help with code please. Not sure of the correct MAC syntax for the path, used to Drive letters in Windows 10 Select RangeA2 to I44 Use the filename that’s in Cell H10 Save as PDF to Path DATA1\DATA\DROPBOX\\BUSINESS\PDFINVOICE (Filename as in Cell H10)...

Hi, I have prepared a excel template file. i need to put a coding path however the fie can be opened only on my path named. Thanks Santanu

Hi need some help, i try to search around the forum but seen not able to find one i want. Step 1 (list filename of Folder & SubFolder), there will be a POP-UP and ask user to select the path Step 2 (rename filename base on col C) & Status update on Col D Isit gd ideal to display ext...

Sub CopyActiveSheet()Dim ws As Worksheet Dim wb As Workbook Dim Pth As String Pth = ActiveWorkbook.Path & "\" Set ws = ActiveSheet ws.Copy With ActiveWorkbook ws.Cells.Copy .Sheets(1).Range("A1") ActiveWorkbook.SaveAs Filename:= _ "K:\Work\Admin\Schedule\September\14.xlsx"...

This is the code:Sub Workbook_Save(Path, Workbook_Name, _ Optional File_Format As XlFileFormat = xlOpenXMLWorkbookMacroEnabled) ' Save the workbook to the indicated file. If Right(Path, 1) <> "\" Then Path = Path & "\" FileName = Path & Workbook_Name...

Hi Any ideas How to prevent the Path displaying of the reference of particular sheets in formual of a cell The following was the original when coding With ws .Range("CP" & curRow).Formula=SUMIFS('Sheet7'!S:S,'Sheet7'!A:A,Sheet5!A:A,'Sheet7'!K:K,Sheet5!$CP$1) End with when the Worksheet of...