Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-12-2017, 09:04 AM
andrbea andrbea is offline Save the same file with different name 35 times Windows 7 64bit Save the same file with different name 35 times Office 2010 64bit
Novice
Save the same file with different name 35 times
 
Join Date: Nov 2017
Posts: 4
andrbea is on a distinguished road
Default Save the same file with different name 35 times

For a client's upload platform (for invoices) I have to send unique details, monthly, eg 35 times. The file in enclosure (it lists all the 35 invoices, giving 6 data fields in a row, per FW-number) This master file (per month) has the same content (about 3 pages long). but the client wants a unique title-name for the file for each ticket created. So I bring up the 3-page master file in Word and save it as FW1. then save it as FW2, then save it as FW 3 etc up to FW 35. Then I go to the Client's platform. Fill in 12 fields per work order (other unique data he needs) and then add the file title eg FW3.



Is there a way to run a macro on the Word master file and interactively fill in the file range for the title, eg FW1 then ending at FW35. Then the macro writes these files to one Word folder (called 02.10). Then, on his online platform, I can access the Word folder (this is already fuunctioning) to pick the files, which have already been created (FW1-FW35). Saving me the boring job of creating them manually, with save as FW 35, for example.
I just want a macro to save 35 files in 1 go, with titles FW1 running till FW35. Anotyher month the first letters might be different, XL1 to XL 46, but always 2 letters and a fixed number of files (max 60)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Save the same file with different name 35 times Save document multiple times with date as filename JonniBravo Word 6 03-13-2017 11:35 AM
ics file - issue with times Officer_Bierschnitt Excel Programming 0 10-06-2016 01:52 AM
Save the same file with different name 35 times vba code for folder name, subfolder directory, file name & revision times klpw Excel Programming 2 12-24-2015 12:31 AM
Save the same file with different name 35 times save dialog box promt doesn't save file brmveen Word VBA 2 11-04-2015 12:51 AM
Save the same file with different name 35 times error: You are attempting to save a file format that is blocked by file block setting zatlas1 Office 8 04-28-2012 02:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft