View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RMS RMS is offline
external usenet poster
 
Posts: 4
Default Saving an Excel Wookbook to a Variable?

I have an Excel worksheet that I use often. I save it to a file using the
clients last and first name as the file name. Since the client's name is in
a known Cell in the worksheet, it would be nice to assign the cell a
variable name and save the workbook to that name. This would save time and
help avoid typo's.

Oddly , the highly authoritative "VBA for Dummies" is strangely silent on
this issue.

Thanks, RMS