•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Naming a File Using a Certain Cell on Every Sheet.
Hey everyone!
I'm a beginner vba user. I'm trying to name my files and using d21 from every tab in the workbook. I have figured out how to name it if i only have one sheet, but I would like to be able to automatically populate a name with d21 from each sheet. Any help would be appreciated.
ActiveWorkbook.SaveAs Filename:="RA REQUEST " & ActiveSheet.Range("D22") & " VEN " & ActiveSheet.Range("D21") & " BL-" & Range("D2").Value & " " & Left(Range("D5").Value, 8) & ".xlsx", FileFormat:=xlOpenXMLWorkbook [link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#no-code spreadsheet solutions
#Excel alternatives
#VBA
#ActiveWorkbook
#SaveAs
#Filename
#Range
#d21
#d22
#sheet
#workbook
#automatic
#populate
#Excel
#filename creation
#BL-