I am running the below code which will open a folder based upon what the user enters into a text box.
This works fine if I am just going to run it once. If I try to run the code a second time, I get permission denied? Can someone help me understand why it works perfect once, but not a 2nd time? The line that is highlighted as causing the error is this one:Code:varProgram = UserForm1.Text Set wordapp = CreateObject("word.Application") wordapp.Documents.Open "C:\Main\" & varWord & "_New.doc" wordapp.Visible = True strFolder = "C:\Main\" & varWord & "_New\\" FollowHyperlink Address:=strFolder, NewWindow:=True
Code:FollowHyperlink Address:=strFolder, NewWindow:=True




Reply With Quote