How can I make Excel Files save as the text appers in a cell, can.

O

Otto Moehrbach

Do you mean you want to save a file and have the file named the contents of
some cell?
I so, you need a macro. The save statement is like this for cell A1.
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\" & Range ("A1").Value &
".xls"
HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Word macro that can call cells out of Excel for a find and replace 0
Pasting a cell into bookmarked table from excel vba 1
File save as cell value 6
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Insert a hyperlink as the text in the cell? 2
save as cell A1 to to a specific drive 3
I need to cut characters off of a list of text cells... 2

Top