Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-06-2017, 02:34 AM
AHKpie AHKpie is offline vba newb problem Windows 7 64bit vba newb problem Office 2010 64bit
Novice
vba newb problem
 
Join Date: Jun 2017
Posts: 7
AHKpie is on a distinguished road
Default


Respectable programmers,

I think I have found the solution.
How nice software programming is if you understand what you are doing. Or at least if you think you understand what you are doing.

Have a nice day and thank you for reading my posts.
Reply With Quote
  #2  
Old 07-07-2017, 07:07 AM
AHKpie AHKpie is offline vba newb problem Windows 7 64bit vba newb problem Office 2010 64bit
Novice
vba newb problem
 
Join Date: Jun 2017
Posts: 7
AHKpie is on a distinguished road
Default

I solved my problem of not working macro by simplyfing Paul Edsteins script into this:
Code:
Sub Simplify()
Dim file
Dim path As String


'YOU MUST EDIT THIS. Put here the files you want to change with your macro.
path = "c:\test\"


file = Dir(path & "*.*")
Do While file <> ""
Documents.Open FileName:=path & file

' This is the call to the macro you want to run on each file in the folder
Call Macro2

' Saves the file
ActiveDocument.Save
ActiveDocument.Close
' set file to next in Dir
file = Dir()
Loop
End Sub
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
vba newb problem Newb needing VBA solution to change formatting derekcentrico Word VBA 10 12-12-2016 12:27 PM
vba newb problem newb - search and replace - WILDCARDS - keep original...? Bansaw Word 4 09-01-2016 11:16 AM
Backing up importing & exporting ?? I am a newb Jazz OneNote 0 01-27-2016 10:18 PM
vba newb problem newb - need help automating catalogue production Deeper Office 2 09-09-2015 01:45 AM
NEWB to Macros - formatting exports EC37 Excel Programming 52 06-25-2014 06:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


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