Save As B2

  • Thread starter Thread starter ForSale
  • Start date Start date
F

ForSale

I want to - in a macro - save the open document as whatever is i
range("b2"). what is the code for that?
Thanks,


i will also have one more question but will put in a new thread
 
Hi
try something like

dim fname
with activeworkbook
fname=.worksheets("sheet1").range("B2").value
.saveas fname
end with

no error checking included!
 
Wonderful,
Thanks Frank.
Also, how can i modify this to save in a particular folder. fo
instance:
save as c:\Daily Group Summary Reports\fname
or something...
thanks
 
Hi
try:
dim fname
Dim fpath
fpath="c:\Daily Group Summary Reports\"
with activeworkbook
fname=.worksheets("sheet1").range("B2").value
.saveas fpath & fname
end with
 
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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Save As and new workbook new name used in existing code 8
Combine 2 columns in a dynamic range into one 7
Array VLOOKUP lookup_Value does not increment 3
After sort and concant, one too many semi-colon 15
Scatter Plot Question - adding straight lines 0
Run-time error 1004 4
How to reference a cell from anther workbook without opening it 0

Back
Top