>>>>"C:\DOCUMENTS AND SETTINGS\JAMES.FOX\MY DOCUMENTS\VF I DATA\PSS\TEMP\0VE0HHCJB.XLS"
>>>
>>>I think the macro would have worked providing the command string was enclosed with parens:
>>>
"(C:\DOCUMENTS AND SETTINGS\JAMES.FOX\MY DOCUMENTS\VF I DATA\PSS\TEMP\0VE0HHCJB.XLS)"
>>>
>>>I think (but don't know for sure) that parens are required for folders with spaces in their names.
>>
>>No that does not work.
>Ooooops! Sure glad I disclaimed and lives weren't depending on it:-). But something in me is screaming to give it a try - so back to the command window and back in a few!
Probably if you put the quotes inside of the parenthesis, but that would be using a macro to do name expression:
[("C:\DOCUMENTS AND SETTINGS\JAMES.FOX\MY DOCUMENTS\VF I DATA\PSS\TEMP\0VE0HHCJB.XLS")]
You can leave the parenthesis out, and it is straight macro sub. But using the name expression, with no macro substition at all, is probably the best...
Steve Gibson