1. A

    Save to relative (variable) file path

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

    How to determine if a file exists

    ' 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...
  3. Y

    Error in code to save loaded pictures in userform to specific path

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

    VBA Code To Copy Files From Path To Path

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

    ChDir path problem

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

    VBA: Open PDF with GGS in filename

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

    linked table error

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

    VBA: save document to path from variable

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

    path can't find if the path is in network

    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,
  10. D

    How to define Dropbox folder path in VBA for access by different users/usernames

    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\...
  11. J

    VBA to find next empty row in worksheet isn't working!!!

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

    Code needed for MAC Excel (latest version)

    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)...
  13. S

    VBA Coding for Excel File Path

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

    Excel VBA: List Files of Folder/Subfolder & Rename Files with new filename

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

    Macro Save workbook to current month folder in path

    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"...
  16. Mackeral

    Can't writ out a Workbook

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

    How to prevent the Path displaying of the reference of particular sheets in formual of a cell

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

    Append Duplicate file Path: (1)

    Good Day, I would like some help on appending a duplicate file name during a looped save. Name Name (2) This is my current code: Sub WM_Save_File() Dim Path As String Dim fileName As String 'Move Original File Name Range("d1").Select Selection.Cut...
  19. M

    Listbox click event

    Hi, hope someone can help with this. I have listbox1 that has multiple items. I would like to select an item by double clicking the selected item and open a file. I have the path of where the file is so just need the code when double clicking the selection. thanks
  20. P

    Sharepoint Server wreaking havoc on my macro

    I have a macro that creates a folder for every new client we engage with a specific folder structure. It copies a template folder to the desired location, then renames the folder based on the input in the excel workbook I run that macro from. Sometimes when I open the template, it has an...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back