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.
|