Search results

  1. A

    VBA to get data to excel from access

    Hi All, Please help me with the below, I have a excel VBA code which will open access database and filter based on SQL criteria and copy filtered data and paste it in excel file. Option Explicit Sub CreateAndRunQuery() Dim con As Object Dim rs As Object Dim...
  2. A

    VBA to import data from access database to excel

    HI All, Please help me in completing the my macro. I need a VBA code which will copy all tables from access database to Excel file. Access database path - C:\tracker Database file name is Naveen.accdb. Now I need a code which will open Naveen.accdb from c drive and imports tables to new...
  3. A

    Selecting samples based on Criteria

    Hi All, Please help me in completing my macro. I have a scenario where in I have to select some random samples from the data dump, Please provide me a VBA code which I can insert in my macro. Below is the criteria: Name Day Count of Samples Task Categories Sandeep...
  4. A

    Macro to consolidate multiple files

    Hi All, I have set of file names saved in Sheet 2 of Consolidated file I need a macro which will open the file names listed in Sheet 2 of consolidated file from "C:\Macro" folder and copy all data from A2 and paste it in Sheet 1 of Consolidated file and close the opened file and continue to do...
Top Bottom