Skip to content
  • Qlikview
  • SQL Server
  • Power BI
  • Excel / VBA
  • About
  • Contact

BuffaloBI.com

Qlikview | SQL Server | Power BI | Excel

BuffaloBI.com

Excel VBA

Excel VBA Copy and Rename Files in Folder and Subfolders

November 18, 2018November 18, 2018 by bbiadmin

This request came from a subscriber who was looking for a macro to rename files in a given folder, and make a copy of the renamed file within the same folder.  Once the files in the top level folder were processed, then cycle through each subfolder and do the same.  The following macro will accomplish … Read more

Leave a comment

Excel VBA Count Character in Range

October 1, 2018October 1, 2018 by bbiadmin

This post demonstrates an Excel VBA macro to count the number of instances of a specified character within a range of cells.  The macro prompts the user to input a character, then will loop through each cell and accumulate a count of instances the specified character appears.  The final count is then displayed in a … Read more

Leave a comment

Excel VBA Alternate Row Colors

November 17, 2018September 25, 2018 by bbiadmin

This post will demonstrate a simple VBA macro to shade background colors for alternate rows in a specified range.  This can come in handy when you need to reset the alternate colors for different files, or if you are looking to test out different combinations and want to cycle through them quickly. Version of Excel: … Read more

Leave a comment

Excel VBA Search for Files in Folder and Subfolders

June 28, 2018June 28, 2018 by bbiadmin

This post details a VBA macro to search for files based on an search string, then lists all files that have a partial match in the file name.  The macro will search a specified folder (user prompted to select base folder), and will then loop through and search each subfolder until all have been examined. … Read more

Leave a comment

Excel VBA Find Differences Between Two Arrays

April 23, 2018April 23, 2018 by bbiadmin

The following post will detail how to compare the contents of two arrays (two-dimensional) and highlight cells in the update table where there are differences.  The use case revolves around comparing and updated table against the original to see where cell values have changed.  If a given value has indeed changed, the macro will highlight … Read more

Leave a comment

Excel VBA Compare Arrays

April 15, 2018April 15, 2018 by bbiadmin

The following post will compare the contents of one array against the contents of another.  The use case revolves around taking a detail list and comparing each row against a master list, to make sure each row of the detail array exists.  If the detail record does not exist, the cell background color of the … Read more

Leave a comment

Excel VBA Save File as PDF Document

October 19, 2017 by bbiadmin

The following post provides an example of how to save an Excel file as a PDF Document, using VBA code.  The macro first prompts you to enter a file name, then opens a second dialog window to pick the destination folder to save the PDF Document.  There is also an option to determine which tabs … Read more

Leave a comment

Excel VBA Copy and Rename Files

October 3, 2017September 23, 2017 by bbiadmin

I received a question on post Excel VBA Rename Files and thought a separate post was warranted to cover the answer.  In the following example, I will setup an Excel file to do the following: Allow user to pick a folder and list out the file content (file path and name) Allow user to pick … Read more

9 Comments

Excel VBA Split Delimited List

October 10, 2017June 1, 2017 by bbiadmin

The following post illustrates how to split a delimited list of values in a cell, using a VBA module.  I will demo a simple example where I received a semi-colon delimited list of email addresses, and I wanted to split them up into individual cells.  I use this VBA code frequently, and figured it would be … Read more

Leave a comment

Excel VBA Custom Function

October 10, 2017April 21, 2017 by bbiadmin

The following post illustrates how to create a custom function in Excel, using a VBA module.  In particular, I will create two functions that parse a cell containing a full name (First and Last) into two separate cells.  I frequently need to run through this process, so I figured it would be a good way … Read more

Leave a comment
Post navigation
Older posts
1 2 3 Next →
+ More

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • Excel VBA List Files in Folders and Subfolders
  • Excel VBA Compare Arrays
  • Excel VBA Copy and Rename Files in Folder and Subfolders
  • Excel VBA - Copy Range into Array
  • SQL JOIN Multiple Tables with Concatenation
  • Excel VBA Find File in Folder and Subfolders
  • Excel VBA Copy and Rename Files
  • Excel VBA Find Differences Between Two Arrays

Categories

Archives

December 2019
M T W T F S S
« Mar    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Tags

Action (2) Array (2) Button (2) CONCAT (3) Copy Range (2) Custom Sort (1) Cyclic Dimension Group (2) Excel (9) Excel Function (2) Excel VBA (24) Excel VLOOKUP (2) Expression (2) Fantasy Football (2) For Each Loop (4) INFORMATION_SCHEMA (2) List Box (4) Load Order (1) Macro (4) Original (1) Power BI (2) Qlik (4) Qlikview (43) Qlikview Bundle Load (1) Qlikview Export to Excel (2) Qlikview Macro (5) Qlikview Select in Field (1) Qlikview Set Analysis (3) Qlikview Trellis Chart (1) ROW_NUMBER (2) Select in Field (1) Show Frequency (3) Sort Order (1) SQL (26) SQL CHARINDEX (2) SQL HAVING (2) SQL Server (5) SubField (2) Table Box (2) Text Object (1) Transact SQL (3) Trellis Chart (1) TSQL (25) Variable (5) VBA (12) VBScript (4)

Recent Posts

  • Power BI Fill Feature
  • Power BI Split Column By Delimiter
  • Excel VBA Copy and Rename Files in Folder and Subfolders
  • Excel VBA Count Character in Range
  • Qlikview Remove Unwanted Characters with PurgeChar Function

Pages

  • Excel / VBA
  • Power BI
  • Qlikview
  • SQL Server
  • BuffaloBI.com
  • Contact – BuffaloBI.com
© 2019 BuffaloBI.com • Powered by GeneratePress