I got a question like this: Is it possible when saving a file in vba to add the current month/year to the end of the filename with the format mmm/yy? The code I have so far….. <code>Workbooks(“test.xls”).SaveCopyAs (“C:\xls files\test.xls”)</code> I need the month/year to be added to test.xls so that it looks like “test_Oct-07.xls” Let’s Read More
Category: Microsoft Office
How To Vlookup Numbers Stored As Text In Excel?
VLOOKUP with numbers and text Generic formula =VLOOKUP(val&””,table,col,0) Summary To use the VLOOKUP function to retrieve information from a table where the key values are numbers stored as text, you can use a formula that concatenates an empty string (“”) to the numeric lookup value, coercing it to text. In the example shown, the formula in H3 is: =VLOOKUP(id&””,planets,2,0) // returns Read More
The Most Important New Features in Windows 11
By ERIC RAVENSCRAFT After leaks and rumours, we got our first look at the future of the platform. Here’s what you have to look forward to this fall. TODAY, MICROSOFT OFFICIALLY unveiled Windows 11, the next major version of its operating system (after a leak unofficially unveiled it last week). It’s going to bring a new, revamped Start Read More
How to Enable “Precision as Displayed” in Excel 365
Set rounding precision Click File > Options. … Click Advanced, and then under When calculating this workbook, select the Set precision as displayed check box, and then click OK. Click OK. In the worksheet, select the cells that you want to format. On the Home tab, click the Dialog Box Launcher.
How to Comment & Un-comment a Block in Office VBA Editor
Being able to comment a block of code is a standard operation in any IDE, but for some reason the Microsoft Office VBA Editor does not include that functionality by default. However, the functionality is there and waiting to be used, it’s just hidden in the “Edit” toolbar which is not visible be default. Open Read More
How to Fix “Procedure Too Large” Error in Excel VBA
You probably have one or more gigantic procedures/functions and I think VBA has a limit of 64k or something per procedure. You fix it by splitting that procedure up into multiple procedures that can then be called by the one procedure. So instead of having: You’d have something like: