save as

  • Thread starter Thread starter Glenn
  • Start date Start date
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?
 
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
 
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.
 
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.
 
Back
Top