Need answer in 25 minutes, Help!

  • Thread starter Thread starter EagleOne@microsoftdiscussiongroups
  • Start date Start date
E

EagleOne@microsoftdiscussiongroups

2003

I know that one is not to be dramatic but this is real deadline!

Please look at my post minutes ago.

The issue seems to boil down to a variable (even though declared Public) is
coming to SubB() empty. In SubA() the variable shows a value in the code
window.

In the same code window, the value in SubB() is blank.

Therefore, no file is opened, and then, "Dim wks as worksheet" fails even
after what I thought was late binding.

See my code previously presented ( 30 or so min ago).

TIA EagleOne
 
Thanks Doug I am working on it!

How to codeL "Why not pass the filename though"
 
Back
Top