Hi All!
I'm trying to setup a macro that will update a few excel files then save them. I have the hyperlinks listed in an excel sheet like below so that the macro knows where to reference. Thanks!!
Data Datapod File Name
01/31/17 S:\doc1
01/31/17 S:\doc2
02/01/17 S:\doc3
02/01/17 S:\doc4
01/18/17 S:\doc5
Last edited by harry1013; 03-01-2017 at 12:08 PM.
You could try Google:
One link found
http://www.excel-easy.com/vba/examples/close-open.html
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thanks but it still doesn't show me how to loop a code into running each file. It just states the basics of how it works.
You use this code as the basic macro
Around it you loop through each row and open the file you mention in the columns A then run the code to open update and close and do the next one.
Try reading the code like you would a book, line by line if this then that else ....
VBA is straight forward and logic thinking. It's good brain gymnastics and doing it yourself using found samples is the way to learn it we all did one way or another and practice, patience and perseverance are required.
If you have a macro and are still very stuck attach it as a sample and we go on from there but at least give it a try, you did not mention that you do not know nothing of VBA
Never mind, someone replied to my post from another excel forum that was very helpful. Below is the code I'm now using now. For future reference Keebellah, not everyone is as skilled at coding as you are. Googling these answers doesn't always provide the custom fit I'm looking for since I don't have the background and knowledge you do.
Sub openfilessave()
Application.ScreenUpdating = False
For i = 22 To 34
With Workbooks.Open(Range("B" & i))
.Save
.Saved = True
.Close 0
End With
Next
Application.ScreenUpdating = True
End Sub
And for your reference too, skill comes with practice and I am still learning every day.
I'm not skilled I just try solving it and use logic.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks