Notifications
Clear all
Topic starter
Hi
Is it possible to create a VBA code that can open other Excel documents without me typing in the password every time?
Name of documents and password examples
Planner - password1
Tracker - Password2
Hope you can help
Posted : 12/09/2020 4:53 pm
yes quite straight forward
Sub OpenWBwithPW()
Dim p As String
Dim f As String
p = "F:Moth"
f = "TestOpenPW.xlsx"
Workbooks.Open (p & f), Password:="bananas"
End Sub
Posted : 12/09/2020 11:13 pm
