-
ExportXML 800A0400 VBscipt Error
When I execute the following script I get a VBScript compilation error at the "=" of the "ObjectTYpe:=" line.
The error text = "Expected statement"
I installed the latest version of the VBScript engine and I'm still getting the error.
Option Explicit
Dim appAccess
Set appAccess = CreateObject("Access.Application")
appAccess.opencurrentdatabase "c:\Access DB\PMDW.mdb"
appAccess.Visible = False
appAccess.ExportXML _
ObjectType:=acExportTable, _
DataSource:="HR00100_Employee_Hour_Range_Org_Lvl_1 ", _
DataTarget:="c:\ItInsightTemp\HR00100_Employee_Hou r_Range_Org_Lvl_1.xml", _
SchemaTarget:="c:\ItInsightTemp\HR00100_Employee_H our_Range_Org_Lvl_1.xls"
appAccess.closecurrentdatabase
WScript.Quit
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules