Search results

  1. N

    help in returning array from access to excel in vba

    Hi every body, I have an Excel file from where i pull data from my access database through ado connection defined in a function. The existing function is as below, ====================================== Function Stockprice(sTicker As String, sField As String, sDate As Date, eDate As Date) Dim...
  2. N

    need help in MS query from Access to Excel

    I have a database from which i import data to my excel sheet through MS Query (MS Access driver *.db) method where the required two (2) parameters are in cell A2 and B1 with output coming in cell B2. Now i want to replicate this query to all remaining cells i.e. A2:A1000 and B2:BG2., where...
Back
Top Bottom