KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Using 2010 Excel VBA - I'm just trying to open a folder through a sub. What am I doing wrong here? VBA Sub openFolder() Dim preFolder As String, theFolder As String, fullPath as String theFolder = Left(Range("T12").Value, 8) preFolder = Left(Range("T12").Value, 5) & "xxx" fullPath = "P:\Engineering\031 Electronic Job Folders\" & preFolder & "\" & theFolder Shell(theFolder, "P:\Engineering\031 Electronic Job Folders\" & preFolder, vbNormalFocus) End Sub
Tags (comma-separated)
Save Edits
Cancel