View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Lostguy Lostguy is offline
external usenet poster
 
Posts: 15
Default A workbook of macros which runs on external workbooks.

Joel,

The code fails at "If bk < ThisWorkbook Then" (Object does not
support method/property).
Also, does this open the Open File dialogue box the same as
GetOpenFilename? That is what I was trying to use.

JLGWhiz: I might just go that route . (Or I can just shorten my
sheetnames.) Thanks!

VR/

Lost