Next statement to open the .xls
 

strDirectory = "F:\$Visit\ " & x & "\" & strVisit & " " &
strVisitNumber & " " & strWorksheet & ".xls"

The strDirectory has in it F:\$Visit\12930 Keizer\Visit 4 Worksheet.xls
How do I get "Visit 4 Worksheet" to open on the desktop. What is my next
statement?

Next statement to open the .xls
 

Workbooks.Open(strDirectory)

or

Dim wkbk As Excel.Workbook
Set wkbk = Workbooks.Open(strDirectory)

if you want a reference to the newly opened workbook.

--JP

On Oct 13, 4:16*pm, Donald wrote:
* * * * * *strDirectory = "F:\$Visit\ " & x & "\" & strVisit & " " &
strVisitNumber & " " & strWorksheet & ".xls"

The strDirectory has in it F:\$Visit\12930 Keizer\Visit 4 Worksheet.xls
How do I get "Visit 4 Worksheet" to open on the desktop. What is my next
statement?