Find Jobs
Hire Freelancers

Add some VBA code

€8-30 EUR

Closed
Posted over 7 years ago

€8-30 EUR

Paid on delivery
To save each serial letter into a single PDF, I use the following code: -------- Sub Merge_To_Individual_Files() 'Merges one record at a time to the chosen output folder [login to view URL] = False Dim StrFolder As String, StrName As String, MainDoc As Document, i As Long, j As Long Set MainDoc = ActiveDocument With MainDoc StrFolder = "C:\Users\Info\Downloads\" For i = 1 To .[login to view URL] With .MailMerge .Destination = wdSendToNewDocument .SuppressBlankLines = True With .DataSource .FirstRecord = i .LastRecord = i .ActiveRecord = i If Trim(.DataFields("Az")) = "" Then Exit For StrName = .DataFields("Az") End With .Execute Pause:=False End With StrName = Trim(StrName) With ActiveDocument .SaveAs2 FileName:=StrPath & StrName & ".docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False ' and/or: .SaveAs2 FileName:=StrPath & StrName & ".pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False .Close SaveChanges:=False End With Next i End With [login to view URL] = True End Sub --- Actually, the code runs quite fine, but the problem is that the serial print contains a dynamic picture via the INCLUDEPICTURE function. Thus, it is required to update each newly created document before saving by the following code. Anybody who can help to ut it to the right place in the source text? [login to view URL] [login to view URL](Array("Gerade Verbindung mit Pfeil 3")). _ Select [login to view URL]
Project ID: 11362016

About the project

10 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average €25 EUR for this job
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flaw I am very much able to work on this. ***I am ready to start Waiting for further discussion with thanks and regards
€28 EUR in 1 day
4.5 (38 reviews)
5.5
5.5
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
€28 EUR in 1 day
4.8 (42 reviews)
4.7
4.7
User Avatar
I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification. Ready to start work immediately.
€23 EUR in 1 day
4.3 (53 reviews)
5.1
5.1
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Can you send me some example serial letter so I can try fixing the code? Send me a message for more information. Looking forward to work with u. Kind regards, SlenDATA
€30 EUR in 1 day
4.8 (15 reviews)
4.4
4.4
User Avatar
Hello Sir, I am an expert VBA programmer and I should be able to help you on this. Though I would need to files to debug and fix the code as requested. Thx Aanvik
€34 EUR in 2 days
5.0 (1 review)
0.8
0.8
User Avatar
A proposal has not yet been provided
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Highly responsible person Eager to work & learn. Good communication skills. Proficient at automating Excel Converting PDF to any text format. I offer efficiency and high quality work.
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can place the code you want correctly. If you want, I can add other function and formating in the word file before saving. Regards Jozef
€20 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Lüneburg, Germany
5.0
106
Payment method verified
Member since Jul 21, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.