Search results

My set-up is very simple: the same VBA modules, but different coulmn, row, query name, excel sheet name. Set xlWS = xlWB.Worksheets("Wt") //The name of excel sheet xlRow = (xlWS.Columns("B").End(xlDown).Row) Set qry = db.QueryDefs("6_WH sales_V") //My query name...

Hi Colin, The scrrenshot attached is a sample image of my query output, I have the same kind output a little over than a hundred. 1. Could you write code that creates queries whose names match the excel row and column that the result will go into? for example qryR1CB or qryR1C2 etc. I hope...

I'm terribly sorry for the confusion. I'm tryng to export all the queries, to each cell in Excel. My queries are single value, 1 column 1 row. They get exported to a specific cell in Excel. What I am trying to figure out is how to effectively assign its location (row, column, excel sheet...

General explanation: Users input start date and end date on a form that filters my query 2_Total (single value) e.g. 154,21 (one of my query image attached) Run the VBA function that exports the query to an excel file Current set-up I designate static values to each module (row, column and...

Thank you so much, Gasman. I was struggling with this for days and you solved it like a pro. Thank you!! Hope you have a great day!

Thank you for your response, Ranman. As you stated qdf.parameters(0) & (1) in your example, I do have "BeginDate" & "EndDate" to assign parameters via code. qry.Parameters("BeginDate").Value = [Forms]![Run]![textBeginOrderDate] qry.Parameters("EndDate").Value =...

I'm certain that I have enough parameters, fields declaration to pass values to OpenRecordSet method but I am still stuck. General explanation: Users input start date and end date on a form that filters my query 2_Total (single value) e.g. 154,21 Run the VBA function that exports the...