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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Open Text file with macro 1
Mapped vs Network drives 2
Help with simple user form 8
Word VBA - recursively add macrobutton fields - order reversed 2
VBA Macro to Create Sheets Based on Column of Values 1
Importing Large Text File Problem 7
Re-enter space in a cell if user accidently deletes it 2

Top