|Lets get this correct,|
A leading white space in the file name does not matter,
because the operating system will not allow a leading white space in a file name.
A leading white space in the file name stored in an Excel file does matter
because Excel reads the white space as a legitimate character.
So your actual file name cannot have a leading space,
only the file name as stored in Excel can have a leading space.
Which can cause Excel to give an error message.
If your stored file name has a leading space,
then you will get an error message
If your actual file name has an embedded space,
then your stored filename must also have an embedded space.