insert file in excel

  1. A

    Import Multiple Text Files from a Folder using VBA

    What I would like to do is fairly straight forward, but I am having difficulty finding an answer that suits my needs. There have been replies to this question in other places, but they have not worked. So this is what I would like to do. Background: I have built a spreadsheet that analyzes data...
  2. G

    A comparison of a set range of columns in to another on the same sheet to highlight rows with differences...

    **I do not have rights to attach my workbook. :confused::confused::confused::confused: I don't even know if this is possible....I have no idea how to code a comparison of a set range of columns with another range of columns and then flag the rows with differences to insert an image in a frame...
  3. E

    Close file that was inserted in excel as object as an icon

    I need some help on a VBA code. I want to insert other files in an excel file which is displayed as an icon and give the icon a specific name. I used this code: Dim fn fn = Application.GetOpenFilename If fn = False Then Exit Sub End If name = InputBox("give the file a name")...

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