import macro

  1. H

    Concept of Working With Network Server

    Overview: Looking for direction on the capability described below. Need general directions to know if this is feasible and list the topics that I should go study. Objective: Store MS Access database and complex set of Excel macros on a server. This will serve about 30 to 40 individuals. My...
  2. C

    Run-Time 462 Error - My code to pull Microsoft Project data into Excel works, but only once.

    Hi All, I've cobbled some code together from various sources as I'm a tinkerer not a seasoned coder. The code below is not pretty or efficient, I will work on that, but for now... I'd really appreciate your help. My code works...ish It opens a Microsoft Project file (MPP), copies three columns...
  3. R

    incorporating a macro import within another sub

    The following code (blue font) finds specific worksheets in an active workbook, and copies them into a new workbook then names the new workbook the same name of the worksheet. It all works perfectly. The second code below (red font) imports some vb into the new workbook. It works fine if I...
  4. E_DPSG

    Need help with TimeStamped File Import

    Hello all experts - I am trying to figure out the best way to do the following: Import an system generated report (Exported to a directory every hour) into a master table. The file naming structure is as follows: \\MyDir\ReportName1.DDMMYYYY.HHMMSS.xls Where MyDir = the directory structure...
  5. R

    Have exported a module (macro) now need help importing it into another workbook

    This forum is great. Thanks for taking the time to read my question. I am making a copy of a worksheet contained in the host workbook, which creates a new workbook (export workbook). I save the export workbook and have two workbooks open. I activate the host workbook and export a module...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 40
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top