Excel Workbook Link forces interaction

De

06/09/2005 10:14:16

Cetin Basoz
Engineerica Inc.
Izmir, Turquie

À

06/09/2005 09:57:14

Edgar Bolton
Madison, Tennessie, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Autre

Titre:

Re: Excel Workbook Link forces interaction

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

01046984

Message ID:

01046997

Vues:

14

This message has been marked as the solution to the initial question of the thread.

Edgar,
Use 2nd parameter of Workbooks.Open(cFilename, UpdateLinks , ....)
ie:
.WorkBooks.Open(cSpreadsheet,0)
Cetin

>Hello VFP world,
>
>I am developing an application that when automatically run will be unattended...
>

>   oExcel=CREATEOBJECT("Excel.Application")
>   With oExcel
>      .DisplayAlerts= .F.
>      .WorkBooks.Open(cSpreadsheet)
>      .Sheets("AFO").Select()
>...
>

>
>Interaction is currently required due to LINKS among spreadsheets...
>

>The Workbook contains links to other data sources.
>- To update all linked information, Click Yes.
>- To keep the existing information, click No.
>  |Yes|  |No|
>

>I would prefer 'No' at this time, but it does not matter here!
>
>How may the app be provided an answer?
>
>FYI,
>Part...Ex8 mem dump follows ---
>
>
>C "ActivateMicrosoftApp"
>C "Method"
>C "(Index as XlMSApplication)"
>C "ActiveCell"
>C "PropertyGet"
>C "(RowIndex as Variant, [ColumnIndex as Variant])"
>C "ActiveChart"
>C "PropertyGet"
>C "ActivePrinter"
>C "PropertyGet"
>C "ActivePrinter"
>C "PropertyPut"
>C "ActiveSheet"
>C "PropertyGet"
>C "ActiveWindow"
>C "PropertyGet"
>C "ActiveWorkbook"
>C "PropertyGet"
>C "AddChartAutoFormat"
>C "Method"
>C "(Chart as Variant, Name as String, [Description as Variant])"
>C "AddCustomList"
>C "Method"
>C "(ListArray as Variant, [ByRow as Variant])"
>C "AddIns"
>C "PropertyGet"
>C "(Index as Variant) as AddIn"
>C "AlertBeforeOverwriting"
>C "PropertyGet"
>C "AlertBeforeOverwriting"
>C "PropertyPut"
>C "AltStartupPath"
>C "PropertyGet"
>C "AltStartupPath"
>C "PropertyPut"
>C "AnswerWizard"
>C "PropertyGet"
>C "Application"
>C "PropertyGet"
>C "ArbitraryXMLSupportAvailable"
>C "PropertyGet"
>C "AskToUpdateLinks"
>C "PropertyPut"
>C "AskToUpdateLinks"
>C "PropertyGet"
>C "Assistant"
>C "PropertyGet"
>C "AutoCorrect"
>C "PropertyGet"
>C "AutoFormatAsYouTypeReplaceHyperlinks"
>C "PropertyPut"
>C "AutoFormatAsYouTypeReplaceHyperlinks"
>C "PropertyGet"
>C "AutoPercentEntry"
>C "PropertyGet"
>C "AutoPercentEntry"
>C "PropertyPut"
>C "AutoRecover"
>C "PropertyGet"
>C "AutomationSecurity"
>C "PropertyPut"
>C "AutomationSecurity"
>C "PropertyGet"
>C "Build"
>C "PropertyGet"
>C "COMAddIns"
>C "PropertyGet"
>C "(Index as Variant) as COMAddIn"
>C "Calculate"
>C "Method"
>C "CalculateBeforeSave"
>C "PropertyPut"
>C "CalculateBeforeSave"
>C "PropertyGet"
>C "CalculateFull"
>C "Method"
>C "CalculateFullRebuild"
>C "Method"
>C "Calculation"
>C "PropertyPut"
>C "Calculation"
>C "PropertyGet"
>C "CalculationInterruptKey"
>C "PropertyPut"
>C "CalculationInterruptKey"
>C "PropertyGet"
>C "CalculationState"
>C "PropertyGet"
>C "CalculationVersion"
>C "PropertyGet"
>C "Caller"
>C "PropertyGet"
>C "CanPlaySounds"
>C "PropertyGet"
>C "CanRecordSounds"
>C "PropertyGet"
>C "Caption"
>C "PropertyPut"
>C "Caption"
>C "PropertyGet"
>C "CellDragAndDrop"
>C "PropertyPut"
>C "CellDragAndDrop"
>C "PropertyGet"
>C "Cells"
>C "PropertyGet"
>C "(RowIndex as Variant, [ColumnIndex as Variant])"
>C "CentimetersToPoints"
>C "Method"
>C "(Centimeters as Number) as Number"
>C "Charts"
>C "PropertyGet"
>C "(Index as Variant) as Object"
>C "CheckAbort"
>C "Method"
>C "([KeepAbort as Variant])"
>C "CheckSpelling"
>C "Method"
>C "(Word as String, [CustomDictionary as Variant], [IgnoreUppercase as Variant]) as Logical"
>C "ClipboardFormats"
>C "PropertyGet"
>C "Columns"
>C "PropertyGet"
>C "(RowIndex as Variant, [ColumnIndex as Variant])"
>C "CommandBars"
>C "PropertyGet"
>C "(Index as Variant) as CommandBar"
>C "CommandUnderlines"
>C "PropertyPut"
>C "CommandUnderlines"
>C "PropertyGet"
>C "ConstrainNumeric"
>C "PropertyPut"
>C "ConstrainNumeric"
>C "PropertyGet"
>C "ControlCharacters"
>C "PropertyPut"
>C "ControlCharacters"
>C "PropertyGet"
>C "ConvertFormula"
>C "Method"
>C "(Formula as Variant, FromReferenceStyle as XlReferenceStyle, [ToReferenceStyle as Variant], [ToAbsolute as Variant], [RelativeTo as Variant])"
>C "CopyObjectsWithCells"
>C "PropertyPut"
>C "CopyObjectsWithCells"
>C "PropertyGet"
>C "Creator"
>C "PropertyGet"
>C "Cursor"
>C "PropertyGet"
>C "Cursor"
>C "PropertyPut"
>C "CursorMovement"
>C "PropertyPut"
>C "CursorMovement"
>C "PropertyGet"
>C "CustomListCount"
>C "PropertyGet"
>C "CutCopyMode"
>C "PropertyGet"
>C "CutCopyMode"
>C "PropertyPut"
>C "DDEAppReturnCode"
>C "PropertyGet"
>C "DDEExecute"
>C "Method"
>C "(Channel as Number, String as String)"
>C "DDEInitiate"
>C "Method"
>C "(App as String, Topic as String) as Number"
>C "DDEPoke"
>C "Method"
>C "(Channel as Number, Item as Variant, Data as Variant)"
>C "DDERequest"
>C "Worksheets"
>C "PropertyGet"
>C "(Index as Variant) as Object"
>C "_Default"
>C "PropertyGet"
>C "_Evaluate"
>C "Method"
>C "(Name as Variant)"
>C "_Run2"
>C "Method"
>C "([Macro as..." 611 bytes

Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad

Répondre

Fil

Voir