Recent content by SunnyG

Thank you, thread has been solved.

Hello Everyone, Could someone please help me tweak the code below. I want to export the query data from Access into an existing Excel workbook instead of creating a new workbook for it. There are a total of 9 queries and each has a specific tab it needs to go into the same workbook. Also, I...

This thread is solved.

Thank you very much Paul, I really appreciate all of your time and help today. What you provided works perfectly! Take care and be well!

Thank you again. Yes all the files are being exported into 1 excel file into the same location. But I also need to send this file to go here: \\ga016a204\wwwsites\WLS-develop.suntrust.com\REPORTS\ could you please tell me how to use the FileCopy function? </SPAN>

Thank you very much! This worked great. Is there also a way to make the same code export to 2 different locations? Is it possible to also add this location somehow? Thank you very much again for all of your help today it is greatly appreciated.

Thank you again. I am getting a run time error 3044: it says it is not a valid file path. When I added your () to the date, the code editor accepted it but then it disappeared. Any thoughts? Thank you again very much.

Thank you for your help and time.Not surewhat I didwrong, I got a syntax error. Function exportDtsData() DoCmd.TransferSpreadsheet acExport, , "Dashboard 1 - Exception Status", "\\corp\dfs\Retail_Shared\GA016\F3A_02\RETAIL_SHAR ED\AQCP\WBCS Admin\WBCS Analytics\REPORTING\Weekly\DTS\DTS...

again very sorry but I don't know where to put the code weak you suggested. When you refer to the file name argument I don't know where that is. I know enough to be dangerous, not much at all. Thank you for your help.

Thank you for your help. Could you please tell me where this piece of code goes? I'm sorry but I am very new at this.

Hello All, This is what I have so far and it works, I tested it. Could someone please help tweak this a bit so that the file does not get overwritten each time the export happens. Is there a way to have the code create a new file when run instead of having the export go into an existing...