Save as method in Excel

Discussion in 'Software' started by JackLite, Oct 27, 2005.

  1. JackLite

    JackLite Private E-2

    Help,

    I need a vba code

    I want it so you can press a button and the workbook will save in a specific location, but i want it so it gets the file name from cell a2 + cell b2 from sheet 1.

    so if I put my name in cell a2 as 'Jack' and the date as '7 oct' in cell b2 the file will save as name jack 7 oct.xls

    Can anyone help?

    Thanks
     
  2. Wookie

    Wookie Sergeant Major


MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds