View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rjtaylor[_5_] rjtaylor[_5_] is offline
external usenet poster
 
Posts: 1
Default opening a workbook

Hi I am trying to open a workbook I figured out how to open a specifi
workbook if I have the name. My problem is I Want to open a workboo
that is named the same name as the activeworkbook plus the name
Backup

Workbooks.Open ("C:\Documents and Settings\default\Desktop\ORL
Schedule\")

I am not sure what to put after Schedule\

I did get the name of active workbook as b (but it adds .xls to it)
Thanks In Advance

RO

--
Message posted from http://www.ExcelForum.com