Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell value as a filename
Hi all, An earlier thread(help required with using cells to generate a filename) nearly helped but not quite. I want to use a cell value as a filename with the workbook to be saved in a specific folder but I want the Dialog box to open first with the filename in it so the user has to actually click on Save As. So far, so bad: what I have got doesn’t work at all and I’d be very grateful for any help at all Many thanks in advance, DS -- dunescratcher ------------------------------------------------------------------------ dunescratcher's Profile: http://www.excelforum.com/member.php...o&userid=33114 View this thread: http://www.excelforum.com/showthread...hreadid=529322 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell value as a filename
Nick! Thanks for the quick reply. I have already got: Sub SaveAs1() ' ' SaveAs1 Macro ' Macro recorded 03/04/2006 by GB ' ' Keyboard Shortcut: Ctrl+e ' ActiveWorkbook.SaveAs "C:\Windows\All users\desktop\" & Range("E2") & ".xls" End Sub ...which directly saves the workbook under the name in "E2". I am trying to still generate the same file name but want to force a Save As with the name coming up in dialog box and the destination file also. User to click on Save As to complete. Thanks for your input so far, DS -- dunescratcher ------------------------------------------------------------------------ dunescratcher's Profile: http://www.excelforum.com/member.php...o&userid=33114 View this thread: http://www.excelforum.com/showthread...hreadid=529322 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell value as a filename
Nick! Thanks for the quick reply. I have already got: Sub SaveAs1() ' ' SaveAs1 Macro ' Macro recorded 03/04/2006 by GB ' ' Keyboard Shortcut: Ctrl+e ' ActiveWorkbook.SaveAs "C:\Windows\All users\desktop\" & Range("E2") & ".xls" End Sub ...which directly saves the workbook under the name in "E2". I am trying to still generate the same file name but want to force a Save As with the name coming up in dialog box and the destination file also. User to click on Save As to complete. Thanks for your input so far, DS -- dunescratcher ------------------------------------------------------------------------ dunescratcher's Profile: http://www.excelforum.com/member.php...o&userid=33114 View this thread: http://www.excelforum.com/showthread...hreadid=529322 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell value as a filename
Hi, Thanks again. It wasn't exactly what I was after bit it set me on the right track: What I wanted to do was this: Application.Dialogs(xlDialogSaveAs).Show "C:\Windows\All users\bureau\" & Range("E2") & ".xls" which works fine. Am already working on another stupîd question.... Thanks again, DS -- dunescratcher ------------------------------------------------------------------------ dunescratcher's Profile: http://www.excelforum.com/member.php...o&userid=33114 View this thread: http://www.excelforum.com/showthread...hreadid=529322 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use a cell to enter a filename in a formula | Excel Worksheet Functions | |||
substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
cell filename | Excel Discussion (Misc queries) | |||
How do I use a cell value as the filename in an external link? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |