|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
April 19th, 2004, 01:19 PM
|
|||
|
|||
VBA command to paste from clipboard
Hi all,
Is there a vba command (Access 2002) that will permit me to paste the data that is in the clipboard? In this macro, I'm trying to copy a line of data frrom Excel to Access, just like you would manually. What I have so far is: Range("A2").EntireRow.Select Selection.Copy DoCmd.OpenTable "tblInputHeader" DoCmd.GoToRecord acDataTable, "tblInputHeader", acNewRec What I need to have the macro do is to highlight the whole last row of the data table (Access) and paste the contents of the row from Excel, that is now in my clipboard. As usual, any help will be greatly appreciated. Creo
|
|
#2
April 20th, 2004, 05:20 PM
|
|||
|
|||
|
Doesn't DoCmd support clipboard operations? I don't do a lot of Access VBA and I'm not sure on this.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
#3
April 27th, 2004, 08:39 AM
|
|||
|
|||
VBA command to paste from clipboard
Well, lucky for me that I came across the TransferSpreadsheet Action. This is definitely the best option to transfer data between Access and Excel. The clipboard is not involved.
Thanks for the interest Doug. Creo
|
|
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > VBA command to paste from clipboard |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
