Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA Acces - Export excel
Never mind, i have te code strSQL = "SELECT * INTO [Excel 8.0;Database=" & Pad & strQryName & ".xls].[" & strQryName & "] FROM " & strQryName & ";" CurrentDb.Execute strSQL 'Rename File after export- Gaatsen
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA Acces - Export excel
That is just renaming the file. First i need to open c.xls and put my output sheet in it then rename it. Could you code that for me?- Gaatsen
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA Acces - Export excel
Hello! I'm new here. Question. I have te following code to export mij Query to excell. It works fine but, i'd like it this way: Open an existing excel file (for example c.xls) and put my output in there and then rename c.xls to Format(Date, "YYYYMMDD") & "_Compensatie_" & ".xls". Help...- Gaatsen
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
-
VBA Acces export to excel
Hello! I'm new here. Question. I have te following code to export mij Query to excell. It works fine but, i'd like it this way: Open an existing excel file (for example c.xls) and put my output in there and then rename c.xls to Format(Date, "YYYYMMDD") & "_Compensatie_" & ".xls". Help...- Gaatsen
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
