Also I tried the below syntax with the same error : Type Mismatch ???
doc.MailMerge.OpenDataSource strPath & strDataSource,false,false,false,false,"","","","",false,,"","SELECT * FROM `Sheet1$`","",""
Any suggestion ????
Still I have a Sheet1 Dialog though I have the below syntax ???
doc.MailMerge.OpenDataSource strPath & strDataSource,,,,,,,,,,"SELECT * FROM `Sheet1$`"
What should be the exact syntax ??
wordDoc.MailMerge.OpenDataSource.Name=("D:\shared\programs\vbscript\Audi\From_Mail_Merge\final\Mail_Merge_Data_Form.xls", _
SQLStatement="SELECT * FROM `Sheet1$`")
I have converted that script from VBA to VBS , But I have faced with that problem :
Type mismatch 'MailMerge.OpenDataSource
Dim msWord
Dim wordDoc
Dim wkbk
Dim headerRange
Dim headerValues
Dim i
Const wdFormLetters = 0
Const wdFieldMergeField = 59
Const wdSendToNewDocument = 0
Const...
How can I do copying to files including variables from inside the vbscript :
FSO.CopyFile &Folder &"\" &FileName &"*.txt", &Folder &"\" &FileName &".txt"
Dim oBook
Dim Sheet
Dim FileName
dim shell
Set objFiles = CreateObject("Excel.Application")
FileName =...
I compared the output of 2 text files . One is generated from the inside Excel application save as tab delimited text file and the other is generated from the below script .
There was a difference between the two text files . Any help ?
Why that I can not use the format -4158 with the below...
I have a file like below . The good pages must have 3 conditions :
The pages that containing page total only must have 50 lines.
The pages that containing customer total only must have 53 lines.
The last page of Customer Total should be the last page.
How can I accomplish separating good...
Hello ,
I know you are using original version of FWH 2.7 . Can you borrow me this version in zipped format to my mail becuase I need it to be evaluated before buying it ?
Thanks
I am in dispered need to my allpication to be runned as pointed application does . I need an easy moluse driver for clipper 5.01 application . Please help .
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.