Workbook references

  • Thread starter Thread starter Murray Williams
  • Start date Start date
M

Murray Williams

When I refer to cells through VBA usually I use the
following syntax without including the .xls extension:
Workbooks("myworkbook").Worksheets("mysheet").cells(1,1)

Two times I have gotten an error that I was able to
resolve by adding in the .xls extension to all of my
references.
Workbooks("myworkbook.xls").Worksheets("mysheet").cells
(1,1)

One time it was on my computer that had run that
particular macro and file many times before. Today a
coworker had a problem running another macro that I and
several other of my coworkers had no problems running.

I know that I could go into all my macros and add in
the .xls extension but I would still like to understand
what is causing this. Does anyone know why? Is it a
setting within excel or something that another file that
may be open is causing?

thanks,

Murray Williams
 
Hate to bump this, but this is really bugging me...I'd
appreciate anyone who has any ideas to post them.

thanks,

Murray
 
Hi Murray,

This behavior has to do with whether the user has file extensions hidden for
"known" file types or not. This is an OS-level setting (available via Tools
| Folder Options in Windows Explorer). Using .xls at the end will always
work, regardless of the user's setting, so that is the preferred way to
refer to an open workbook.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Back
Top