I have tried to take the drive letter path(currently my CD drive) off the this file to run in order to not get a "path not found" error, but i get an error for "1004" "masterschedule.xls" could not be found. I also have same file(masterschedule.xls) located in the file from which the program runs,
but doesn't seem to find it. I'm sure I have something worded wrong in code below. have tried
"masterschedule.xls","\masterschedule.xls"
Would like it to read file with no path errors, since it will be run on computer at work.code below, any suggestions welcome.

Set m_objApp = GetObject(, "Excel.Application")
m_objApp.Workbooks.Open "m:masterschedule.xls"
Set m_objSheet = m_objApp.ActiveSheet