View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] jeffhughes@ntlworld.com[_2_] is offline
external usenet poster
 
Posts: 1
Default help required with using cells to generate a filename

is there a way of clicking on a button that asks you where you want
the file saving, but enters in a filename derived from the contents
of two cells and todays date?

for example if cell A1 contained 'hello' and cell B12 contained
'world' the prompted filename would be 'hello - world - 200306.xls'.

Any help would be appreciated.

TIA
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------