Excel - File Save Macro - A Cell's Contents becomes the Filename

Описание к видео Excel - File Save Macro - A Cell's Contents becomes the Filename

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 - wha...  
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

LET'S CONNECT!
Facebook ►   / projectwoman  
Twitter ►   / helenbradley  
LinkedIn ►   / helenbradley  

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 plac...  
Microsoft Word - Change Default Image Wrap ►    • Word - Change Image Default - Make Te...  
Microsoft Excel - Custom Lists and Sort lists ►    • Excel - Custom Lists and Sort lists -...  
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 - ...  
A Microsoft Word Macro to Resize All Images in a document    • A Word Macro to Resize All Images in ...  
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 PowerPo...  
Microsoft Excel - Hide Unused Rows and Columns - Show only used cells ►    • Excel - Hide Unused Rows and Columns ...  
Microsoft Excel - Click to Enter Data - Create Custom Spin Buttons ►    • Excel - Click to Enter Data - Create ...  
Excel - Save to Computer not OneDrive - Change the Excel default Save location ►    • Excel - Save to Computer not OneDrive...  


#helenbradley #microsoftexcel #microsoftoffice #excelvba #excelvbatutorial #excelfilesave
#excelmacro

Комментарии

Информация по комментариям в разработке