Filename by user input

E

Evan Weiner

In, e.g., AddPicture, Filename:= arg is being fed by user input from Excel
cell. Spaces cause error. User surrounding the name in quotes also errors.
Recourse is Docume~1 game that I think I have under control. Is there an
easier way? I'm not ready to try PATH.
 
E

Evan Weiner

As I tinker with this, using Dir() to check the path up to the file name
won't take Docume~1 or spaces. I tried ChDir() - it seems to work for both ~
and spaces, no quotes required. Strange. Hopefully, I'll be able to change
the default directory and then use simple filenames.
 
Top