View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donald Donald is offline
external usenet poster
 
Posts: 15
Default 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?