Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Using VB to rename Excel sheet tabs
Name: Shawn Date: March 28, 2003 at 12:08:59 Pacific OS: 2000 CPU/Ram: pent 4
Comment:
In Excel i want to rename the worksheet tab using a VB macro. I want it to copy a cell on the worksheet and use it as the worksheet name. It needs to be variable because i want to copy the worksheet, increment the cell value by one, and have the new worksheet named the new cell value. Here is the code:
Summary: I am looking for a VB Script that would rename several Acrobat files based on a reference list (txt, csv, ect). The acrobat files are created with time/date stamp. I would like a vbs to rename those ...
Summary: i am using visual basic 6 (not visual basic script or VBA) and i wrote a program that writes texts to an excel sheet.I need to make these texts hyperlinks to a path that i will provide (variable in th...
Summary: Can anyone tell me the specific code for setting a hyperlink to a specific sheet in a excel worksheet. I am trying to set it up so that different links take the user to a different sheet in the same s...