I have a VBA macro in Word 2010 that lets the user carve out pieces of a document and save them to a Content Library. The user highlights a section of text, for example a product description, then runs the macro, which creates a temporary document, pastes in the selected text, then opens a Save As dialog. The macro grabs the first line of the selected text and suggests that as the filename to use in the Save As. Here's my code for the SaveAs part:
'Get the present default filepath for documents
defpath = Options.DefaultFilePath(wdDocumentsPath)
'Change it to desired folder
Options.DefaultFilePath(wdDocumentsPath) = contentlibraryfolder
.Name = suggesteditemtitle
'Change the default filepath for documents back to the original default
Options.DefaultFilePath(wdDocumentsPath) = defpath
Works as expected. Here is the result:
If I just click Save (accepting the suggested filename), it tells me that the filename is not valid. Doesn't matter what the name is or how long the name is, I always get this error. If I shorten the filename and try again, same error.
Only if I completely delete the suggested name and type something new will it accept the name and perform the save.
Does anybody know what's going on and how to fix this?