
Is Power Bi, the silent death of SSRS?
Well, the end-purpose of both tools is to help business users with high-end reporting. Where does the difference lie? The changing role of Business Users from just “receiving” the powerful… Read more »
Well, the end-purpose of both tools is to help business users with high-end reporting. Where does the difference lie? The changing role of Business Users from just “receiving” the powerful… Read more »
Yes – If you are a “BUSINESS USER” (non-programmer) looking to get into programming (part time/full-fledged). My whole point stands on one belief – You learn best when “you connect what you learn… Read more »
The below code will add serial numbers up to 500 in your sheet and along with it will show progress on the status bar. Sub progressStatusBar() Application.StatusBar= “Start Printing the… Read more »
Here are the primitive commands to open an XML file in Microsoft Excel. Sub Open_XMLFile() Dim OXML As Workbook Set OXML = Workbooks.OpenXML(“c:\sample.xml”) End Sub Sub Open_XML_File_As_List() Dim OXML As… Read more »
Vlookup: The syntax for Vlookup is: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Index: The Syntax for Index is: INDEX( array, row_number, [column_number] ) Match: The Syntax for Match is: MATCH( value, array, [match_type] ) Problem:… Read more »
The below code merges around 50 ascii files into one It uses File System Object and you need to add a reference of Microsoft Scripting Runtime Sub Append_Text_Files() Dim F1… Read more »
All you have to do just enter “reverse” function in a cell and refer to the cell in which you have text which you want to reverse. Public Function reverse(ByVal… Read more »
Just select a range and run this code, excel will speak all the text what you have in that range, cell by cell. Sub Speak() Selection.Speak End Sub Do wonders… Read more »
The below code will let you save each Worksheet as a single PDF Sub SaveWorkshetAsPDF() Dimws As Worksheet For Each ws In Worksheetsws.ExportAsFixedFormat xlTypePDF, “ENTER FOLDER NAME HERE” ; ws.Name… Read more »
There’s a calculator in Excel 2010 but by default this feature is hidden, to get the calculator on your Excel screen navigate to Quick Access toolbar options, it’s the down… Read more »