Search results

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...

Yes i wanted it this way. Thank you very much :)

Thenks for reply, Access database layout is like below, Tables: Quotes Quotes table contains: Fields::::Date,Ticker,Op,Hi,Lo,Cl,Vo,Oi now in excel i want this data to flow like this:::: i will write a function say 'fetchdata', thus my parameters would be, in any cell...

approx. 30 views and no replies..... please somebody help.... my query may be silly or naive but i am stuck at, how to pass dynamic parameter linked to a referencing cell so that i can drag and copy same query to different cells without creating individual query for each cells.

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...