file_path

  1. 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...
  2. I

    Renaming files now obviously stops code working

    Hi, I have this code in use which when in my database & i press its button the corresponding invoice is then shown. At the time the invoice were saved like this, 1.pdf 2.pdf 3.pdf Private Sub OpenInvoice_Click() Const FILE_PATH As String = "C:\Users\Ian\Desktop\REMOTES ETC\DR COPY...
  3. P

    VBA and Subfolder Drill downs

    Hey everyone! I asked a similar question on another thread, and didn't get any responses. Then I realized how broad a question I was asking. I am going to get more specific about where I am confused. Also, I am getting pretty comfortable with the code, but struggle with the logic/syntax of...
  4. P

    Copy/Paste Between Workbooks

    Ok, I am at the very first stages of my macro, and am kinda stuck with the logic/Syntax. I will be scaling this up to be much larger. I am wondering how to accomplish the following: File_Path = "Desktop/Sandbox" 'This folder will have several...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top