Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Puzzle:save excel file with filename from cell ref
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

chumbawumba
Junior Member

United Kingdom
304 Posts

Posted - 30 January 2005 :  07:53:29  Show Profile
Hi All,

I need to be able to save an excel spreadsheet with a name that exists in a cell - for example A1.

My excel VBA knowledge isnt too hot, but I can assign a macro to a button that raises a file-save-as dialogue box, but it doesnt save the file.

Anyone know how to do this?

TIA

My test code:
fileSaveName = Application.GetSaveAsFilename(Workbooks("Book1").Sheets("Sheet1").Range("A1"))

chumbawumba
Junior Member

United Kingdom
304 Posts

Posted - 04 February 2005 :  09:05:01  Show Profile
yeah it confounded me too.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07