View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich[_31_] Rich[_31_] is offline
external usenet poster
 
Posts: 2
Default Excel Paste w/ No User Input

I can across your website detailing Excel automation in Delphi and
found it VERY useful. However, my current project requires a task that
isn't mentioned there or has been covered in the Delphi/Microsoft
newsgroups, yet. If you could spare me a few minutes and take a look
at my problem, I'd be most grateful.

Hello,
I'm copying data that is variable length from the clipboard into a
worksheet. I've figured out to this programatically with one slight
problem. After using ws.Paste, Excel pops up the following MessageBox:

"Data on the clipboard is not the same size and shape of the selected
area. Do you want to paste the data anyway?"

Once I click the OK button the data is pasted, but I'm trying to
hide the Excel interface and need to automate this entire task with no
user input. Is there a way to prevent this message?

I've already tried to send TExcelApplication a RETURN key press
using SendKeys after I paste, but it never gets called because program
execution is waiting for the the ws.Paste function to finish. Any
ideas?

Rich Walls