Hi JHB
Below is the code I modified and its working, Thanks for your help.
I have one more problem, The macro is taking too much time in getting connection, is their a way to make it faster
Option Explicit
Function CreateAndRunQuery()
Dim con As Object
Dim rs...
Hi JHB
One more help
Dim con As Object
Dim rs As Object
Dim AccessFile As String
Dim strTable As String
Dim SQL As String
Dim i As Integer
Dim a As Variant
a = Range("F3").Value
SQL = "SELECT [Invoice...
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...
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...
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...
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...