View Single Post
 
Old 06-04-2019, 04:06 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Dave

Spaces often matter in VBA. In the case of the Shell Environ line, we are essentially running the equivalent of a dos command via a command prompt. In that context a space would separate a new parameter rather than a part of a single parameter.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote