In VBA, too, we can save the file as “Save As. But it is not that familiar with the concept “Save As.” In regular worksheet shortcut key to Save As the file is the F12 key. We have two kinds of saves in excel or any file one is “Save,” and another one is “Save As.” Ctrl + S is the popular shortcut key as the Ctrl + C & Ctrl + V around the globe. To save the workbook using vba code we use the object Workbook with the SaveAs function.Īfter all the hard work we have done in the workbook, we save it, isn’t it? It is painful to lose the data we have worked on. VBA Save As method is used to save the excel file to a specific location.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |