Hale, Jim
Jim.Hale at FleetPride.com
Mon Oct 25 09:44:36 CDT 2004
I have a database that populates Excel budget spreadsheets from Access tables and also opens Excel spreadsheets and extracts data. I am using Office 2000 and DAO 3.6. The code runs flawlessly on my machine. On the Citrix server, however, the code to extract data from spreadsheets runs fine but the code to populate spreadsheets tells me that the interface does not support this operation. References are okay and permissions seem ok since I can save the spreadsheet (sans the data) through automation. Why automation works in one direction but not the other is beyond me. Any suggestions? TIA Jim Hale *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.