count text through worksheets generates error
In a workbook with a lot of worksheets i want to count the number of
times a specific text value occurs in a cell.
All sheets have the same layout.
So, for instance, when i want to count the number of times the value
"yes" occurs in cell B2 through sheets 1 to 5 and i use the function
=countif(sheet1:sheet5!b2,"yes") excel generates an error message (#value!).
I don't understand why, because if i would use the function in 1 sheet
only I get the required result.
I suspect that some functions cannot work on grouped sheets.
Is there a list somewhere that e...DPM connection error
I just applied SP1 to my DPM 2007 server. Everything seemed good to go until
I started to update the client agents. After about 10 minutes the DPM server
became very unresponsive. I rebooted it and now when I try to connect to the
Admin console I get an error 'Unable to cnnect to dpm.domain.com (ID: 948)
Verify that the DPM service is running on this computer". I have gone through
all of the services and set them to start automatically and rebooted once
more and I still receive the error.
Any help would be awesome.
Check the status of the DPM servic...Can someone help with this error
I am randomly getting an access error in my application and I am trying to
find it. The error seems to occur when allocating a buffer in the CString
code. Does anyone know if the dump below is pointing to anything specific?
It seems like the error is occuring when 'text' is be allocated but I don't
// this is the function call in the ArchExists(..) module where the CString
is allocated (parm1).
CComSetup::ExtractParams( text, &type1, &desc1, &name1, &id1 );
// This is the declaration of the function
void CComSetup::ExtractParams( CString src, CStrin...Outlook 2000 memory error
When I deleted an item in Calendar, I got error message
that "There is not enough memory available to perform the
operation." I am using Outlook 2000.
Thanks in advance.
...need help... Getting a error when I add a xml schema include location xsd file
I am trying to add the following line to my xml schema xsd file
Here is my code
XmlSchemaInclude include = new XmlSchemaInclude();
include.SchemaLocation = "../../../Common/datatypes.xsd";
when I print out the schema, it crashes
StreamWriter sw = new StreamWriter(@strFormName+".xsd", false,
Any help is greatly appreciated,
...Hyperlink Macro / Hide Tabs
I have an Excel 2007 worksheet with 10 tabs. The first tab has a
contents section where each of the subsequent tabs is hyperlinked. By
clicking on the hyperlink I go to cell A1 of whichever tab I select.
In addition each tab has a hyperlink taking me to the contents tab. I
would like a macro where, when I click on a hyperlink, all tabs other
than the cover tab and the selected tab are hidden. In addition when I
click on the contents tab in a selected tab every tab is hidden bar
the contents tab.
Can anybody help?
...Global error handler
Is there, in ACCCESS 2007, and/or VB a global error handler? I've checked
the docs but not sure on the feasibility of this. I've seen On Error and
OnError, and a discussion excepotion handling, but again, I'm not sure on
the implementation of error and exception handling.
The personal opinion of
Gary G. Little
You must add the error handling to each routine. There's not a way to just
make it automatically go to an exception handler without doing so.
In each routine, you can call a generic error handler. Here's an example of
Error Handling in VBA
...error with the form when using asp.
I get this error, when i submit the form. The error comes up and some
technical advisor from my host company told me to change it to ASP Email but
i don't understand what he was talking about. Can someone provide
Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/WebAppSub.asp, line 9
The call to Server.CreateObject failed while checking permissions. Access is
denied to this object.
...GP Client install errors
I installed GP 8.0 from a installation template on 1 XP machine with no
problems. I have the ODBC properly setup, and bcp.exe properly
installed to satisfy GP Utilities. I am able to log in with different
users, no problem.
I did the same thing on two other XP machines and both machines give
this Dexterity Runtime error on start-up.
Unable to open dictionary
I get this error for the following .dic's:
EXP1493R....return a zero for error
I'm having a problem with a spreadsheet I'm developing which records average
marks of groups of students over several weeks. I want to display a
"Running Average" of those averages as I enter the data, however, because I
do this week by week there are inevitably weeks which have not had any data
entered and her I see the error #DIV/0! for the formula
=AVERAGE(IF(R5:R20<>0, R5:R20,"")). I do understand why I'm getting this
(because I'm dividing by zero) but would like to return a zero so that the
average of the averages will return a number rather tha...Money Investment Toolbar Error
All of a sudden, whenever I try to access my portfolios in the Deluxe
version, I get this error: AppName: iexplore.exe, AppVer: 6.0.52800.1106,
ModName: myisam05.dll, ModVer: 4.0.3107.50512, Offset: 00006e27.
I can remove the Toolbar and use the basic portfolio version but continue to
get the above error and an IE restart whenever I try to upgrade to Deluxe.
In microsoft.public.money, Dencoden wrote:
>All of a sudden, whenever I try to access my portfolios in the Deluxe
>version, I get this error: AppName: iexplore.exe, AppVer: 6.0.52800.1106,
>ModName...Macro Run on WorkBook Open?
Have a macro that I want to run when the file is first opened.
Is this possible? If so, How?
Thanks in advance
/ Sean the Mc /
"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)
You answered your own question. Right click on the excel icon just to the
left of FILE> the workbook_open event is there.
"What-a-Tool" <Die!FrigginSpammersDieDie!@IHateSpam.Net> wrote in message
> Have a macro that I want to run w...creating a macro that will paste a value and then move
I am trying to recreate a macro that opens a workbook, goes to Sheet
1, pastes clipboard info into A1, then moves to B1, then saves and
closes the file.
I know how to make the file automatic and how to get it to open and
close (Auto_Open), but I cannot remember how to get the macro to move
from cell to cell (left-to right). What happens is that when I do a
recorded macro and then try to rerun it; it will paste into A1 and
then will tab over to B1. Then upon the next time that I call up the
spreadsheet, it will even paste to B1, but will not move further from
I then...Only run if check box is checked
I have some code that I only want to be run if a check box is checked. So I
inserted an ActiveX check box which I have named cbRecord.
I then put the following IF around the code which is initiated by clicking a
spinner form control:
If cbRecord.Value Then
However, when the code is run I get the following error: Run time error
'424': Object required. When I go to debug, the code doesn't even know that
my check box exists.
If Sheets("Sheet1").CheckBoxes("Check Box 1").Value = xlOn Then
'...Where are macros stored?
Specifically, where are Macros stored? Is it in my C
drive?I've created some Macros, chosen them to be stored
in Personal macro workbook instead of the other choices,
and they are now arbitrarily stored in Personal.xls.
Macros are stored in workbooks.
The next question is "where are workbooks stored?"
If you record a macro, you're given the option of what workbook to record into.
If you choose personal.xls, they'll go there.
If you choose, thisworkbook or new workbook, they'll go there.
(I always record a macro into a test workbook. Then I can tweak ...Authentication Error 04-28-06
One of our users is suddenly getting Aucthentication Error.
"Microsfot CRM could not log you on to the system. Make sure your user
record is eanbled and that you have been assigned at least one security
I have checked the user in CRM, enabled and also has a role assigned.
Checked the SQL databases which has relevant records. Checked the Deployment
manager. So everything is normal as expected but for some reason the message
started today. The other users are fine. This use has been working in CRM up
When I switch on my computer, the following message widnow showup. I can not
do anything, except to the the task manager. I try to restart the computer
and the problem is gone.
Explorer.EXE - Application Error
The application failed to initialize properly (0xc0000142). Click on ok to
terminate the application.
The problem occur very frequently and I can only solve it by restart the
computer. Sometimes I need to restart several time.
Is anything wrong in my compu...Compile error in Excel 2002
I have Excel 2002 installed on a Windows 7 machine. While this version of
Excel was installed on Win XP, it worked fine. However, since I installed it
on Win 7, every time I open or close an Excel file, I'm getting an MS Visual
Basic compile error in hidden module. On opening a file, it is AutoExecNew
module, on exit - DistMon.
I followed advice in the MS KB Article ID: 307410 and removed both
pdfmaker.dot and pdfmaker.xla. But it did not help. The error message pops
Is there any other solution to this problem?
Fort Myers, Florida
Most ...Can I force confirmation prompt on close? Or tell Outlook to run in background?
I am constantly accidentally pressing the close
button instead of "minimize" when I am at work.
I press close explicitly but I would like behavior like
antivirus or IM clients.
I want Outlook to continue to run in the background, so
it can continue to check for email, alarms, etc.
Is there either a way to force confirmation of closure,
or to have an outlook background task set up
which doesn't close so easily?
Rufus V. Smith <email@example.com> wrote:
> I am constantly accidentally pressing the close
> button instead of "minimize" when I am at ...OWA 2007 HTTP 403 ERROR
I’ve been able to successfully get up and running in a virtual environment
(yes, yes I know it isn’t supported…but it’s a pseudo lab environment)
exchange 2007. Up until two days ago the setup has been running very well
allowing me to access my mail via OWA, as well as with the “Outlook Anywhere”
The problem was that I couldn’t access my mail using the “Anywhere”
components. In investigating this I found that the following events were
logged. W3SVC Event ID 1039 and W3SVC Event ID 1002 , it appears as though I
resolved both issues by running the command outlin...Catastrophic Error in XL 2003
I've written some pretty standard, but complicated, VBA code under
XL2000. A user with XL2003 gets a "catastrophic error" when opening
the file (macros enabled), which sends him to the VBA debugger - but in
a loop. Need Task Mgr to quit the application.
This is NOT a shared workbook - I read those posts but haven't found a
clue as to what could be causing this.
I also got this error on an XL2003 machine (same description as above).
After 'resolving' it by saving as an older version of Excel (even
though it originally was XL2000!), I started getting "Out of m...Assign Macro to Icon on toolbar
I want to assign a macro (error message) to the SAVE icon on the Standard
Toolbar to disable that save function to get the user to use the save button
I have set up on the Sheet. I know it can be done because I have it on a
spreadsheet someone elsse set up but I cannot find where they set it up.
THANKS for any help.
In EXCEL 2007 take the following actions:-
Office Button (top left hand corner).
Choose commands from:
- select Macros
Highlight the Macro you wish to attach to the Save button
Your Macro should n...IE script error in Outlook today
I've been recently getting an IE script error:
Error: access denied
Url: Outlook today
Happens 2-3 times a week, in and out of outlook today page
several times a day. Outlook 2003, latest version of IE
Ran repair of office, reinstalled IE. Anything else?
To Repair Outlook 2000
To run the Detect and Repair feature in your Office programs, follow these
1.) Start an Office 2003 program.
2.) On the Help menu, click Detect and Repair.
3.) In the Detect and Repair dialog box, do any of the following:
-Click to select th...SOP_Document_TEMP has an incorrect record Length error
In Great Plains 8.0
Our Sales Transaction Entry, Print Invoice option throws an error
occasionaly that I haven't been able to track down.
The error is: 'An open operation on table 'SOP_Document_TEMP' has an
incorrect record length'. If they repeate the invoice print option it works
fine after 2 or 3 trys.
My Sales Transaction Entry form and the Invoice are modified. I'm not able
to repeate the error so it's difficult to track down. Any suggestions?
The SOP_Document_TEMP table is a ctree temporary table which is created in
the l...Run time error 2465
I'm trying to open an access db and upon loading or opening I get Run
Time Error 2465 Can not find field 'cmdLock' referred to in your
expression. When I go to Debug I see it highlight the line in
frm!cmdLock.Caption = IIf(bLock, "Un&lock", "&Lock")
It seems OK, what am I missing?
One other strange thing, (well strange to me) is that this db is
located on a network drive. No one else has this problem, but me?
When an application works on other PCs, but fails on one PC, this is usually
a sign of a MISSING reference...