By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,252 Members | 1,670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,252 IT Pros & Developers. It's quick & easy.

doCmd outputto hyperlinks

P: 4

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, "Availability Tracker", acFormatXLS, "C:\Availability Tracker.xls"

DoCmd.OutputTo acOutputQuery, "Counts",
acFormatXLS, "C:\Availability Tracker.xls"

End Function

This exports the hyperlinks but only gives me a single sheet called "Counts".

I tried the DoCmd.transferSpreadsheet but it doesn't keep the hyperlinks, only outputs text.

Any ideas? Thanks!

Mar 8 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.