Thank you! sounds like a good place to start.
The goal is to multiple sheets to the workbook. Can you please tell me if the below make sense?
Private Sub exportToXl_Click()
Dim Xlapp As Object
Dim Xlbook As Object
Dim Xlsheet As Object
Dim Xlrange As Object
Dim...
Hi Isaac,
Thank you for taking the time to respond. I have a excel workbook and i am trying to export queries that i have built in MS access to the existing workbook. I would like to export the queries using VBA. I would also like to be able to create specific sheets within the workbook where...
Hi All,
I am using the latest MS Access and i am trying to exporting 10 queries to a file that i created using VBA. I would really appreciate the help.
Thanks,
Kalech