[AccessD] Paste Into Excel

Hale, Jim Jim.Hale at FleetPride.com
Mon Jan 29 16:31:38 CST 2007


If 2 instances of Excel are running (as opposed to one instance with 2
workbooks) and you try to paste between them you will get the menu 
Jim

-----Original Message-----
From: Keith Williamson [mailto:Kwilliamson at rtkl.com]
Sent: Monday, January 29, 2007 2:26 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Paste Into Excel


Usually it is because I am pasting into an existing spreadsheet, and I
don't want to interfere with the formatting.  I even tried pasting into
another spreadsheet...and copying THAT and trying to paste special.
Same thing.  Just odd.  I know I have been able to copy and paste
before....just sometimes (for no reason) it does this.  Just weird.

{scratching my head}

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Monday, January 29, 2007 2:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Paste Into Excel

Any of those paste choice special formats work but why not just go paste
instead of paste special? This way you won't get the choice menu. (I'm
using
office 2000)
Jim Hale

-----Original Message-----
From: Keith Williamson [mailto:Kwilliamson at rtkl.com]
Sent: Monday, January 29, 2007 11:12 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Paste Into Excel


Anyone ever have an issue when copying from a query, into excel, that
the paste special option for the paste is only Biff5, HTML, Unicode
Text, Text, and CSV??

 

I've been getting this issue, lately...but oddly...not all the time.
Just some times, when I copy out of a query....and go to paste into
excel, it will only paste as one of the above types.  This is very
weird.

 

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.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.
-- 
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.


More information about the AccessD mailing list