 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Spreadsheets as OLE objects
Hello, I have a table in Access and in each record of that table is an Excel worksheet embedded as an OLE object. Copy and paste works in the selected worksheet, but when I try to copy and paste a range of cells from one embedded worksheet to one in another record the information is not passed to the clipboard as I have no paste function. The worksheets are not linked. Do the worksheets have to be linked to a workbook outside of Access? If so, do I then need to programmatically define the path? Thanks in advance for any help Hi Paul3rd, I've just tried to replicate the situation you describe, and i can't. When i pasted data from one sheet to a sheet in another record (that is, embedded within the field of datatype OLE in my sample Access table), the data did in fact go to the clipboard. Perhaps I have misunderstood? Maybe you have solved it already, or would you like to re-explain your issue? cheers, helen > Hello, I have a table in Access and in each record of that table is an Excel > worksheet embedded as an OLE object. Copy and paste works in the selected [quoted text clipped - 6 lines] > If so, do I then need to programmatically define the path? > Thanks in advance for any help
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.