Solved

If excel worksheet name <> "Summary" OR "SummaryClient" Then

Posted on 2012-03-23
2
294 Views
Last Modified: 2012-03-23
Hi Experts,

The code below works fine:
        If xlSheet.Name <> "Summary" Then
            xlSheet.UsedRange.ClearContents

But, I now need to adda second worksheet:
Attemtp 1: If excel worksheet name <> "Summary" OR "SummaryClient" Then
Attempt 2: If excel worksheet name <> Like "Summary*" Then

What's the best way to do this?

Thks in advance!
Steven
0
Comment
Question by:scsnow2310
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 250 total points
ID: 37757907
If xlSheet.Name <> "Summary"   AND xlSheet.Name <> "SummaryClient" Then
0
 

Author Closing Comment

by:scsnow2310
ID: 37757956
Great - Thanks!
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now