View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PJ Usher PJ Usher is offline
external usenet poster
 
Posts: 11
Default Error following Microsoft Article

I followed Microsoft Knowledge Base Article 213299 XL2000: For Each Loop to
Determine If an Excel Workbook is Open

When I run the code the line

Dim wb as Workbook

is highlighted and I receive an error

Compile error: User-defined type not defined

?????

The code is written exactly as written in the article. Can I fix this?

Thanks for any help

PJ