Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile error in hidden module in excel 2002 X2002 Excel Discussion (Misc queries) 1 March 5th 07 02:32 PM
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl scampbell Excel Worksheet Functions 0 February 22nd 06 06:31 PM
Can you print labels using Excel 2002 in a Word 2002 mail merge? Individual_ Excel Discussion (Misc queries) 3 December 17th 04 08:39 PM
Excel 2002 VBA connection to Access 2002 using SQL Pal Excel Programming 1 August 27th 04 01:31 PM
Excel 2002 files attached to Outlook 2002 EMails change size AJStadlin Excel Programming 1 October 15th 03 12:12 AM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"