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

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

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

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

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

i don't know possibly if anyone will understand me and how possible it is 1) i need a code that, whenever i drag a file from explorer into a listbox, it should add the file name and path to the listbox items. 2) having a listbox populated with files and their paths, is there a code that when...

Hi all! I'm trying to activate the Microsoft Scripting Runtime Reference within my code as I'm using FSOs in other parts of the code. I don't get any errors, but it's not activating the reference either. The path below is my actual path. Any help is appreciated. Thanks in advance! Sub...

Hello there, I'm trying to find a macro that I can add to my quick access toolbar to be able to save the file as, with the current file name and the date and time added. to this path C:\Users\wwollaston\Documents\Files\Backups\ For Example, I'm in a workbook named Workbook1 and I run the...

I running on macOS 10.10.5 with Office 2011. I'm having a problem with this macro. I cannot get MacScript to return the POSIX path of a mac file path. Sub tryOut() Dim cValue As String Dim thePath As String Dim allData As String Dim unixDesktopPath As String Debug.Print...

im getting a path error for somre reason. what is wrong with my path? Sub Autoit() Dim FileName1 As String FileName1 = "C:\Program Files (x86)\AutoIt3\AutoIt3.exe e:\1\glassshatter.au3" runscript = Shell(FileName1) End Sub

So, I'm not even sure if this is possible. I would like a formula (or maybe could do a macro if needed), but what I'm trying to do is basically this: In cell B1: 1. Take a value from cell A1 in Workbook A. 2. Search for that value on ANY tab in ANY workbook in file path "P:\shared\2019" which...

When I import or export modules from the VBE, my default path was where I wanted it until this past week when I somehow hosed it, and now I have to navigate to get back to it each time I restart Excel (it remains stable in each session). Does anyone know how to change the default path...

I'm getting run-time error '1004': The file path you entere is too long. Enter a shorter file name or select a shorter file path, and then try saving the file again. When I debug I get taken to "ThisWorkbook.SaveAs StandardFile" However, I'm only getting this error when a particular user on...

Please Help im having trouble with following code, the only issue is the code that is bold, FlName = Path & c1 & "-" & c2 & ".txt", problem is that "path" does not work, for some reason it does not find the directory of the file...but when i replace "Path" with the actual directory it works...

I have a DLL with I don't want to put it in the system folder. I do I let VBA, how do I load dll from the path I want?

Hello. I have had the below formula in a spreadsheet for quite some time now. The purpose of this formula is to determine the name of the Excel file that holds the formula. A table called "t_Parameters" holds the name of a subdirectory that is appended to the end of the the directory. So, if...

This code below works when I was going to keep the LoginDatabase sheet 1 in the same workbook. Any thoughts on modifying u = to point the VLookup to the LoginDatabase sheet 1 in another workbook. I know I need to add a path to where the workbook is located “C:\CE Program\Database.xlsm”...