So we're going to switch over to VBA with Alt+F11, Ctrl+G to show the Immediate window, I'm just going to do a couple of tests down here. Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.Īnd today's question sent by Wes, Wes is looking for a user-defined function to give us the last time that this workbook was saved. Learn Excel from MrExcel podcast, episode 1725 - Function for the Last Saved Time! MrExcel podcast is sponsored by "Easy-XL"!
Visit us: for all of your Microsoft Excel Needs!
"The Learn Excel from MrExcel Podcast Series" But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. VBA and Macros: Microsoft Excel 2010 - The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve.Includes crucial information on making Excel 2010 VBA code work with older versions. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful and useful.įor more information on Excel 2010 VBA and Macros, check out. Use Excel® 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Today, in Episode #1725, Bill shows us how to add a small Macro to our Workbook that will show the Date and Time the Workbook was saved. * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.Wes wants to know the last time a particular Workbook was saved. if it doesn't workĪnd you would like to give us feedback (which I would be happy, especially if it works please specify. check the entry 'Microsoft Date and Time Picker Control' ĭrag the new 'DTPicker' icon from the toolbox into the form. The nice thing about the Date and Time Picker is that you can provide a date input field with little effort, which always delivers a date as the result. The control element "Microsoft MonthView Control 6.0 (SP4) can also not be found under other controls.
0 kommentar(er)
