Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 5th 04, 10:02 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2004
Posts: 1
Default Set Saveas Filename from Cell Contents Using VBA

Can anyone help me with this one.

I am creating a workbook that creates new workbooks with specific dat
from the original workbook.

I have sorted a maco to open the SaveAs dialog box

I need a way of setting the Initialfilename property to the content o
a cell found within that workbook.

Can this be done.

I truely hope so

--
Message posted from http://www.ExcelForum.com


  #2   Report Post  
Old September 5th 04, 10:57 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default Set Saveas Filename from Cell Contents Using VBA

fname = Application.GetSaveAsFilename(InitialFilename:= _
Worksheets("Sheet1").Range("B9").Value, _
FileFilter:="Excel Files (*.xls), *.xls")

Activeworkbook.SaveAs Filename:=fName



--
Regards,
Tom Ogilvy


"Celtic_Avenger " wrote in
message ...
Can anyone help me with this one.

I am creating a workbook that creates new workbooks with specific data
from the original workbook.

I have sorted a maco to open the SaveAs dialog box

I need a way of setting the Initialfilename property to the content of
a cell found within that workbook.

Can this be done.

I truely hope so.


---
Message posted from http://www.ExcelForum.com/





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Cell Contents Filename deeds Excel Worksheet Functions 1 March 12th 07 08:21 PM
Cell Contents to identify source Filename ThalesNate Excel Discussion (Misc queries) 1 June 7th 06 07:28 PM
cell contents as filename Jeff R Excel Programming 1 August 26th 04 03:02 PM
Macro to open SaveAs... and change filename to cell value Andy Excel Programming 5 July 19th 04 12:23 PM
SaveAs Filename Help Ed[_14_] Excel Programming 2 November 20th 03 08:43 PM


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017