View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TroyB[_2_] TroyB[_2_] is offline
external usenet poster
 
Posts: 11
Default Save excel file with filename = cell text

Hi,

I'd like to add some code to the end of my macro that saves the current
excel file with a filename derived from the text of two cells in the
worksheet. ie: i4 = 5486, i3 = TB -- The filename would be 5486TB.xls
What code do i need?

Thank you for your help
Regards
Troy