LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default How to change a sheet name without opening the workbook

Hello,
I am trying to figure out how, or if it is possible, to change the
name of the first sheet of each workbook in a folder. I have figured
out a way to do this by having a macro open each file, but this is
time consuming, AND, there is a macro in each workbook which tries to
run each time the workbook is opened. So, I would like to do this
without opening the files. Any ideas?

thanks,
Andy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a workbook to a certain sheet [email protected] Excel Programming 2 September 10th 07 08:06 PM
Opening Workbook to a specific sheet Carlee Excel Programming 2 April 11th 07 08:16 PM
Opening a workbook to a chosen sheet? renderingsanity Excel Discussion (Misc queries) 1 March 29th 06 02:17 PM
Change Date without Opening the Workbook ad2maso Excel Worksheet Functions 0 February 3rd 06 11:34 AM
Hyperlinks and opening any sheet a workbook Angelo Battistoni Excel Programming 2 October 5th 05 02:17 PM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"