View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.misc
kilo1990
 
Posts: n/a
Default Macro to Prompt for File -- Neophite Needs HELP

THAT'S IT --- IT WORKS FLAWLESSLY!!!!! THANKS A BUNCH!!!


JE McGimpsey wrote:
No progress - my typo. Should be

...Worksheets(...

not

...Worksheet(...

In article . com,
"kilo1990" wrote:

A new error..which I consider progress! Here's the error:

Runtime error '438': Object doesn't support this property or method

Here's the highlighted line:

With Workbooks("Screen Research old.xls").Worksheet("Last
Import")