Solved

Datagrid to Clipboard/Excel

Posted on 2002-04-24
5
352 Views
Last Modified: 2013-11-13
I'm working at a client site where the client is displayed a datagrid. The client wants to be able to select the grid and copy/paste the contents into Excel. When I did this, excel pasted the contents as a picture. Is there some way code-wise to do this? Thanks!
0
Comment
Question by:enoch100
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

by:enoch100
ID: 6965794
To be more clear, I don't want Excel to paste it as a picture. I would like the cells and data to go into excel.... as cells and data.
0
 

Author Comment

by:enoch100
ID: 6965805
To be more clear, I don't want Excel to paste it as a picture. I would like the cells and data to go into excel.... as cells and data.
0
 
LVL 2

Accepted Solution

by:
GregJennings earned 150 total points
ID: 6965871
You could export the grid to a file and then load the file in Excel.
0
 

Author Comment

by:enoch100
ID: 6965898
That's a good idea... I could go thru the cols and put them into a comma-delimited file which they can open up later... Thanks! Didn't even occur to me. <sigh> damn M$ and their clipboard! :)
0
 
LVL 2

Expert Comment

by:GregJennings
ID: 6965935
You might check to see if there's an export function built in to the control.  I once used a grid control that had an export function and all I had to do was call that function with the output filename and it created the file for me.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Prevent user closing word document opened with VB6 6 84
Excel Automation VBA 19 104
VBA - If Bookmark = "XXBOOKMARKXX" then 15 51
Exchange Server 2016 Installation 2 44
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question