Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE COM ADO CDO ADSI LDAP
 | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
- !! A List of Links to various OLE docs !!
- !! Understanding COM !!
- 1129 ObjectCreate
- 1129 OleInitiate Failed UAC
- 1129 OleInitiate Failed
- 1251 Ole - WIL Ole interface Dll not found
- Access to Excel Converter
- Access2000 Transaction Processing Demo
- Add Application to the Windows Firewall Exceptions List
- ADO vs ODBC
- ADO vs OLEDB vs ODBC
- Automatic Update from MicroSoft
- Bring up the RUN Dialog
- BYREF return parameters
- Close All Open OLE COM Objects
- Close an Object
- Closing Objects Explained
- Code to Create a Temporary DB
- Collaboration Data Objects Roadmap
- COM Constants for MS Office Applications
- COM Interfaces Explained
- COM Widestring Value Issue
- CommandTimeOut - lesson learned
- Connection String
- Convert Data Returned OLE
- Converting Pre 2004B OLE Scripts
- Copy Table Structure With SQL
- Create Object
- Create Recordset in Memory
- CreateObject Remote Computer
- Database ISAM Example
- dBase IV Creation
- Delete Mailbox in Exchange
- Determining if a Particular Update has Been Installed
- Determining Whether Automatic Updates is Enabled
- Display the Windows Run Dialog Box
- Does WinBatch Support 3rd party COM objects
- DSO Tabular Paging Demo
- Enumerate Citrix Applications
- Find Object Name and Properties
- Find User on Workstation
- ForEach Problem
- Generate GUIDs using ObjectType
- Get Audio File Information
- Get Information for IOMega Zip Drive
- Get Number of Records in Each Table
- Getting Multivalued Properties and Arrays
- GUID Create
- Handle Reassignment
- How to include an Office Assistant
- Insert Data into an SQL Server 2000
- Install CAPICOM on Win7
- Intcontrol 71 and Number of OLE Channels
- Interacting with Citrix
- IPCONFIG Results From STDOUT
- IsObject UDF
- List Components in Com Catalog
- List Databases on a Server
- List OLE DB Providers
- Load Data from ASCII File to a Java Applet Window
- MatLab COM Automation
- Method with Variant Parameters Explained
- Multi-Dimensional SafeArrays are NOT supported
- Named Parameters
- Object 101
- ObjectCreate Cannot Access Remote Server
- ObjectEventAdd Issue
- Office 2007 Driver Tips
- OLE COM Default Member Discussion
- OLE Explanation
- OLE Failing unless IE4 Installed - DCOM98
- OLE Property and Method Name Limit
- OLE Shell functions
- OLE2 Automation Tips
- Open DB and Permit Working with Tables
- Oracle Objects
- Pass ByRef Type Parameter
- Passing an Array as a Parameter to an OLE Method
- Passing Parameters
- Primer - Fabricated Hierarchical Recordsets
- Problems Writting a VB to WinBatch OLE Code Converter
- Read and Write to a Parallel Port
- RecordSets to HTML - with some Javascript
- Regular Expressions with WB
- Remotely Stop or Start COM Components
- Sample Code to Query a MIMSXServer
- Save Binary Streams to DB
- Set Proxy Server and Port
- Setting Group Policy Objects
- Shell ExtendedProperty
- Shell Helper Object
- SQL Server Update Stored Procedure
- Textract Problem
- textract test
- TextStream and Scripting.FileSystemObject
- Translate VB Default Member Name
- Trapping COM OLE Errors
- UDF to Return an Array of DB Table Types
- Un supported Variant Type Error With Concatenation
- Unicode Conversions with FileSystemObject
- Using the Object Browser
- Using the Visual Basic Object Browser
- Vbscript Array in WIL
- Virtual Server COM CoInitializeSecurity
- VT_DECIMAL Versus FLOAT
- WinBatch and Dot NET
- WinBatch Equivalent To VB Nothing
- WinBatch OnError
- Windows Firewall
- Windows Image Acquisition
- Working with Office Applications
- Write-Read DBF
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
OLE and Passing Parameters
Keywords: 1257 Type Mismatched error named parameters
Question:
I am trying to open a new datasource in word via OLE. Here is the example in VBA that I can't get to work in Winbatch.
Set myDoc = Documents.Add
With myDoc.MailMerge
.MainDocumentType = wdFormLetters
.OpenDataSource _
Name:="C:\MSOffice\Access\Samples\Northwind.mdb", _
LinkToSource:=True, AddToRecentFiles:=False, _
Connection:="TABLE Orders
End With
how do you format multiple parameters in the winbatch statement.
Here is what I have that doesn't work.
testdoc = "c:\mailmerge.doc"
wdOpenFormatAuto = 0
MMrgDSNCS = "QUERY Check List"
MMrgDSNQS = "SELECT * FROM [Check List]"
App = ObjectOpen("Word.Application")
Docs = App.Documents
Doc = Docs.Open(testdoc)
MMrgObj = Doc.MailMerge
MMrgObj.OpenDataSource(newDSN, LinkToSource=1, Format = wdOpenFormatAuto, Connection = MMrgDSNCS, SQLStatement = MMrgDSNQS)
I tried this and I get a 1257 Type Mismatched error:
MMrgObj.OpenDataSource(newDSN,"LinkToSource:=True","Connection:=%MMrgDSNCS%","SQLStatement:=%MMrgDSNQS%")Thanks for your help!!!!
Answer:
My guess is that you are dealing with named parameters...MMrgObj.OpenDataSource(newDSN:: LinkToSource=1, Format = wdOpenFormatAuto, Connection = MMrgDSNCS, SQLStatement = MMrgDSNQS)
Question:
Hi. I'm getting an this error while trying to set a value to a field in a Lotus Notes document.My error is OLE Error 1257: OLE: Type Mismatch.My code to this point looks like this:
session = objectopen("Notes.NotesSession")
db = session.getdatabase("", "names.nsf")
doc = db.CreateDocument
doc.sendto("steve buechler")
I get this error on line 4. All I'm attempting to do is set the value of the item SendTo on a Lotus Notes
document. Any ideas what I'm doing wrong?
Answer:
Is sendto a method or a property? my guess is it is a property. It sounds like maybe it's actually supposed to be a property assignment, but the equals sign is missing: e.g., doc.sendto = "steve buechler"Try this instead....
session = objectopen("Notes.NotesSession")
db = session.getdatabase("", "names.nsf")
doc = db.CreateDocument
doc.sendto ="steve buechler"
Article ID: W14674
Filename: OLE and Passing Parameters.txt
File Created: 2001:04:02:11:54:42
Last Updated: 2001:04:02:11:54:42