
VBA code to generate a list of files and sizes in subfolders
Apr 25, 2017 · Hello, I have found code generated in this forum to generate a list of files in a specific folder and all its subfolders that have been modified in the past 100 days.
Rename PDF files with VBA | MrExcel Message Board
Nov 23, 2022 · Hello, I have a folder containing email attachments, but they are all labelled as REF XXXXXXXX.PDF I have used some software to generate an excel file with email data, …
RND not truly random? | MrExcel Message Board
Apr 16, 2010 · If I fiddle with the code a bit it will draw something different, but again will repeat the same two patterns. This leads me to think the RND function is not truly random.
Changing the font of a commandbutton | MrExcel Message Board
Dec 5, 2003 · I have a number of command buttons on a userform. I am attempting to change all the fonts of the buttons with a combo box, with the following fonts: - Symbol - Webdings - …
Check Digit Generation Formula | MrExcel Message Board
Jan 8, 2015 · Working on generating a few thousand SSCC codes. The code is 17 digits plus a check digit. For instance 00813590020000000 should return 008135900200000002. The …
How do I generate a unique "Quote" number to my spreadsheet?
Oct 24, 2012 · Hello and thanks in advance! I need to create a quote template that is stored in one place on my server like a repository that can be accessed by any three of us at any given …
FUNCTION CODE - 128-b FONT HELP | MrExcel Message Board
Jul 16, 2009 · I am after barcode font code 128-B. I downloaded the file of web and it put a function file on my laptop. How do i locate this function file. Please see the image below which …
VBA Macro Save file as PDF and Email Through outlook
Mar 10, 2020 · The below code should do what you want. Please note when writing this code I have made a few assumptions: The worksheet containing the file name and email address in …
Using the NormSDist Function to generate an S Curve - MrExcel
Feb 8, 2006 · I been trying to find a simple way to generate an S curve and came across the NormSDist function but I find it daunting. I have searched on the web in other...
VBA to create printable Barcode sticker labels from Excel
May 19, 2022 · Cell D1: Insert the barcode text, set the font to Code 39 or Code 128 Cell D2: Insert the same barcode text, set font at any desired human-readable font etc. If you are …