Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

auto save file basedon dropdown selectiom

0

how do i save a file to a certian folder based on a selection from a dropdown box.

dropdown - 1st, 2nd, 3rd

folders - 1st shift, 2nd shift, 3rd shift

I already have a macro that will save the file to a folder but I want to be able to save to one of three folders based on the dropdown choice.  any ideas?

Answer
Discuss

Answers

0

You need just to get the value from the cell with the drop down box, bring it into the macro, check which value it is, and change the folder location based on that.

These two tutorials from us will show you how to do all of that:

Get Data from the Worksheet into a Macro in Excel

VBA IF Statement in Excel Macros

Update

Here is a sample:

Sub filesave()

'value from dropdown
dropValue = Range("A1").Value

ActiveWorkbook.SaveAs ("I:\BLM_Public\BloomsburgReports\DailySuperVisorReport2016\" & dropValue & Format(Now(), "DD-MMM-YYYY hh mm AMPM") & ".xlsm")

End Sub

Change A1 to the cell that contains the drop down.

Put dropValue anywhere in the saving file path. I just put it before the date part.

Discuss

Discussion

Below is what I have, however I want to save to one of three subfolders under "DailySuperVisorReport2016" 1st, 2nd, 3rd based on the selection from a dropdown box.  What do I need to add to my Macro?


Sub filesave() 'Update 20141111 ActiveWorkbook.SaveAs ("I:\BLM_Public\BloomsburgReports\DailySuperVisorReport2016\" & Format(Now(), "DD-MMM-YYYY hh mm AMPM") & ".xlsm") End Sub

Noyl Nov 30, '16 at 12:11 am
Answer updated. See if it helps.
don (rep: 1989) Dec 2, '16 at 4:32 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login