Excel VBA Open File Based on Cell Values
The Excel Cave
View ChannelAbout
Excel Functions, VBA, & Google Sheets Videos are included in this channel.
Latest Posts
Video Description
This video illustrates how to create code in Excel VBA to open a file in a folder based on Cell Values for both the File Name and Folder where file is located. This allows users to change the cell values to automatically open different files in different locations. In this example we have Month/Year Folders that are located within a Year Folder. The objective is to write code to get to any of the files within specific month/year subfolders based changing cell values. #ExcelVBAOpenFileBasedOnCellValue #ExcelVBAOpenFile #LearnExcelVBA Learn More about Excel VBA & Macros with this Book on Amazon: https://amzn.to/3xnqT6R Get a Microsoft Office 365 Personal Subscription with this Amazon link: https://amzn.to/3aV9GtL DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
Boost Excel Skills Today
AI-recommended products based on this video
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X
Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black
Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black
Dell UltraSharp 24 Monitor - U2424H
Dell UltraSharp U2723QE 27" 4K UHD WLED LCD Monitor - 16:9 - Black, Silver EPEAT
Dell UltraSharp U2725QE 27' 4K Thunderbolt-Hub-Monitor mit Bildwiederholfrequenz Von 120Hz
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X
Selore USB C Docking Station for Laptop Dual HDMI Monitor, 8 in 1 Triple 4K Docking Station 4 Monitors Adapter,VGA,100W PD,2USB A 2.0,USB C 2.0 USB C Hub for MacBook HP Dell Lenovo
Laptop Docking Station, Docking Station 3 Monitors with 2*DP+HDMI, 130W PD Charger, 4*USB 3.0, Audio, Gigabit Ethernet, TF/SD for Lenovo HP Dell, Windows,Mac
Logitech K250 Bluetooth Keyboard with Numpad, Easy Connectivity, Compact Wireless Keyboard Made with Recycled Plastic, Spill-Resistant, Comfortable Keys - Windows/MacOS - Graphite
Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black