Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-23-2014, 06:50 PM
BobBridges's Avatar
BobBridges BobBridges is offline Can a macro rename Excel files based on a cellname? Windows 7 64bit Can a macro rename Excel files based on a cellname? Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Sure. Do you know how the SaveAs statement works in VBA? You can provide a document name in quotes, but you can also fetch the report title from B2, or wherever, and use that instead.

If you need more explanation then maybe we should back up; I don't know yet how much you know about writing macros...?
Reply With Quote
 

Tags
filename, rename, tabname



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to rename multiple Word file with same suffix ozil61 Word VBA 2 05-06-2014 07:36 AM
Convert old PowerPC file to Intel-based files in Word? walmar Word 0 06-12-2013 07:07 AM
Rename Files gsrikanth Excel Programming 3 05-14-2012 03:03 AM
Macro based on cell value ubns Excel Programming 1 05-07-2012 04:03 AM
Merging word files from excel macro hklein Excel Programming 0 08-05-2011 02:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 AM.


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