Hi Professionals,
I am running Win7 MS Office 2010 and Visual Basic 6.5.
I am trying to automate a .pdf Output and came so far to only enter a
filename for the printed .pdf. Since the outfile is to have a similar
name as the inputfile, the save as could be automated as well.
Now for my code so far:
Is there a way to insert something like
Help is much appreciated!
Greetings
Gerne auch auf Deutsch antworten, habs nur mal universell verfasst
I am running Win7 MS Office 2010 and Visual Basic 6.5.
I am trying to automate a .pdf Output and came so far to only enter a
filename for the printed .pdf. Since the outfile is to have a similar
name as the inputfile, the save as could be automated as well.
Now for my code so far:
Visual Basic-Quellcode
- Sub Macro2()
- Dim x, i As Integer
- Dim y As String
- x = 1
- i = 1
- y = x
- Do While i < 999
- If Dir("D:\Video\list\b-" + y + "\") = "" Then
- i = i + 1
- x = i
- y = x
- Else
- ActiveDocument.MailMerge.OpenDataSource Name:="D:\Video\list\b-" + y + "\" + y + ".xlsx", _
- ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
- AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
- WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
- Format:=wdOpenFormatAuto, Connection:= _
- "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=D:\Video\list\1.xlsx;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=37;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:G" _
- , SQLStatement:="SELECT * FROM `Sheet1$`", SQLStatement1:="", SubType:= _
- wdMergeSubTypeAccess
- ActiveDocument.MailMerge.ViewMailMergeFieldCodes = wdToggle
- With ActiveDocument.MailMerge
- .Destination = wdSendToPrinter
- .SuppressBlankLines = True
- With .DataSource
- .FirstRecord = wdDefaultFirstRecord
- .LastRecord = wdDefaultLastRecord
- End With
- .Execute Pause:=False
- End With
- i = i + 1
- x = i
- y = x
- End If
- Loop
- End Sub
Is there a way to insert something like
Help is much appreciated!
Greetings
Gerne auch auf Deutsch antworten, habs nur mal universell verfasst