I am trying to script a macro that will export several tables into seperate worksheets within the same workbook. Is there are way to perform this command?
I'm not sure you can do that in a macro, you may have to do it in VBA. there's a command that will take an existing macro and convert it to VBA and then you would just need to modify the code to the specific sheet.
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
When ever you export a table or a query to an existing excel workbook, if the name of the table or query doesnt exist as a worksheet name then you get a new worksheet with that name.
If the name does already exist then data is overwritten.
My code isn't erroring out but my spreadsheet isn't populating with anything. Any idea? Which value is the table name I am exporting from? I tried changing the true / false but that didn't help. Am I doing something wrong? I copied and pasted what I am working with in the module I am calling.
Sub Export_Excel()
DoCmd.TransferSpreadsheet CONFT_Audit_Rule_Configuration, 8, "CONFT_Audit_Rule_Configuration", "M:\Concur_Upgrade\Configuration_Report\master_report.xls", True, "CONFT_Audit_Rule_Configuration$
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.