[AccessD] OT - Worksheet Object

Heenan, Lambert Lambert.Heenan at AIG.com
Tue Jan 18 12:30:03 CST 2005


Well isn't that is nice little gotcha!

This does not happen with Outlook 2002 and Excel 2002. Tonight I'll check
with OL/Excel 2000. But it's certainly the case for Outlook 97. It's bad
enough for the whole worksheet that was the source of the pasted data to be
embedded, but the complete workbook as well?!!!!

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
> Sent:	Friday, January 14, 2005 4:18 PM
> To:	'Access Developers discussion and problem solving'
> Subject:	RE: [AccessD] OT - Worksheet Object
> 
> I would go further and say one has to be very careful about embedding
> excel
> worksheets. I was involved in a case where the CFO cut and pasted  a
> summary
> salary analysis into an email. When you do that the entire workbook is
> actually embedded. I was able to open the workbook and extract the
> detailed
> salary worksheets. He was one embarrassed CFO, particularly since he had
> been so proud of his High-tec cut and paste job!
> Jim Hale
> 
> -----Original Message-----
> From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com]
> Sent: Friday, January 14, 2005 2:00 PM
> To: 'Access Developers discussion and problem solving'; 'John Clark'
> Subject: RE: [AccessD] OT - Worksheet Object
> 
> 
> Nope. This is totally standard embedded object behavior. Another way to
> get
> into the worksheet object to edit it is to double click on it.
> 
> Lambert
> 
> > -----Original Message-----
> > From:	accessd-bounces at databaseadvisors.com
> > [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
> > Sent:	Friday, January 14, 2005 2:20 PM
> > To:	accessd at databaseadvisors.com
> > Subject:	[AccessD] OT - Worksheet Object
> > 
> > Sorry to intrude with an non-Access subject, but someone came to me with
> > an issue today and I couldn't really figure it out. And, I know somebody
> > on this list has to know the answer. I've looked online and can't find
> > it.
> > 
> > An employee was given an MS Word form from the state. This form has a
> > worksheet object in it, that they are to enter data into and it is
> > suppose to calculate the totals. If they click into the form and enter
> > numeric values, the calculation did not take place. So, I discovered
> > that if they right-clicked on the object, the could choose "worksheet
> > object" and then "open", and they could enter data and it would make its
> > calculations. Although this works, it doesn't seem right...you would
> > think that you could just enter the data, as you got to it.
> > 
> > If anyone has any insight on this, I would appreciate that knowledge.
> > 
> > Thanks
> > 
> > John Clark
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> ***********************************************************************
> 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. << File:
> ATT11501675.txt >> 



More information about the AccessD mailing list