paste special values into excel?
paste special values into excel?
paste special values into excel?
paste special values into excel?
paste special values into excel?
paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel?
paste special values into excel? paste special values into excel?
paste special values into excel?
Go Back  Xtreme Visual Basic Talk > > > paste special values into excel?


Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2004, 08:04 AM
Judo Tom Judo Tom is offline
Freshman
 
Join Date: Oct 2002
Posts: 39
Default paste special values into excel?


I copied this code from a vba macro:

xlApp.Selection.PasteSpecial(Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False)

well it didnt have the xlapp. arugement in front i added that.. my problem is i do not no the proper value / variable to replace the "xlvalues" and the "xlnone" portions of the code

any ideas?
Reply With Quote
  #2  
Old 02-17-2004, 08:46 AM
herilane's Avatar
herilanepaste special values into excel? herilane is offline
Unashamed geek

Retired Moderator
* Expert *
 
Join Date: Jul 2003
Location: London, England
Posts: 8,988
Default

Easiest way: use the object browser in Excel. Or alternatively, use the Immediate window in Excel.

You could of course also switch to early binding, which would allow you to use those constants as they are.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy values of big Excel range (many columns and many rows) hzhzzz Excel 11 10-18-2003 01:37 AM
Excel Paste Special Switchmaster Excel 5 09-15-2003 06:51 AM
Doing a paste special into word object haiiyaa Word, PowerPoint, Outlook, and Other Office Products 0 04-21-2003 11:39 AM
Pate Special - Paste link question frech General 0 01-20-2003 09:54 AM
How can I check for duplicates before saving a new record GOTzMADsKILLz Database and Reporting 19 08-15-2002 12:56 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
paste special values into excel?
paste special values into excel?
paste special values into excel? paste special values into excel?
paste special values into excel?
paste special values into excel?
paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel? paste special values into excel?
paste special values into excel?
paste special values into excel?
 
paste special values into excel?
paste special values into excel?
 
-->