Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping "Link Worksheets?" message box (using automation)
Hi,
I am using Visual FoxPro 7 and Excel 2000. I am using GetObject (code below) to copy a range of cells to a table. When the program is running, the user is asked if he/she wants to link the worksheets. How can I stop this and all message boxes. I can not find anything about parameters, etc... in the Excel or VFP help files. Thanks, -paul w *-- loWorkBook = GetObject('&lsheetloc') With loWorkBook .Sheets(2).Select EndWith With loWorkBook.ActiveSheet.Range("A2:A65536") .NumberFormat = "Mm/Dd/Yyyy" EndWith loWorkBook.Close(.T.) Append From '&lsheetloc' Type XL8 SHEET "PortfolioReturn" pw livingston,montana please use "pw at williamsonenterprises dot com" for e-mail thanks ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I avoid "server busy" message during ole automation | Excel Discussion (Misc queries) | |||
Stopping "Query Refresh" messages | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Stopping the "This removes the subtotal and sorts again." notifica | Excel Discussion (Misc queries) | |||
"unable to paste link" Excel error message | Excel Discussion (Misc queries) |