Cell Text in File Name

  • Thread starter Thread starter BT Connect
  • Start date Start date
B

BT Connect

Does anyone know of a way to generate a Save As <file name> from the text
in a cell?

This would be really useful for all sorts of things.

Jeff
 
Activeworkbook.SaveAs Activesheet.Range("A1").Value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Yes Jeff,

use this all the time, I call them file stamps.

Sub SaveAsCellText()
ActiveWorkbook.SaveAs Filename:="C:\" & Range("A1").Value
End Sub

Hope this helps

somethinglikeant
http://www.excel-ant.co.uk
 
You must log in or register to reply here.

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

Select cells with text 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Save As File Name from Cell? 2
Creating a File Name from a cell 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Last Modified By in a cell by user 3
why won't text-to-columns work here? 6
Excel Typed text appears in wrong cell 0

Back
Top