How do I test whether a defined sheetname exists in a closed workbook?
I've been searching all over and can't find anything on this particula
challenge so I thought you guys might be able to help!
I'm wondering if anyone knows how to test whether (or not) a specifi
sheetname (e.g. "TestSheet") exists in a closed workbook?
(I'd really prefer not to have to open the workbook if at all possibl
as its one step in an intensive consolidation process from upto 10
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http:...***regaining control of Excel***
HELP! I've been having a recurring general problem while
working in Excel -- and it's driving me absolutely mad.
While going about various entry/editing tasks, it
inexplicably locks into 'right-button down' mode. That
is, the program acts as if I am holding down the right
mouse button and it selects all cells that I drag the
mouse over. But I'm NOT holding down the mouse button.
After this 'mode' engages I cannot do anything else in
Excel -- ESC does not work, hot keys don't work, clicking
on drop down menus does not work--NOTHING works. I have
t...excel macro on startup from DOS
After I start excel from a DOS .BAT script I want a macro to then be automatically executed. (To do this with MS Word you just put /Mmacroname after the path name of the executable, but this does not seem to work)
Excel doesn't support macro execution from the command line. As
an alternative, you can name the macro Auto_Open and this will
execute when the workbook is opened.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"roblit" <firstname.lastname@example.org> wrote in message
news:02AFEE4E-6686-4434-A41D-1...Excel to Publisher
My document has already been created in Excel. It's about 60 pages in five
tabs. Income Statement presented monthly over six years 2005 thru 2010;
Balance Sheet same time period; Cash Flow Statement same time period;
Construction Schedule, same time period. The Excel docs are nicely formatted
as you would see in a financial presentation, but my partner is adamant on
having it in presented in Publisher. I have been trying for three days to
convert/import/export the Excel sheets into Publisher to no avail. It looses
pages, it looses formatting. I have never in my professional li...Sorting in Excel #6
This is a multi-part message in MIME format.
Is it possible to have more than 4 sorts per worksheet in Excel? If so, =
what steps must be taken?
Thanks, in advance, for the help.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Hello There !
Looking for a bit of help.
I've created a shared worksheet, and I need to keep track
of ALL changes made to it.
As far as I can make out, Excel only tracks the most
EG: Changed cell AE8 from '13-Mar-04' to '08-Apr-04'
I need the following information (example):
Changed cell AE8 from '30-Dec-03' to '12-Feb-04' to
'13-Mar-04' to '08-Apr-04'
There must be some way of achieving this ?
In anticipation, I thank those who are better at Excel
than I am !!!
see your reply in Excel.worksheet.functions
P...Cannot open excel file on doubleclick ... HELP
I have this strange problem on 3 computers:
When I doubleclick on an excel file (in windows explorer, or a shortcut)
excel opens, but it only shows the top and bottom bar, the middle shows the
desktop of the PC.
- I get this when opening a file from the network, and from the C drive
- I get this with ALL excel files
- there is nothing in the startup folder, nor macro's, ....
So I think the problem is excel....
btw, al users are using excel 2002 (xp)
I already tried a repair/reinstall, didn't help
I tried the /regserver trick: didn't help
I tried to import .XLS from HKCR, ...Sheetname
could any one help me with the following:
I want to change a sheetname with a formula. Is it possible and if yes
Thanks a lot
Message posted from http://www.ExcelForum.com
Not with a formula - you'll need to use VBA. This should do it:
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"maxximuss" <email@example.com> wrote in message
news:maxximuss.yhppz@excelforu...Creating Macros in Excel
Operating System: Mac OS X 10.6 (Snow Leopard)
I am sharing this with all of you.Please add on to this discussion and let me know if i am correct or not. <br>
1. Click on Start>Programs>Microsoft office>Microsoft Excel to open the application. <br><br>2. Go to Tools>Macro>Record New Macro. <br><br>3. A pop up window named Record Macro will appear. Enter a name for the macro under Macro <br><br>4. Select the location of the macro under Store macro in saving this macro in the Personal Macro Workbook or...Very Slow to open 2003 Excel Files
It takes me well over 60 seconds to load a file that is 4,000KB. I have
tried everything I've seen in other posts to get this file to load faster but
none have worked.
I've repaired Excel, unchecked use DDE and put the %1 in, opened Excel and
selected the file through those methods. However, I still have to wait
anywhere from 45 seconds up to 4 hours was the longest loading time to date.
I have 14 Excel files that I work with on a daily basis and this is the only
one that gives me any trouble. There are many calculations and links to
various other sheets, but that ...Excel and ODBC
I have an ODBC application using MFC that reads data from an Excel
document. I open a database and use the CRecordset to read the table. I
have a column that has HEX data which will not read in correctly because
the data is detected as both numeric and text.
Is there a way to open a database to read all cells as text?
Or is there a way to force all cells of a column to read as text?
Thanks in advance
...Importing data into Excel
I have a text file called a.txt. I would like to import it into excel with
the headings domain, ip address, owner, administrative contact, technical
contact, name servers, additional data.
I'm not sure how I would go about doing that or if it is even possible. If
someone knows, would you be able to assist me please.
Below is what I would like the final excel spreadsheet to look like as well
as the contents of the file I would like to import (a.txt). I haven't
filled out the final excel spreadsheet, but all the columns would be filled
out with the data from a.txt.
...date string as sheetname
I have a macro that copies the last sheet to a new sheet at the end. I
would like to note the date that is in A2 prior to the copy, and add
one month to it.
This result will then become the name of the new sheet in the form
1-Oct-05 or something equivalent (ie: 1 Oct 05, 1Oct05,...)
How can I get the date from A2, and how can I modify it to the correct
Dim WB As Workbook
Dim SH As Worksheet
Dim sStr As String
Dim i As Long
Set WB = ActiveWorkbook '<<======== CHANGE
i = WB.S...How do I create project schedule using excel
I need to create a project schedule using excel. Please help.
lack of details :-)
Maybe give some more information what you're trying to do?
> I need to create a project schedule using excel. Please help.
...Printing an Excel doucument
In this example, I have a document of 100 pages, when I print the
document, the column headers only print on the first page and not the
subsequent pages. also I would like all the pages to be numbered. is therea
fix for this?
For your first question goto File>Page Setup>Sheet tab and
look for the option 'Rows to repeat at top'
For your second question goto View>Header and Footer and
look at the &[page] and &[pages] options in your footer.
...Error in formula displayed for linear and 2nd order curve fits in Excel 2003
I have created trendlines for some pretty simple data using both 2nd
order polynomial and linear fits. In both cases, the displayed
formulas have their 1st and 2nd order coefficients wrong by a factor
of 10!! (I have read lots of posts about increasing precision but this
is not what I am up against). Has anyone seen this?
What version of Excel? Could you include the data in a follow up post (not
as an attachment), along with the coefficients you've computed?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierT...Excel: extract and sum numerals from mixed text/numeral cell range
I have a large (30x20) grid of cells with data, and I want to extract
and then sum up certain numerals from this entire range. The catch is
that the data is mixed numerals and text, as you'll see below.
Here's an abbreviated 3x3 example, with a value in each of the nine
V7.1 T H
P1 A T
B V3 P4.5
If I just wanted to sum up the instances of "T" appearing, I could use
COUNTIF() for the entire range to come up with answer ("T" appears 2
times). Easy enough.
But, what I'm trying to accomplish is to sum up the numerals associated
w...my printer ejects a blank sheet prior to printing with EXCEL
My problem is similar to someone else's below(about Excel 2003 not being able
to update), the only difference is that I don't want Excel to update at all.
I don't even use it. But the yellow shield kept telling me that it had 1
update available, which was Excel 2003, so, out of annoyance, I installed it.
After failing to install several times, I decided to uninstall Excel from
Microsoft Office(Pro Edition 2003). Even after uninstalling Excel, I still
got the windows update alert. How do I stop it?
When windows update first appeared, I did a custom instal...excel axes
how do I create a secondary horizontal axis on an xy scatter plot?
forgot to mention 2008 excel using Leopard (10.5.2)
I have a simple program in excel for data entry. When I
protect the sheet, and use tab to move about within the
spreadsheet, sometimes the tab button will not move the
cursor to the next cell. It will pick a random cell to go
to next. Is there a way that I can designate what cell it
will go to next. Thanks for your help, jb
On a protected sheet, it is going to the next unprotected cell. So, if you
don't want it to go to a cell, protect it.
"JB" <firstname.lastname@example.org> wrote in message
> I have a simple program in exce...2003 Excel and 2007 Trial Version Excel
I downloaded the 2007 trial version of Microsoft Office. Now my trial is
over and I reloaded my 2003 version. But it will not let me remove the 2007
trial version. Also when I go into my 2003 Excel a Window Installer box
comes up that says Preparing to install and this stays on for about 5 minutes
before it goes away. I know that I should not have downloaded the trial
version but I did. Can someone please help me. I have Windows XP and it is
my office computer. Please help!
...MFC: Excel Automation Can't Quit from Excel. Please help...
Hi I use MFC Visual C++ 4.2.
I am automating Excel from my application.
My problem is I cannot quit the Excel after the automation process finished!
I checked it still exists on the Process lists and the most DANGEROUS is
everytime the automation function run, it create other Excel and so on. So it
must be out of memory soon.
I have used the app.Quit() method like all the people used but it DOES NOT
What should I do?
I happened to answer this on the office.developer.vba newsgroup. You most likely have
neglected to Release() the automation object.
On Wed, 3 Sep...Error Message When opening Excel
I am using Windows VISTA 64 bit O/S
with Office Professional 2003
All of a sudden I started to get the following error message:
'One of your object libraries (Stdole32.tlb) is missing or damaged. Please
run setup to install it'
I am at a loss as how to correct this. I checked online and found some
instructions that were for Windows 2000
Those did not work for VISTA at all.
Thank you in advance for your support and suggestions,
It is telling you to do a "setup to install" on the Office product, did you
try that? Did you try doing a repair on ...Excel charts should allow "switching" series on or off
A plot (chart) of time series data may be used for many purposes. From my
use two reasons I use such plots are:
Studying individual time series trends; and
Overall impression of all results.
But when studying multiple time series data a chart can become cluttered.
It would be useful if individual series could be seleceted as visible or
invisible so that they could be evaluated without losing the total plot.
At the moment the only way to "unclutter" the plot is to remove the
temporaily-unwanted series but it can be time consuming to reconstruct the