Opening Excel files in cascade through VBa
Patrick,
A cursory look at the code suggests that it look okay. There is certainly
nothing wrong in the principle of opening other workbooks ( I just setup a
test and File A opened File B which opened File C which opened File D, all
worked okay)
Are you getting an error, or is it just not opening? If you are, what is the
error?
Have you stepped through the code, is the user returned as the code tests?
Where is the GetUserName API declared?
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
|