Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dunescratcher
 
Posts: n/a
Default 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
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
how to use a cell to enter a filename in a formula John Excel Worksheet Functions 2 March 11th 06 09:26 PM
substitute the filename in a cell reference with a string in another cell. flummi Excel Discussion (Misc queries) 11 February 22nd 06 01:14 PM
cell filename Carina Excel Discussion (Misc queries) 1 November 3rd 05 01:37 PM
How do I use a cell value as the filename in an external link? wattkisson Excel Worksheet Functions 1 July 8th 05 11:51 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 02:23 AM.

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

About Us

"It's about Microsoft Excel"