View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_3_] jeffhughes@ntlworld.com[_3_] is offline
external usenet poster
 
Posts: 10
Default help with making a directory and saving the spreadsheet

assume the folowing spreadsheet

1
A Bristol
B r-11111
C 1st april 2006

I want to be able to click on a button and it to do the following:

1. check to see if a path exists called c:\ and the contents of cell
A1 ie c:\bristol, if not then create one.

2. save the spreadsheet with the name cell a1 + cell a2 + the month and
year of cell a3.xls ie Bristol r-11111 april 2006.xls and put it into
the above directory.

how can i do this?