Experts Exchange connects you with the people and services you need so you can get back to work.
Dim strFileName As String
Dim strFolder As String
strFolder = "C:\DR\RRTTYU 2013.09.09"
strFileName = Dir$(strFolder & "\*.*")
Do Until strFileName = ""
strFileName = Dir$()
Open in new window
The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.
Dim folder As String
Dim fileName As String
folder = "C:\testing\a folder with.a dot"
fileName = "MyWorkbook.xlsx"
Workbooks.Open fileName:=folder & "\" & fileName
Workbooks.Open fileName:="C:\testing\a folder with.a dot\MyWorkbook.xlsx"
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.