File Dialog with Default Value that has Spaces

[CedarTree]

Hello - using a file dialog (generally works fine) but it truncates a file name when I put in a default value with spaces. I've tried Chr(34)+DefaultPath+Char(34) and also tried replacing any spaces with %20. No luck so far. Any suggestions? Thanks!

 

[theDBguy]

I just gave it a try, and nothing was truncated.

 

[CedarTree]

Hmmm... the filename has a "!" at the beginning... would that impact things?

 

[theDBguy]

Hmmm... the filename has a "!" at the beginning... would that impact things?

Just tried it with a ! in the beginning of the file name, but it still worked.

 

[CedarTree]

Very strange. I would end up getting "Only.accdb". PS, I also have an "!" in the beginning of the final folder name (e.g., \TDS Economy\ in your example, would be \!TDS Economy\, but that shouldn't impact things I would think.

 

[theDBguy]

Very strange. I would end up getting "Only.accdb". PS, I also have an "!" in the beginning of the final folder name (e.g., \TDS Economy\ in your example, would be \!TDS Economy\, but that shouldn't impact things I would think.

Right. It didn't matter when I added the ! to the folder's name.

 

[CedarTree]

VERY VERY WEIRD!!! Thanks for trying!!!

 

[isladogs]

Hmmm... the filename has a "!" at the beginning... would that impact things?

Just because you CAN do something, doesn't mean its a good idea!
Definitely don't ever use apostrophes in file names even though they are also allowed
Doing that will cause a lot of issues in VBA code

 

[CedarTree]

It's just the !, not really "!". But also these are the filenames that a client sent us.

 

[moke123]

It's just the !, not really "!". But also these are the filenames that a client sent us.

Can they be renamed or modified?

 

[CedarTree]

Not easily since these are files that are sent periodically by an external source.