Hi,
I need to export a couple of queries into Excel and have them go into a single workbook. The queries have hyperlinks in them. Here is the code I'm using:
Public Function Hyperlink()
DoCmd.OutputTo acOutputQuery, "Availabili ty Tracker", acFormatXLS, "C:\Availabilit y Tracker.xls"
DoCmd.OutputTo acOutputQuery, "Counts",
acFormatXLS, "C:\Availabilit y Tracker.xls"
End Function
This exports the hyperlinks but only gives me a single sheet called "Counts".
I tried the DoCmd.transferS preadsheet but it doesn't keep the hyperlinks, only outputs text.
Any ideas? Thanks!
Carl
I need to export a couple of queries into Excel and have them go into a single workbook. The queries have hyperlinks in them. Here is the code I'm using:
Public Function Hyperlink()
DoCmd.OutputTo acOutputQuery, "Availabili ty Tracker", acFormatXLS, "C:\Availabilit y Tracker.xls"
DoCmd.OutputTo acOutputQuery, "Counts",
acFormatXLS, "C:\Availabilit y Tracker.xls"
End Function
This exports the hyperlinks but only gives me a single sheet called "Counts".
I tried the DoCmd.transferS preadsheet but it doesn't keep the hyperlinks, only outputs text.
Any ideas? Thanks!
Carl