macro to continue running if error
Hi,
I have the following macro that is working fine. It is looking at a
specified worksheet array and executing the macro "Filter" on each
worksheets. However, in case one of the worksheet is not existing, I
would like the macro to pass the non existing worksheet and continue
running on the next available worksheet. I tried adding the following
statement: "On Error Resume Next" at the beginning but it is passing
everything.
Any help would be appreciated.
Thanks
Sub UpdateAll()
For Each sh In Worksheets(Array("1", "2", "3", "4", "5", "6", "7",
"10", "11", "12", "21", "22", _
"23", "24", "25", "26", "27", "28", "29", "30", "31", "41", "42",
"43", "44", "45", "46", _
"47", "48", "49", "50", "51", "52", "53", "54", "55", "61"))
sh.Select
Call Filter
Next sh
End Sub
|
0 |
|
Norvascom
2/28/2010 8:10:41 PM
excel.programming
6508 articles. 
2 followers.
6 Replies
1018 Views
I'd try...
Option Explicit
Sub UpdateAll()
Dim iCtr As Long
Dim myArr As Variant
Dim TestWks As Worksheet
myArr = Array("1", "2", "3", "4", "5", "6", "7", _
"10", "11", "12", "21", "22", _
"23", "24", "25", "26", "27", _
"28", "29", "30", "31", "41", "42", _
"43", "44", "45", "46", _
"47", "48", "49", "50", "51", "52", _
"53", "54", "55", "61")
For iCtr = LBound(myArr) To UBound(myArr)
Set TestWks = Nothing
On Error Resume Next
Set TestWks = Worksheets(myArr(iCtr))
On Error GoTo 0
If TestWks Is Nothing Then
'not found!
Else
TestWks.Select
Call macFilter
End If
Next iCtr
End Sub
I wouldn't use Filter as the name of a procedure. If you search VBA's help,
you'll see that it's used by excel.
Norvascom wrote:
>
> Hi,
>
> I have the following macro that is working fine. It is looking at a
> specified worksheet array and executing the macro "Filter" on each
> worksheets. However, in case one of the worksheet is not existing, I
> would like the macro to pass the non existing worksheet and continue
> running on the next available worksheet. I tried adding the following
> statement: "On Error Resume Next" at the beginning but it is passing
> everything.
>
> Any help would be appreciated.
> Thanks
>
> Sub UpdateAll()
> For Each sh In Worksheets(Array("1", "2", "3", "4", "5", "6", "7",
> "10", "11", "12", "21", "22", _
> "23", "24", "25", "26", "27", "28", "29", "30", "31", "41", "42",
> "43", "44", "45", "46", _
> "47", "48", "49", "50", "51", "52", "53", "54", "55", "61"))
> sh.Select
> Call Filter
> Next sh
> End Sub
--
Dave Peterson
|
|
0 |
|
Dave
2/28/2010 9:04:15 PM
Hi,
Not very elegant but it works. Look out for the line wrap on the string of
sheet names
Public sh As Worksheet
Sub UpdateAll()
S =
"1,2,3,4,5,6,7,10,11,12,21,22,23,24,25,26,27,28,29,30,31,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,61"
V = Split(S, ",")
For Each sh In ActiveWorkbook.Worksheets
If Not IsError(Application.Match(sh.Name, V, 0)) Then
Call filter
End If
Next
End Sub
Sub filter()
MsgBox "Filter " & sh.Name
End Sub
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Norvascom" wrote:
> Hi,
>
> I have the following macro that is working fine. It is looking at a
> specified worksheet array and executing the macro "Filter" on each
> worksheets. However, in case one of the worksheet is not existing, I
> would like the macro to pass the non existing worksheet and continue
> running on the next available worksheet. I tried adding the following
> statement: "On Error Resume Next" at the beginning but it is passing
> everything.
>
> Any help would be appreciated.
> Thanks
>
> Sub UpdateAll()
> For Each sh In Worksheets(Array("1", "2", "3", "4", "5", "6", "7",
> "10", "11", "12", "21", "22", _
> "23", "24", "25", "26", "27", "28", "29", "30", "31", "41", "42",
> "43", "44", "45", "46", _
> "47", "48", "49", "50", "51", "52", "53", "54", "55", "61"))
> sh.Select
> Call Filter
> Next sh
> End Sub
> .
>
|
|
0 |
|
Utf
2/28/2010 9:42:01 PM
I am assuming that the numbers are the actual sheet names and not the sheet
index number. If my assumption is correct then try the code below and there
will be no error.
Using Select Case, even though there is only one case, multiple names can be
used separated by a comma and in effect they become Or operators.
The reason for the error in your code is that if the sheet does not exist,
you cannot use it in the array in the For Each statement.
Sub UpdateAll()
Dim sh As Worksheet
For Each sh In Worksheets
Select Case sh.Name
Case "1", "2", "3", "4", "5", _
"6", "7", "10", "11", "12", _
"21", "22", "23", "24", "25", _
"26", "27", "28", "29", "30", _
"31", "41", "42", "43", "44", _
"45", "46", "47", "48", "49", _
"50", "51", "52", "53", "54", _
"55", "61"
End Select
sh.Select
Call Filter
Next sh
End Sub
--
Regards,
OssieMac
|
|
0 |
|
Utf
2/28/2010 9:46:01 PM
My apologies. An error in the code I posted. It will work better if the
Select and Call are included within the Case instead of outside of it. Also
noted Dave's comment re Filter
Sub UpdateAll()
Dim sh As Worksheet
For Each sh In Worksheets
Select Case sh.Name
Case "1", "2", "3", "4", "5", _
"6", "7", "10", "11", "12", _
"21", "22", "23", "24", "25", _
"26", "27", "28", "29", "30", _
"31", "41", "42", "43", "44", _
"45", "46", "47", "48", "49", _
"50", "51", "52", "53", "54", _
"55", "61"
sh.Select
Call macFilter
End Select
Next sh
End Sub
--
Regards,
OssieMac
"OssieMac" wrote:
> I am assuming that the numbers are the actual sheet names and not the sheet
> index number. If my assumption is correct then try the code below and there
> will be no error.
>
> Using Select Case, even though there is only one case, multiple names can be
> used separated by a comma and in effect they become Or operators.
>
> The reason for the error in your code is that if the sheet does not exist,
> you cannot use it in the array in the For Each statement.
>
> Sub UpdateAll()
> Dim sh As Worksheet
> For Each sh In Worksheets
>
> Select Case sh.Name
>
> Case "1", "2", "3", "4", "5", _
> "6", "7", "10", "11", "12", _
> "21", "22", "23", "24", "25", _
> "26", "27", "28", "29", "30", _
> "31", "41", "42", "43", "44", _
> "45", "46", "47", "48", "49", _
> "50", "51", "52", "53", "54", _
> "55", "61"
>
> End Select
>
> sh.Select
>
> Call Filter
>
> Next sh
> End Sub
>
> --
> Regards,
>
> OssieMac
>
>
|
|
0 |
|
Utf
2/28/2010 10:01:01 PM
On Feb 28, 5:01=A0pm, OssieMac <Ossie...@discussions.microsoft.com> wrote: > My apologies. An error in the code I posted. It will work better if the > Select and Call are included within the Case instead of outside of it. Al= so > noted Dave's comment re Filter > > Sub UpdateAll() > Dim sh As Worksheet > =A0 =A0 For Each sh In Worksheets > > =A0 =A0 =A0 Select Case sh.Name > > =A0 =A0 =A0 =A0 Case "1", "2", "3", "4", "5", _ > =A0 =A0 =A0 =A0 =A0 "6", "7", "10", "11", "12", _ > =A0 =A0 =A0 =A0 =A0 "21", "22", "23", "24", "25", _ > =A0 =A0 =A0 =A0 =A0 "26", "27", "28", "29", "30", _ > =A0 =A0 =A0 =A0 =A0 "31", "41", "42", "43", "44", _ > =A0 =A0 =A0 =A0 =A0 "45", "46", "47", "48", "49", _ > =A0 =A0 =A0 =A0 =A0 "50", "51", "52", "53", "54", _ > =A0 =A0 =A0 =A0 =A0 "55", "61" > > =A0 =A0 =A0 =A0 =A0 sh.Select > > =A0 =A0 =A0 =A0 =A0 Call macFilter > > =A0 =A0 =A0 End Select > > =A0 =A0 Next sh > End Sub > > -- > Regards, > > OssieMac > > > > "OssieMac" wrote: > > I am assuming that the numbers are the actual sheet names and not the s= heet > > index number. If my assumption is correct then try the code below and t= here > > will be no error. > > > Using Select Case, even though there is only one case, multiple names c= an be > > used separated by a comma and in effect they become Or operators. > > > The reason for the error in your code is that if the sheet does not exi= st, > > you cannot use it in the array in the For Each statement. > > > Sub UpdateAll() > > Dim sh As Worksheet > > =A0 =A0 For Each sh In Worksheets > > > =A0 =A0 =A0 Select Case sh.Name > > > =A0 =A0 =A0 =A0 Case "1", "2", "3", "4", "5", _ > > =A0 =A0 =A0 =A0 =A0 "6", "7", "10", "11", "12", _ > > =A0 =A0 =A0 =A0 =A0 "21", "22", "23", "24", "25", _ > > =A0 =A0 =A0 =A0 =A0 "26", "27", "28", "29", "30", _ > > =A0 =A0 =A0 =A0 =A0 "31", "41", "42", "43", "44", _ > > =A0 =A0 =A0 =A0 =A0 "45", "46", "47", "48", "49", _ > > =A0 =A0 =A0 =A0 =A0 "50", "51", "52", "53", "54", _ > > =A0 =A0 =A0 =A0 =A0 "55", "61" > > > =A0 =A0 =A0 End Select > > > =A0 =A0 =A0 sh.Select > > > =A0 =A0 =A0 Call Filter > > > =A0 =A0 Next sh > > End Sub > > > -- > > Regards, > > > OssieMac- Hide quoted text - > > - Show quoted text - Thanks OssieMac
|
|
0 |
|
Norvascom
3/1/2010 1:42:45 AM
Hi. You would have to add a little more logic to this, but here's an
additional general idea:
Select Case Val(sh.Name)
Case 1 To 7, 10 To 12, 21 To 31 'etc
'Do Something
Case Else
'Do Nothing
End Select
= = = = = = =
HTH :>)
Dana DeLouis
On 2/28/2010 8:42 PM, Norvascom wrote:
> On Feb 28, 5:01 pm, OssieMac<Ossie...@discussions.microsoft.com>
> wrote:
>> My apologies. An error in the code I posted. It will work better if the
>> Select and Call are included within the Case instead of outside of it. Also
>> noted Dave's comment re Filter
>>
>> Sub UpdateAll()
>> Dim sh As Worksheet
>> For Each sh In Worksheets
>>
>> Select Case sh.Name
>>
>> Case "1", "2", "3", "4", "5", _
>> "6", "7", "10", "11", "12", _
>> "21", "22", "23", "24", "25", _
>> "26", "27", "28", "29", "30", _
>> "31", "41", "42", "43", "44", _
>> "45", "46", "47", "48", "49", _
>> "50", "51", "52", "53", "54", _
>> "55", "61"
>>
>> sh.Select
>>
>> Call macFilter
>>
>> End Select
>>
>> Next sh
>> End Sub
>>
>> --
>> Regards,
>>
>> OssieMac
>>
>>
>>
>> "OssieMac" wrote:
>>> I am assuming that the numbers are the actual sheet names and not the sheet
>>> index number. If my assumption is correct then try the code below and there
>>> will be no error.
>>
>>> Using Select Case, even though there is only one case, multiple names can be
>>> used separated by a comma and in effect they become Or operators.
>>
>>> The reason for the error in your code is that if the sheet does not exist,
>>> you cannot use it in the array in the For Each statement.
>>
>>> Sub UpdateAll()
>>> Dim sh As Worksheet
>>> For Each sh In Worksheets
>>
>>> Select Case sh.Name
>>
>>> Case "1", "2", "3", "4", "5", _
>>> "6", "7", "10", "11", "12", _
>>> "21", "22", "23", "24", "25", _
>>> "26", "27", "28", "29", "30", _
>>> "31", "41", "42", "43", "44", _
>>> "45", "46", "47", "48", "49", _
>>> "50", "51", "52", "53", "54", _
>>> "55", "61"
>>
>>> End Select
>>
>>> sh.Select
>>
>>> Call Filter
>>
>>> Next sh
>>> End Sub
>>
>>> --
>>> Regards,
>>
>>> OssieMac- Hide quoted text -
>>
>> - Show quoted text -
>
>
> Thanks OssieMac
|
|
0 |
|
Dana
3/1/2010 2:16:15 AM
Similar Artilces:
How do I fix this so I don't get an "Error 2015"
Dim x x = Application.CountIf("E5,E6000", "T13065") How do I fix this so I don't get an "Error 2015" Thanks, Rick Not tried it but I would think x=Application.Countif(Range("E5:E6000"),"T13065") Providing T13065 is a string you are counting. If it's a range reference x=Application.Countif(Range("E5:E6000"),Range("T13065")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk "2D Rick" <rbrowniii@compuserve.com> wrote in m...
Getting an Error when there is nothing to show
-- The bottom of my report which is a statement shows #Error when there is no Invoices to add up. Can I have it blank instead. this my text Box Control Source thanks for any Help....Bob =Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value Try: =IIf([subChildOwnerInvoiceAmount].[HasData], [subChildOwnerInvoiceAmount].[tbAmount]) Explanation in: Bring the total from a subreport onto a main report at: http://allenbrowne.com/casu-18.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.h...
Cannot send mail from outlook, error 0x800CCC78
This message started to appear back in Sept and I haven't been able to send e-mail from Outlook ever since (apart from a 2 day period in Novemeber when the issue disappeared just as quickly as it appeared). I now have to cut and paste e-mail i recieve into the e-mail interface of my provider in order to get e-mail sent. I have posted this error 3 times now and haven't got a solution, plenty of questions about versions, platforms, port numbers etc etc, but no fix. Judging by the hits on google to this, it is and established problem. Come on Microsoft, do your stuff.....
Change outbound server in header to fix 550 Can't verify your host name error
The headers on the outbound emails show the internal DNS name of our exchange server; obviously this won't resolve properly at the destination. How/where in Exchange 5.5 can I force the IMC to use a real fqdn on outbound mail? Thanks! Frinky You can do this in TCP/IP properties\Advanced\DNS tab of machine. And yes, this is not just for Exchange, so you may consider forwarding all outgoing mail to some relay server (your firewall or ISP's server). Professor Frink wrote: > The headers on the outbound emails show the internal DNS name of our > exchange server; obviously this...
help!! smtp protocol error occurred
exchange 2000 srv/windows 2k srv smtp protocol error occurred when trying to send mails. receives fine. Still waiting for some relavent information so we can help you solve your problem. >-----Original Message----- >exchange 2000 srv/windows 2k srv >smtp protocol error occurred when trying to send mails. >receives fine. > > >. > I had that problem, I telneted into the servers that the error occurred and found I was on a blacklist. Had to sumit to an open relay test, and bam, no more problems. ...
Visual Basic Error
Every time I shut down Outlook, I now get the following Microsoft Visual Basic error: "Compile error in hidden module: Autoexec" This started after I installed the software for People PC Dial -up Service. They haven't responded to my question and Tech Net/Knowledge base come up empty. Help!!! Thanks So, uninstall that software. It's obviously the problem and if they won't support it then it's useless to you. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Exten...
Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project. it gives me following error. I checked the current users, there are no users. Apart from me. There are some non PA users,i tried to remove them from activity. inspite of me removing them from activity, im geting the same error. Help !!! Ramakrishnan Hello Ram, There is a stranded user in PA000001 table. You need to clear this User/Project combination. Ajay "Ram" wrote: > Please see the subject line, when im trying to open a particular project. > it gives me following error. > > I che...
How to get a macro to do what i want?
I have designed a form in Excel and the data that is inputted i want to be able to save in a separate worksheet. The problem i am having is that eveytime i record the macro, it over writes the same row each time (if that makes sense). For example if i copied every cell in the form and paste them into the database Row 1, i then want the new piece of information inputted into the form to go into Row 2 and then Row 3 etc.... But it keeps going into Row 1, it wouldnt move down the rows. Hopefully this makes sense to someone and someone can give me some advise. Calculate the last row ...
can you tell me what an error 920 is?
I'm trying to save a visio file out as a jpeg, or gif, or png. I keep getting the error with no explanation of what the error means - any help is appreciated You can go to the following link and it explains the issue you are having and how to fix it: http://support.microsoft.com/default.aspx?kbid=295691 "Julie" wrote: > I'm trying to save a visio file out as a jpeg, or gif, or png. I keep > getting the error with no explanation of what the error means - any help is > appreciated > > > ...
User Authentication Error
Hello All, I am running CRM 3.0. I have the system administrator role. When attempting to merge 2 account records I receive an error that states, "The user authentication passed to the platform is not valid." I cannot merge the records. If anyone can, please advise. thanks. Keith ...
Report Error 11-24-04
When attempting to run CRM Reports for the first time we are receiving the error "Information is needed before this report can be processed" I have found documentation that states that this can happen if your server has an underscore. Our server does not it is named ourcompany.server.eeecrm Can the periods have the same effect as the underscore. Or does anyone have another cause? Thank you Hi There - Hope you don't mind but I wish to piggy-back on your post. I get the same error on our custom reports that use OLE DB to connect to another SQL server other than the MS CRM ...
Userform combobox matchrequired = True; error with no selection
I have a userform that includes a combobox which is optional for the user, but if they do use it, they have to select one of the three values provided (no creativity allowed). This works fine if the user ignores the field, or if they make a selection. They can even click the combobox 'arrow' to see the values and then click to another part of the form without making a selection. They can tab through controls including this one without any problem. All good. However, a user may enter the field (mouseclick) thinking they might want to make a selection, then decide again...
Script Errors 08-12-04
When launching CRM 1.2 through the web interface or through Outlook I am experiencing errors. This occurs on all the PCs on our network. CRM installed on Windows 2000 Advanced Server Client PCs running 2000 or XP Pro Browser IE6 with all updates. The main 3 I see are: Error #1 Line: 3 Char: 1 Error: Syntax Error Code: 0 URL: https://crm/home/home_home.aspx Error #2 Line: 104 Char: 1 Error: 'ORG_DATE_START_DAY' is undefined Code: 0 URL: https://crm/home/home_home.aspx Error #3 Line: 15 Char: 3 Error: 'ORG_DATE_FORMAT' is undefined Code: 0 URL: https://crm/home/home_home...
Outlook 2002 SP3- Runtime Error when opening Outlook
I'm getting a runtime error- Microsoft Visual C++ Runtime Library / Program C:/Program Files/ microsoftoffice/ office10 /outlook.exe. This App has requested the runtime to terminate it in an unusal way. This only happen the first time I open Outlook for the day. It shuts down, then I can reopen it and all is fine. I have try to debug it and the detect & repair option in the help tab. Any help is Appreciated! ...
Failed to open mmf error appears
A pop up window appears with the message 'failed to oepn mmf'. I assume it is referring to Microsoft mail format. What could be triggering this error. What version of Outlook, and when do you see this error? EllenB wrote: > A pop up window appears with the message 'failed to oepn > mmf'. I assume it is referring to Microsoft mail format. > > > What could be triggering this error. >-----Original Message----- >What version of Outlook, and when do you see this error? > >EllenB wrote: >> A pop up window appears with the message 'fail...
Unknown error code
Hi, I'm trying to set up email in outlook 2007. After I put in all the information and click on "test account settings", I'm getting an error message. I mean, in the task tab, the "log onto incoming mail server (POP3), the status is completed" but on "send test email message, the status is Failed. and the error message is giving is "an unknown error code: 0x80040607 Does anybody knows out to fix this? Have you been able to send mail out before using that account, possibly with another mail client? "DM" <DM@discussions.microsoft.com> ...
Autoenrollment errors after adding SSL certificate
Hello, I'm running an all Windows 2003 domain with an exchange server which is setup so that Outlook web access is using SSL which required that I installed a certificate. Ever since I've set up exchange to use this certificate I receive the following errors in the Application log for both my Domain Controllers (both also Windows Server 2003) which occurs every 8 hours. Both Domain Controllers show the following errors in the Application Log Source: AutoEnrollment Type: Error User: N/A Computer: DomainController1 or 2 Event ID: 13 Description: Automatic certificate enrollment for loc...
error message in Outlook after running windows and office updates
Hello, I am hoping someone can help me with this. When ever a few staff tries to send a new e-mail, a message "Do you want to save changes" come up and on the back of this message I see the spell checker box come up. The problem is that if you click on "no" on the error message, it comes up with another message something like "running out of memory". I just ran all the windows and office updates on all the machines in the company and so far two employees are having this problem. Is this something to do with the updates? Any suggestions? did you try ...
Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an empty cell within the macro's range. When working within a spreadsheet, Ctrl +; returns the system date, but I can't figure out how to put that command into a macro. The macro recorder editor shows that the system recognizes the entry as the current date, not a function that returns the current date. The now() or today() functions are both dynamic ... they change with the system date. That's not acceptable in this situation. I need to seen when the macro was run. Thanks for any help, Ralph di...
Macro to apply alternate grey/white shading to selected paragraphs
Dear Experts: I would like to do paragraph shading using grey shading alternately. Example: this is a sample text This is another sample text This is yet another sample text This may be the last paragraph acquiring grey shading This is the penultimate paragraph This is the last paragraph With these 6 paragraphs selected, I would like to run a macro which applies grey shading alternately to the selected paragraphs, i.e. grey/ white (no shading) alternately. Help is much appreciated. Thank you very much in advance. Regards, Andreas Use Dim oRng As Range For i = 2 T...
Run-time error 1004
I am using Excel 97 on NT and have a command button on a sheet to whic I attached a macro for copying the sheet to a new workbook, deletin specific columns and other unnecessary info, and saving the new book t a network drive under a name with today's date for emailing to anothe area. When I perform the function manually everything works beautifully bu when I attempt to execute the macro I get the following error "Run-time error '1004': Copy method of worksheet class failed". when use the Debug button, VBA highlights Sheets("Daily").Copy as th culprit. Macro f...
Macro Security, Password Recovery & VB Code execution
I have found that if I set my macro security to high, VB code within (non-trusted) excel sheets do not execute... a microsoft security feature that ostensibly prevents non- trusted users from running VB The questions I have are : Is there a way to guarantee VB macro-execution using digital certificates or what-have-you ? Is there a way to detect, either within excel (well, not possible, it seems) or from outside, that the combo of users macro-security settings and signature status of a perticular excel file, WILL prevent VB from executing, if the file is attempted to opened ? ...
force excel to run in only one process excel.exe
force excel to run in only one process excel.exe, excel seems to want to make multiple excel.exe loaded into memory which causes mysheet.copy to fail so i have to close out the xls, kill all running excel.exe, then run the xls again and the macro works. i only have to do this when i am actively debugging a lot. if i just run my macro w/o opening the vba debugger, i can run it as much as i want, but if i run with break points it crashes a lot because of multiple excel.exe loaded into memory. perhaps there is a way i can force excel to only load one excel.exe? Daniel, Are you using Automatio...
Continuous update unsuccessful--this is truly bogus
Any updated info on the online account updating issues in Money 2005/2006. Example. I have several credit cards listed and setup for online account access, downloaded transactions (advanced register), etc. Suddenly the account will get an error stating that "update unsuccessful" and then never updates after that. I have read where the advice was to delete the online account and reset it up. The problems I have with that are that when I do that, now all my transaction history for that account is lost and I am given only the balance. I have selected the max for account hist...
Outlook Web Access HTTP 500 and HTTP 404 errors
hi, I am experiencing this problem on Exchange 2003 on Windows 2003, when the users try to authenticate to Outlook Web Access, they get the following error messages in their browsers, "http 500 - internal server error" or "http error 404 - file or directory not found", the customer upgraded to windows/exchange 2003 6 months ago from windows/Exchange 2000 (in place upgrade), they only discovered the problem last week when they tried creating new users, i created 3 test users and the 3 users were getting the above errors. some already existing users have no prob...
Dim x x = Application.CountIf("E5,E6000", "T13065") How do I fix this so I don't get an "Error 2015" Thanks, Rick Not tried it but I would think x=Application.Countif(Range("E5:E6000"),"T13065") Providing T13065 is a string you are counting. If it's a range reference x=Application.Countif(Range("E5:E6000"),Range("T13065")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk "2D Rick" <rbrowniii@compuserve.com> wrote in m...
Getting an Error when there is nothing to show
-- The bottom of my report which is a statement shows #Error when there is no Invoices to add up. Can I have it blank instead. this my text Box Control Source thanks for any Help....Bob =Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value Try: =IIf([subChildOwnerInvoiceAmount].[HasData], [subChildOwnerInvoiceAmount].[tbAmount]) Explanation in: Bring the total from a subreport onto a main report at: http://allenbrowne.com/casu-18.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.h...
Cannot send mail from outlook, error 0x800CCC78
This message started to appear back in Sept and I haven't been able to send e-mail from Outlook ever since (apart from a 2 day period in Novemeber when the issue disappeared just as quickly as it appeared). I now have to cut and paste e-mail i recieve into the e-mail interface of my provider in order to get e-mail sent. I have posted this error 3 times now and haven't got a solution, plenty of questions about versions, platforms, port numbers etc etc, but no fix. Judging by the hits on google to this, it is and established problem. Come on Microsoft, do your stuff.....
Change outbound server in header to fix 550 Can't verify your host name error
The headers on the outbound emails show the internal DNS name of our exchange server; obviously this won't resolve properly at the destination. How/where in Exchange 5.5 can I force the IMC to use a real fqdn on outbound mail? Thanks! Frinky You can do this in TCP/IP properties\Advanced\DNS tab of machine. And yes, this is not just for Exchange, so you may consider forwarding all outgoing mail to some relay server (your firewall or ISP's server). Professor Frink wrote: > The headers on the outbound emails show the internal DNS name of our > exchange server; obviously this...
help!! smtp protocol error occurred
exchange 2000 srv/windows 2k srv smtp protocol error occurred when trying to send mails. receives fine. Still waiting for some relavent information so we can help you solve your problem. >-----Original Message----- >exchange 2000 srv/windows 2k srv >smtp protocol error occurred when trying to send mails. >receives fine. > > >. > I had that problem, I telneted into the servers that the error occurred and found I was on a blacklist. Had to sumit to an open relay test, and bam, no more problems. ...
Visual Basic Error
Every time I shut down Outlook, I now get the following Microsoft Visual Basic error: "Compile error in hidden module: Autoexec" This started after I installed the software for People PC Dial -up Service. They haven't responded to my question and Tech Net/Knowledge base come up empty. Help!!! Thanks So, uninstall that software. It's obviously the problem and if they won't support it then it's useless to you. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Exten...
Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project. it gives me following error. I checked the current users, there are no users. Apart from me. There are some non PA users,i tried to remove them from activity. inspite of me removing them from activity, im geting the same error. Help !!! Ramakrishnan Hello Ram, There is a stranded user in PA000001 table. You need to clear this User/Project combination. Ajay "Ram" wrote: > Please see the subject line, when im trying to open a particular project. > it gives me following error. > > I che...
How to get a macro to do what i want?
I have designed a form in Excel and the data that is inputted i want to be able to save in a separate worksheet. The problem i am having is that eveytime i record the macro, it over writes the same row each time (if that makes sense). For example if i copied every cell in the form and paste them into the database Row 1, i then want the new piece of information inputted into the form to go into Row 2 and then Row 3 etc.... But it keeps going into Row 1, it wouldnt move down the rows. Hopefully this makes sense to someone and someone can give me some advise. Calculate the last row ...
can you tell me what an error 920 is?
I'm trying to save a visio file out as a jpeg, or gif, or png. I keep getting the error with no explanation of what the error means - any help is appreciated You can go to the following link and it explains the issue you are having and how to fix it: http://support.microsoft.com/default.aspx?kbid=295691 "Julie" wrote: > I'm trying to save a visio file out as a jpeg, or gif, or png. I keep > getting the error with no explanation of what the error means - any help is > appreciated > > > ...
User Authentication Error
Hello All, I am running CRM 3.0. I have the system administrator role. When attempting to merge 2 account records I receive an error that states, "The user authentication passed to the platform is not valid." I cannot merge the records. If anyone can, please advise. thanks. Keith ...
Report Error 11-24-04
When attempting to run CRM Reports for the first time we are receiving the error "Information is needed before this report can be processed" I have found documentation that states that this can happen if your server has an underscore. Our server does not it is named ourcompany.server.eeecrm Can the periods have the same effect as the underscore. Or does anyone have another cause? Thank you Hi There - Hope you don't mind but I wish to piggy-back on your post. I get the same error on our custom reports that use OLE DB to connect to another SQL server other than the MS CRM ...
Userform combobox matchrequired = True; error with no selection
I have a userform that includes a combobox which is optional for the user, but if they do use it, they have to select one of the three values provided (no creativity allowed). This works fine if the user ignores the field, or if they make a selection. They can even click the combobox 'arrow' to see the values and then click to another part of the form without making a selection. They can tab through controls including this one without any problem. All good. However, a user may enter the field (mouseclick) thinking they might want to make a selection, then decide again...
Script Errors 08-12-04
When launching CRM 1.2 through the web interface or through Outlook I am experiencing errors. This occurs on all the PCs on our network. CRM installed on Windows 2000 Advanced Server Client PCs running 2000 or XP Pro Browser IE6 with all updates. The main 3 I see are: Error #1 Line: 3 Char: 1 Error: Syntax Error Code: 0 URL: https://crm/home/home_home.aspx Error #2 Line: 104 Char: 1 Error: 'ORG_DATE_START_DAY' is undefined Code: 0 URL: https://crm/home/home_home.aspx Error #3 Line: 15 Char: 3 Error: 'ORG_DATE_FORMAT' is undefined Code: 0 URL: https://crm/home/home_home...
Outlook 2002 SP3- Runtime Error when opening Outlook
I'm getting a runtime error- Microsoft Visual C++ Runtime Library / Program C:/Program Files/ microsoftoffice/ office10 /outlook.exe. This App has requested the runtime to terminate it in an unusal way. This only happen the first time I open Outlook for the day. It shuts down, then I can reopen it and all is fine. I have try to debug it and the detect & repair option in the help tab. Any help is Appreciated! ...
Failed to open mmf error appears
A pop up window appears with the message 'failed to oepn mmf'. I assume it is referring to Microsoft mail format. What could be triggering this error. What version of Outlook, and when do you see this error? EllenB wrote: > A pop up window appears with the message 'failed to oepn > mmf'. I assume it is referring to Microsoft mail format. > > > What could be triggering this error. >-----Original Message----- >What version of Outlook, and when do you see this error? > >EllenB wrote: >> A pop up window appears with the message 'fail...
Unknown error code
Hi, I'm trying to set up email in outlook 2007. After I put in all the information and click on "test account settings", I'm getting an error message. I mean, in the task tab, the "log onto incoming mail server (POP3), the status is completed" but on "send test email message, the status is Failed. and the error message is giving is "an unknown error code: 0x80040607 Does anybody knows out to fix this? Have you been able to send mail out before using that account, possibly with another mail client? "DM" <DM@discussions.microsoft.com> ...
Autoenrollment errors after adding SSL certificate
Hello, I'm running an all Windows 2003 domain with an exchange server which is setup so that Outlook web access is using SSL which required that I installed a certificate. Ever since I've set up exchange to use this certificate I receive the following errors in the Application log for both my Domain Controllers (both also Windows Server 2003) which occurs every 8 hours. Both Domain Controllers show the following errors in the Application Log Source: AutoEnrollment Type: Error User: N/A Computer: DomainController1 or 2 Event ID: 13 Description: Automatic certificate enrollment for loc...
error message in Outlook after running windows and office updates
Hello, I am hoping someone can help me with this. When ever a few staff tries to send a new e-mail, a message "Do you want to save changes" come up and on the back of this message I see the spell checker box come up. The problem is that if you click on "no" on the error message, it comes up with another message something like "running out of memory". I just ran all the windows and office updates on all the machines in the company and so far two employees are having this problem. Is this something to do with the updates? Any suggestions? did you try ...
Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an empty cell within the macro's range. When working within a spreadsheet, Ctrl +; returns the system date, but I can't figure out how to put that command into a macro. The macro recorder editor shows that the system recognizes the entry as the current date, not a function that returns the current date. The now() or today() functions are both dynamic ... they change with the system date. That's not acceptable in this situation. I need to seen when the macro was run. Thanks for any help, Ralph di...
Macro to apply alternate grey/white shading to selected paragraphs
Dear Experts: I would like to do paragraph shading using grey shading alternately. Example: this is a sample text This is another sample text This is yet another sample text This may be the last paragraph acquiring grey shading This is the penultimate paragraph This is the last paragraph With these 6 paragraphs selected, I would like to run a macro which applies grey shading alternately to the selected paragraphs, i.e. grey/ white (no shading) alternately. Help is much appreciated. Thank you very much in advance. Regards, Andreas Use Dim oRng As Range For i = 2 T...
Run-time error 1004
I am using Excel 97 on NT and have a command button on a sheet to whic I attached a macro for copying the sheet to a new workbook, deletin specific columns and other unnecessary info, and saving the new book t a network drive under a name with today's date for emailing to anothe area. When I perform the function manually everything works beautifully bu when I attempt to execute the macro I get the following error "Run-time error '1004': Copy method of worksheet class failed". when use the Debug button, VBA highlights Sheets("Daily").Copy as th culprit. Macro f...
Macro Security, Password Recovery & VB Code execution
I have found that if I set my macro security to high, VB code within (non-trusted) excel sheets do not execute... a microsoft security feature that ostensibly prevents non- trusted users from running VB The questions I have are : Is there a way to guarantee VB macro-execution using digital certificates or what-have-you ? Is there a way to detect, either within excel (well, not possible, it seems) or from outside, that the combo of users macro-security settings and signature status of a perticular excel file, WILL prevent VB from executing, if the file is attempted to opened ? ...
force excel to run in only one process excel.exe
force excel to run in only one process excel.exe, excel seems to want to make multiple excel.exe loaded into memory which causes mysheet.copy to fail so i have to close out the xls, kill all running excel.exe, then run the xls again and the macro works. i only have to do this when i am actively debugging a lot. if i just run my macro w/o opening the vba debugger, i can run it as much as i want, but if i run with break points it crashes a lot because of multiple excel.exe loaded into memory. perhaps there is a way i can force excel to only load one excel.exe? Daniel, Are you using Automatio...
Continuous update unsuccessful--this is truly bogus
Any updated info on the online account updating issues in Money 2005/2006. Example. I have several credit cards listed and setup for online account access, downloaded transactions (advanced register), etc. Suddenly the account will get an error stating that "update unsuccessful" and then never updates after that. I have read where the advice was to delete the online account and reset it up. The problems I have with that are that when I do that, now all my transaction history for that account is lost and I am given only the balance. I have selected the max for account hist...
Outlook Web Access HTTP 500 and HTTP 404 errors
hi, I am experiencing this problem on Exchange 2003 on Windows 2003, when the users try to authenticate to Outlook Web Access, they get the following error messages in their browsers, "http 500 - internal server error" or "http error 404 - file or directory not found", the customer upgraded to windows/exchange 2003 6 months ago from windows/Exchange 2000 (in place upgrade), they only discovered the problem last week when they tried creating new users, i created 3 test users and the 3 users were getting the above errors. some already existing users have no prob...