variable path

  1. K

    Open, then auto select file and automatically run program

    Hi Guys, I am looking for a way to open a folder, and have different workbooks open different files, using a partial title and then run specific programs. For workbook1 I have this code: Sub Foo() Dim vFile As Variant Dim wbCopyTo As Workbook Dim wsCopyTo As Worksheet Dim wbCopyFrom As...
  2. J

    vba save as using file path and file name variables

    Dim HINTE As String: HINTE = Sheets("Temp").Range("T18").Value Dim Pathf As String: Pathf = Sheets("Temp").Range("T15").Value ChDir _ "filep" ActiveWorkbook.SaveAs Filename:= _ "Pathf " & HINTE& ".xlsm" _ , FileFormat:=xlOpenXMLWorkbookMacroEnabled...
  3. P

    Copy data from variable number of workbooks into a master file in loop

    Hi, I have a folder with the path "C:\A\Consolidated". This folder contains the master file. There are also folders within the Consolidated Folder that are differentiated by dates - YYYYMMDD. The date folders contain identical workbooks that are differentiated only by employee name. The number...

Some videos you may like

This Week's Hot Topics