View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamesmsv Jamesmsv is offline
external usenet poster
 
Posts: 1
Default rename a workbook using a macro

I am trying to automate workbook saving, and I want each workbook to take
it's name from the word typed into the merged cell range A1:K1. I cannot get
this to work through simple macro-recording action, and VB editing has got me
nowhere! Any ideas?