View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Asif Asif is offline
external usenet poster
 
Posts: 37
Default Excel 2007 - Dynamic sheet naming

Hello,

I am getting runtime error "1004: Application-defined or object-defined
error" with the fourth expression:

Workbooks.Open bestfile_name, UpdateLinks:=0 [no error]
ActiveWorkbook.Activate [no error]
Set bestfile = ActiveWorkbook [no error]
Set bestrange = bestfile.Sheets(best_sheet_name).Range(best_range_ name) [
[error 1004]

The variables are defined as follows:

- bestrange as Range
- bestfile As Workbook
- best_sheet_name, best_range_name As String

This expression was perfectly fine in Excel 2003.

I will appreciate any help in this respect.

--
Thanx & regards,
Asif