save as

G

Glenn

HI Folks

In most of my other office components when I create a document it takes the
first line and uses that as a file name when I select Save as from the file
menu. All except excel. is there anyway I can turn this feature on?
 
R

Robert Rosenberg

Excel does not have this feature. You'd need a macro to emulate this
behavior. Below is a macro that takes whatever is in cell A1 of the active
worksheet and uses it as part of the default name...

Sub SaveAsUsingA1Text()
Application.Dialogs(xlDialogSaveAs).Show ActiveSheet.Range("A1").Text
End Sub

If you need help implementing this macro, reply to this post (not my email).
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
G

Glenn

Excel does not have this feature. You'd need a macro to emulate this
behavior. Below is a macro that takes whatever is in cell A1 of the
active worksheet and uses it as part of the default name...

Sub SaveAsUsingA1Text()
Application.Dialogs(xlDialogSaveAs).Show
ActiveSheet.Range("A1").Text
End Sub

If you need help implementing this macro, reply to this post (not my
email). _________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
Click to expand...
Thanks

I'm going to give this a try right now.
 
G

Glenn

Excel does not have this feature. You'd need a macro to emulate this
behavior. Below is a macro that takes whatever is in cell A1 of the
active worksheet and uses it as part of the default name...

Sub SaveAsUsingA1Text()
Application.Dialogs(xlDialogSaveAs).Show
ActiveSheet.Range("A1").Text
End Sub

If you need help implementing this macro, reply to this post (not my
email). _________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
Click to expand...


Thank you Robert, I will accept your offer of help implementing this
macro, I thought I could just grop this text into a window somewhere but
I suppose it's not that easy.
 
Top