Search results

Well I certainly would rather that you enjoy the 4th than work with this issue!! I can wait!! Have a great weekend.

Is everything okay, I had gotten used to hearing from you and it was nice to hear from you.:)

Attached is a bogus copy of the 2nd worksheet, the column names are relatively close to what is copied or exported on the 2nd sheet, but the 1st sheet includes many vlookups and sumifs to find the data necessary, when the query is copied or exported to the 2nd worksheet. While it's a bit manual...

That will be fine - your help is greatly appreciated! Thank you and I hope all goes well!

Sorry about that, I didn't copy my database, I merely created something similar. I have copied the macro and the VB code now into this database. also, I attached the screen print of the file path for the spreadsheets and the previous macro error document showed the file path for my odbc...

I've attached a copy of a bogus database with similar fields, objects, etc. and a word document with the file path locations to the area I would like the filtered spreadsheets from the query "Account Category qry" to save to. The form with the combo box that filters this query is "Owner...

Sounds like a project for Monday. Enjoy your weekend and thanks for all of your help so far.

I opened the form and typed in the property # under the owner field and pressed on the macro and it came back to end or debug set rst = CurrentDb.OpenRecordset(strTQName)

Attached is word document showing a problem with the code I'm having now that I'm hoping you'd still be willing to help me with.

Dim strPath As String Const xlCenter As Long = -4108 Const xlBottom As Long = -4107 On Error ' On Error GoTo err_handler strPath = strFilePath (I'm now given Compile error: Syntax error)

When I run the macro I'm given the error #2004 that the "Select metho of Range class failed"

I think it should be attached now, it was a screen print I placed into word 2007.

I attached what I attempted to do in the access macro and I receive error code 2950 and it relates to having quotes in the wrong places and commas in the wrong places.

I'm sorry that I'm unable to put all of this together, but you mentioned "Then you can just call the function like this: SendTQ2XLWbSheet "QueryNameHereInQuotes", "SheetNameHereInQuotes", "FilePathAndFileNameAndExtensionHere" So if you had a query named qryMyQuery and the sheet is "Sheet2"...

Thank you, I'll give this a try!

Thanks for the reply! So I set the reference to Microsoft 3.6 Object Library since I use Access 2007, but export to an Excel 97-2003 named Variance Analysis. Also, for every occurance of TQ in the code; do I substitute the query name "Account Category qry" without quotes & Sheet name and...

I have a query that I'd like to be able to export to the 2nd sheet tab in an Excel spreadsheet from a Query that is filtered using a combo box on a form. Is there any way to automate this process as I have approx. 20 exports to Excel to create manually.