Excel - File Save Macro - A Cell's Contents becomes the Filename - Excel VBA Macro: Save File As Based on a Cell Value
Create a Macro to save a file using the contents of a cell as the filename. This macro also has an inbuilt file path that can be used as the default path for the files. It is also fully customizable so you can change the filename and the path as well. I'll give you the code to use and explain how the macro works, step by step. Basically this Excel VBA macro will let you save a workbook in specific folder based on a cell value.
Referred to in the video:
Download Macro Code ► https://www.dropbox.com/s/0djwyasyv8e...
Excel - Personal Macro Workbook - what it is and how to create and use it (includes how to display Developer tab) ► • Excel - Personal Macro Workbook - what it ...
Learn More About the GetSaveAsFilename Method ► https://learn.microsoft.com/en-us/off...
VIEW MORE VIDEOS JUST LIKE THIS ON MY YOUTUBE CHANNEL
Microsoft Office ► / @mastermicrosoftoffice
TIP ME TO SAY THANK YOU? ► paypal.me/projectwoman
VISIT PROJECTWOMAN.COM FOR MORE ON MICROSOFT OFFICE APPLICATIONS:
Website ► http://www.projectwoman.com
Blog ► http://www.projectwoman.com/blogger
IF YOU LIKED THIS VIDEO YOU MAY LIKE THESE SIMILAR VIDEOS:
Microsoft Excel Mac - Remove Custom Templates ► • Excel Mac - Remove Templates
Microsoft Word - Images in Tables - How to place & position pictures in Word Tables ► • Word - Images in Tables - How to place & p...
Microsoft Word - Change Default Image Wrap ► • Word - Change Image Default - Make Text Wr...
Microsoft Excel - Custom Lists and Sort lists ► • Excel - Custom Lists and Sort lists - Make...
Microsoft Excel - Count days between two dates ► • Excel - Count days between two dates
Microsoft Word - Table Cell Widths - Adjust one or more with ease ► • Microsoft Word - Table Cell Widths - Adjus...
A Microsoft Word Macro to Resize All Images in a document • A Word Macro to Resize All Images in a doc...
Microsoft Excel - Format a List Instantly - Quick & Easy Table Formatting Trick for Lists ► • Insanely Simple Excel Formatting Trick
Office Tab for Word Excel and PowerPoint - A quick look at this handy application ► • Office Tab for Word Excel and PowerPoint -...
Microsoft Excel - Hide Unused Rows and Columns - Show only used cells ► • Excel - Hide Unused Rows and Columns - Sho...
Microsoft Excel - Click to Enter Data - Create Custom Spin Buttons ► • Excel - Click to Enter Data - Create Custo...
Excel - Save to Computer not OneDrive - Change the Excel default Save location ► • Excel - Save to Computer not OneDrive - Ch...