View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
excelnut1954 excelnut1954 is offline
external usenet poster
 
Posts: 175
Default Default date in a UserForm box

Thanks Tom

This is the part I needed.
Filename:=ActiveWorkbook.Path & "\Staging List " _ .............

This works fine.

I see where there are other replies that refer to the "UNC path". I was
reading about that in other posts dealing with this type of coding. I
don't understand it yet. But, I'll get into that subject area later.
For now, this was at the very least, a quick fix.
I also posted a new topic about this. Sorry for the confusion. After
posting this here, I thought that maybe I should have just started a
new topic, that this might get buried.... and it was actually a
different problem than my original post here.
Anyway, still learning how this site operates. All I know is that there
is no shortage of help here.
Thanks to all who chime in.

J.O.