query to automatically export to 2nd sheet tab in Excel

[tbauer]

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 Selection". If I run the query it filters the query to the number selected previously in the combo box. I hope this helps.

 

[boblarson]

The database doesn't have the export code in it at all. Where is it? It's like you posted an older version which doesn't have what we've been working on.

 

[tbauer]

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 database connection - "Tonya's Timberline Searches" [Sage Timberline is the Accounting software we use].

 

[boblarson]

Do you have a copy of the spreadsheet (you said you needed to put the data into a specific place)?

I'll have to work on this one when I get home as I am limited by having only 2003 at work and also today might be a bit of a nightmare for me as we are having problems I need to deal with. So any posts today, while at work, are going to be quick ones in between things.

 

[tbauer]

That will be fine - your help is greatly appreciated!

Thank you and I hope all goes well!

 

[boblarson]

That will be fine - your help is greatly appreciated!

Thank you and I hope all goes well!

Remember to upload a copy of the spreadsheet too.

 

[tbauer]

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 at this point I performed this for about 10 worksheets and they each reflected the data accurately.

Thanks!

 

[tbauer]

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

 

[boblarson]

Sorry, its been a bit of a hectic few days. We had a major issue at work, so I couldn't be on at all yesterday and today I was for a bit. And then by the time I've gotten home it was pretty much just eat and go to bed. I know you're needing this and I want to give you some help with it. It just is such that it does take some time to work on and directly concentrate on it. I'm okay if someone else pops in and gives it a go as well, but I might be able to do some work on it on Monday (holiday).

 

[tbauer]

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