Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2011, 12:02 AM
devcon devcon is offline VBA Save as header page name Windows 7 VBA Save as header page name Office 2010 (Version 14.0)
Novice
VBA Save as header page name
 
Join Date: Jul 2010
Posts: 3
devcon is on a distinguished road
Default VBA Save as header page name


I need your help to save the spreadsheet with the name of center header name.

Example

Code:
ActiveWorkbook.SaveAs Filename:="C:\Users\Exon\Documents\AAA PDF Files" _
& "\" & ActiveCell.Value & ".xls", _
FileFormat:=xlWorkbookNormal
ActiveWorkbook.Close
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to save the current page in a new file with all the page settings (header, footer Jamal NUMAN Word 6 03-15-2012 03:27 PM
VBA Save as header page name Page does not show header & footer Ron O'Brien Word 5 01-04-2012 07:34 AM
VBA Save as header page name Header after page break mashtonsmith Word 1 03-11-2011 10:21 AM
VBA Save as header page name Header disappear on 1st page; fix please? deonholt Word 2 10-25-2010 12:47 AM
Excel 2003 - Different Header for each page franklyorange Excel 0 08-26-2008 02:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft