Thread: Save Excel file with specific cell value by using VBA code
View Single Post
 
Old 11-02-2016, 07:11 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
How you would execute the code depends on what you want to use it with. If it's intended to be run as a stand-alone macro, simply delete 'Private '. You will then be able to access it via Alt-F8, for example.

To save as a PDF, you'd probably want to use the ExportAsFixedFormat method, so you can specify the output range, etc. See Excel VBA help file for details. You could add that method to your existing sub.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote