{"id":60765,"date":"2023-11-06T12:43:34","date_gmt":"2023-11-06T11:43:34","guid":{"rendered":"https:\/\/ekiwi-blog.de\/60765\/vba-query-memory-path-before-saving\/"},"modified":"2023-11-06T12:54:34","modified_gmt":"2023-11-06T11:54:34","slug":"vba-query-memory-path-before-saving","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/60765\/vba-query-memory-path-before-saving\/","title":{"rendered":"VBA: Query save path before (Save as dialog)"},"content":{"rendered":"

VBA<\/abbr> can be a great helper in the Microsoft Office world for automating everyday tasks, for example automatically saving file attachments from Outlook emails<\/a> or reading the contents of a PDF and inserting them into an Excel file<\/a>. For such automatisms, it can be helpful to query the storage path, i.e. the directory where the data or files are to be saved, via a dialogue beforehand.<\/p>\n

Public Sub<\/span> SaveWithDialog()\r\n    Dim<\/span> folderToSave As String<\/span>\r\n    folderToSave = SaveToFolder\r\n    'Here are the further instructions for using the save as path<\/span>\r\n    Debug.Print<\/span> folderToSave\r\nEnd Sub<\/span><\/code><\/pre>\n
The 3-4 lines of code shown here are our basic function, which can then be executed as a macro. Here we define a string variable folderToSave<\/em>, to which the directory path is then passed. With Debug.Print<\/em> we output the memory path determined via a selection dialogue in the direct window.<\/p>\n
The query of the memory path using a “Save as” dialogue is outsourced here in a separate function. The problem is that such dialogue functions do not exist directly in VBA or are not available in all programs, such as Outlook. Instead, you have to use alternative workarounds. There are two variants for this.<\/p>\n
The function that handles the user’s save path query is called SaveToFolder<\/em> in our example, is parameterless and returns the directory path selected by the user.<\/p>\n
\n
\n
Table of content<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n