A few days ago I showed how to call an Open File dialog box. I promised to show you how to let a user specify a filename and path by browsing using the File dialog box. This is much better than using an input box, especially when you want to save the file to a specific folder where you don’t know the full path off the top of your head. Here’s a sample script.<\/p>\n
‘SaveAsDemo.vbs<\/span> I prefer providing a default filename and path, expecting that in most cases it will be sufficient and all the user has to do is click Save. <\/p>\n Now you have some flexibility to offer your users when it comes to finding or specifying files and your scripts can look more like Windows utilities.<\/p>\n","protected":false},"excerpt":{"rendered":" A few days ago I showed how to call an Open File dialog box. I promised to show you how to let a user specify a filename and path by browsing using the File dialog box. This is much better than using an input box, especially when you want to save the file to a specific folder where you don’t know the full path off the top of your head.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,24],"tags":[],"class_list":["post-329","post","type-post","status-publish","format-standard","hentry","category-general","category-vbscript"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
‘specify a default filename<\/span>
strFile=SaveAs(“C:\\demo.txt”)<\/span>
If strfile<>”” Then WScript.Echo “Saving as ” & strFile<\/span>
‘don’t specify a filename but set parameter to blank<\/span>
strFile=SaveAs(“”)<\/span>
If strfile<>”” Then WScript.Echo “Saving as ” & strFile<\/span>
‘**********************************<\/span>
‘* File SaveAS Function *<\/span>
‘**********************************<\/span>
Function SaveAs(strFile)<\/span>
‘This requires Windows XP\/2003<\/span>
Set objDialog=CreateObject(“SAFRCFileDlg.FileSave”)<\/span>
objDialog.filename=strFile<\/span>
objDialog.OpenFileSaveDlg<\/span>
SaveAs=objDialog.FileName<\/span>
End Function<\/span>
The object we’re using in the function is almost the same as what we used to open a file. The function as written requires a default vault value, even if it is blank. If you select an existing file, you’ll get an warning about overwriting the file. But nothing really happens. The function will return the full path and filename of whatever you select and that’s it. You still need to use something like the FileSystemObject to create the file. This function simply makes it easier for a user to browse to folder and specify a file name instead of having to type it into an input box.<\/p>\n