View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Sri via OfficeKB.com Sri via OfficeKB.com is offline
external usenet poster
 
Posts: 20
Default subscript out of range

Hello Jacob,

Thansk for your reply. It works fine.

Sri



Jacob Skaria wrote:
Set xlw_source = Workbooks.Open(srcDBName)

Hello,

[quoted text clipped - 10 lines]
srcDBName = vPath & "\" & "Report_" & inpDate & ".xls"
Set xlw_source = Excel.Workbooks(srcDBName)


--
Message posted via http://www.officekb.com