Thread: Error when VB tries to open file from Windows Explorer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Miller Dave Miller is offline
external usenet poster
  
Posts: 72
Default Error when VB tries to open file from Windows Explorer
Dim MasterFile As String

MasterFile = "R:\Sales\Shared\NEW ITEM TRACKING\Q108\Master Tracker
Q108.xls"

Workbooks.Open MasterFile, , , , , "JDAY"

Reply With QuoteReply With Quote