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"
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...
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.
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
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...
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...
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...
When you install Dropbox, it generates a folder path that incorporates your Windows username. So on my main computer, the path is:
but on my secondary computer (different Windows username but access to the SAME dropbox folder), it's:
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 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
ActiveWorkbook.SaveAs Filename:= _
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...
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
.Range("CP" & curRow).Formula=SUMIFS('Sheet7'!S:S,'Sheet7'!A:A,Sheet5!A:A,'Sheet7'!K:K,Sheet5!$CP$1)
when the Worksheet of...