View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mblackmore Mblackmore is offline
external usenet poster
 
Posts: 1
Default Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time

Usage:
€¢ ActiveSheet.Paste Link:=True or ActiveSheet.Paste ,True
€¢ Access 2002 VB Module controlling Excel 2002 spreadsheet
€¢ Used 6 different times per record, up to 24 records per recordset, up
to 40 recordsets
€¢ Works fine on local machine
€¢ Fails when using Remote Desktop Connection with:

Run-time Error €˜1004:
Microsoft Excel cannot paste the data.

€¢ Consistent failure on this statement
€¢ Inconsistent failure as to which instance/record/records it fails on €“
if fails at all (fails more times than not)