Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Paste w/ No User Input
Have you tried:
Application.DisplayAlerts = False Your code here Application.DisplayAlerts = True "Rich" wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Paste w/ No User Input
That works...quick response appreciated.
Rich JON JON wrote: Have you tried: Application.DisplayAlerts = False Your code here Application.DisplayAlerts = True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Pausing macro for user Excel input | Excel Programming | |||
Pausing macro for user Excel input | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |