Sheets changing namesThe following macro saves various lists to new sheets in the same workbook.
The first save is named 12-4-09 the second is 12-4-09a and so on. The initial
Sheet is “Master”
What happens is that on the first save the Master’s list does not remain as
it was originally but changes to match the list that was just saved as
(12-4-09) list This means that both sheets are the same On the next save to
(12-4-09a) it actually has the list that was in 12-4-09a and the new list is
in the old 12-4-09. I don’t know if I am making my self clear but if you open
a workbook and rename the sheet Mas...
Does INSTR() work on memo fieldsDoes INSTR() work on memo fields ?
It seems like I'm not finding text that is there.
On Wed, 25 Apr 2007 14:52:02 -0700, mscertified wrote:
> Does INSTR() work on memo fields ?
>
> It seems like I'm not finding text that is there.
Yes it does.
Why not post exactly what you are trying to do and how you are doing
it?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
...
Previous Command No Longer WorksI’m using coding below to insert “0000-yy” into a textbox.
The numbering system works great except that I have lost the ability to move
back to the previous record. It must be something to do with the code.
How can I fix it?
Private Sub Form_Current()
If Me.NewRecord Then
Dim strWhere As String
Dim varResult As Variant
strWhere = "IncidentID Like """ & Format(Date, "yy") & "*"""
varResult = DMax("IncidentID", "tblIncidentLog", strWhere)
If IsNull(varResult) Then
...
Check 2 columns of names for duplicatesI have 2 very large lists of names. I need to quickly see if any of the names that appear in one column match any of the names in the other column. (One list is existing customers, one list is leads for new business. I don't want to send existing customers an offer to do business.)
Chip Pearson has a bunch of techniques for working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm
jimp wrote:
>
> I have 2 very large lists of names. I need to quickly see if any of the names that appear in one column match any of the names in the other column. (One list is existing cust...
Summarize project time from different sheets in one without losing references when sorting the cells.hi I have a a lot of sheets in one excel-file, about 25 upwards , and
in these I fill in the time for each project each person is involved
in. What I want is a sheet with a summary for all the projects. Every
project has a six digit code.
Can I create a formula that searches through the entire project for
example project 440011 and return the value to the sheet where I
summarize all the time?
The problem is that I want the projects to be sorted by the six digit
code but when I sort them in each persons sheet the references in the
summarized sheet will be wrong.
Does anyone understand what ...
Outlook Does Not Recognize One or More Names!Using Microsoft Office 2003, all the latest updates.
I get that error message now, when I click "Send" on an e-mail message to
someone who does not appear in my address book, or to whom I did not send
mail to or receive mail from before, and the mail will not go into the
Outbox, to be sent. What is causing that?
Of course I will sometimes write to people whom are not in my address book,
and with whom I have not corresponded before. Of course Outlook will not
always recognize an e-mail address I am sending a message to. Why that
should generate an error message, and refuse to send t...
to Filter or not to Filter option not working...i had a from with a combobox: cmbFilter
and this code behind it...
cmbFilter_BeforeUpdate()
Me.Filter = "[Source] = '" & Me![cmbFilter] & "'"
Me.FilterOn = True
this worked fine...
then i added an option group with 2 controls: optShowAll, and optFilterList
(with respective functions)
and added this code behind each:
optShowAll_GotFocus()
me.cmbFilter.enabled = False
me.FilterON = False
optFilterList_GotFocus()
me.cmbFilter = ""
me.cmbFilter.enabled = True
now, basically nothing works... (what am i missing...
Cannot get the smart tags to work in ExcelHey Guys,
I'm using Excel 07 on Vista, off lately smart tags don't work anymore.
I tried Excel /safe and smart tags work in the app safe mode. Can
someone help me out with this issue?
Thanks.
...
protecting sheetMorning all,
I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" in the protect sheet menu. It implies that a worksheet can
be protected in a granular fashion. For example I could allow the user to
insert columns, add data, format rows, but not delete columns or rows. When
I try selecting these options and then save the sheet, i'm always prompted
to unprotect before any data can be entered.
I'm trying to understand the purpose of the "Allow all users of this
worksheet to:" check boxes. If it's necessary to unprotect befo...
how can we sort data as we could do it in works? Select one colum.
MP, not sure of you question because I do not have works, but in excel,
using the sort buttons on the too bar, if you have data in A:C and if you
select column A only column A is sorted, if you select a cell in column A
then A will sort but the data in B:C will be move with it. If this does not
answer your question post back with more info.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply b...
XmlSerializer in COM exported C# does not work on every machineHi,
I have written a component using C# (using .NET 2.0) that inside at some
point does a Deserialize operation on a string that was passed to it
using XmlSerializer. This works just fine on my computer, where I
register it, and can call it from say a ASP page using VBScript and
CreateObject. It also works on at least another computer.
However, when I deploy the solution to our server (W2K3) or to a third
computer (another developers machine), I get a mysterious
InvalidOperationException which says it did not expect the XML element
that the string begins with (root element).
Sys...
Auto fill multiple sections with different namesI have weekly time broken down by category, however, only the total line has
the corresponding names. How do i fill the above cells with the corresponding
name on the total line. For example(where blank insert last name on total
line)
Col A Col D
blank wk27
blank wk28
blank wk29
blank wk30
Smith Total
blank wk27
blank wk28
blank wk29
johnson Total
thanks
Try this:
1. Select the cells in column A
2. Press F5
3. Select 'Blanks...
Money online features stop working with IE 7.0 betaA reported bug. They are looking for a fix. None of the online features work
with IE 7.0 installed. Have to take it off in Add/Remove Programs and go
back to IE version 6. Really liked IE 7.0 but can't do online banking. Oh,
well.
Have you tried Mozilla Firefox?
It is extensible and loaded with features.
I rarely use IE.
I use IE if and when I might encounter Java problems at some site.
arthur
==
On Sat, 29 Apr 2006 20:11:43 -0500, "Jim Seidel"
<seidel_jk@sbcglobal.net> wrote:
>A reported bug. They are looking for a fix. None of the online features work
>...
How to revert to an earlier version of a spreadsheetIs there a way to revert to an earlier saved version of an
Excel document (other than find a backed up copy on a
server)?
No.
In article <182501c49b34$0807a560$a601280a@phx.gbl>,
"Jessie" <anonymous@discussions.microsoft.com> wrote:
> Is there a way to revert to an earlier saved version of an
> Excel document (other than find a backed up copy on a
> server)?
...
test #41
...
copy sheet
Hi
i made this code
Sub bladenkopie()
Application.ScreenUpdating = False
Dim naam As String, rij As Integer
Dim teller As Integer
Dim i As Integer
Sheets(3).Select
Columns("A:A").NumberFormat = "0"
teller = Sheets.Count
rij = 2
Sheets(3).Select
naam = Cells(rij, 3).Value
Do While naam <> ""
Sheets("Blad2").Copy After:=Sheets(teller)
Sheets(Sheets.Count).Name = teller
Sheets(3).Cells(rij, 8).Copy Cells(1, 7)
Cells(1, 7).Font.ColorIndex = 2
teller = teller + 1
rij = rij + 1
naam = Sheets(3).Cells(rij, 3).Value
Loop
...
WHy isnt my weboutlook working?I need some help because my weboutlook server crashed
last nite and I wasn't able to have it go back up...I can
get emails within my lan and I can access the weboutlook
within my lan...but when I exit my lan...I can't access
web outlook.
Thank you for your help,
What exactly happens when you attempt to use OWA from outside of your LAN?
Litsa wrote:
> I need some help because my weboutlook server crashed
> last nite and I wasn't able to have it go back up...I can
> get emails within my lan and I can access the weboutlook
> within my lan...but when I exit my la...
how i draw a shart for multi sheet ?i have amulti worksheet and i need to make a chart for all
Hi,
If I understand, you want to create a chart which uses data from multiple
sheets? If so the easiest way is to build a summary area which pulls the
data in from the different sheets and then chart that.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"ahmad" wrote:
> i have amulti worksheet and i need to make a chart for all
This page adds a little information to Shane's post:
http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html
- Jon
-------
Jon Peltier, Microsoft...
link sent to user does not workAn e-mail with a link to a file on our file server does
not work. The sender (a domain admin) pasted the address
into the e-mail (ex. <\\server\share\file>) but the
recipient was not able to click on it. The recipient is a
domain admin with full rights to the folder where the file
is stored. I had the sender resend the email to me and I
was able to click on the link and open the file. Any help
would be appreciated.
Let me preface that I have just joined this group, and am not near as
knowledgable about this stuff as others, but like taking stabs.
Is the recipient opening his...
Test news
Test news
sorry
Camino Lopez
Mi personal page:
http://www.buscaconcurso.com/
...
Non-working work weekIs there any way to make an entire week a non-working work week? As
in, a task is going to take 25 days, but the 4th of July occurs in the
middle and you want to show that during that week (or 2), no work will
occur. Besides creating a new task or extending the task during.
Thanks in advance!
Hi RVE,
Open up the calendar, "Tools", 'Change working time..', then simply select
the days you want as non working. Make sure that the calendar you change is
the Project calendar and is the basis for all other calendars such as
individual resource calendars.
Hope thi...
Intellesense stops working for my MFC projectThe IntelliSense suddenly stopped working for my MFC project. Whenever it’s triggered, there is an “IntelliSense: ‘No additional information available’” error in the status bar. Of course no intellisense info popped out in my code.
I already verified that
1) There is no code error since the whole project compiles ok;
2) The code is not inside a comment;
3) The code is not inside a string literal;
4) The intellisense is enabled;
5) I tried deleting the .ncb file and reopening project and it didn’t help.
However, this seems to be project specific as the intellisense works if I create a new ...
how do I reveerse name order last name, first name to first name, last nameI have a long database, 27k with names that I want to mail to. The
list is last name, first name. I want to do a global change to first
name, last name. I also want to add "Mr" to it. For example: the
list now is Smith, John. I want to change it to Mr. John Smith for
the entire list.
Assuming there is only one comma in each:
="Mr. "&TRIM(MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1)))&"
"&LEFT(A1,FIND(",",A1)-1)
Note that some of the women might be offended.... 27k names, all male?
Scott
Don Smith wrote:
> I hav...
Displayed Name and Email AddressHi,
Our company email account is actually a distribution group in the exchange
server of our SBS2003. There are two members in this group. In other words,
any inbound email to the company email account, both members (accounts) get
an email copy. The emails of these two account are retrieved via outlook
2003 (which the type of the account is exchange server).
Now the question is: how can I set the outlook so that the recipient "see"
the email address is the distribution group address and name. This can
easily be done in pop3 account. But for exchange server account, there is n...
Changing Server NameI set up an Exchange 2003 server. While messing around with the
settings, I realized I did not like the name of the machine, so I
changed it. But, in ESM, it still shows the old server name. How do
I change the server name in ESM?
Thanks,
Jeff
On Sat, 25 Mar 2006 14:32:51 -0800, Jeff Grossman
<jeff.nospam@stikman.com> wrote:
>I set up an Exchange 2003 server. While messing around with the
>settings, I realized I did not like the name of the machine, so I
>changed it. But, in ESM, it still shows the old server name. How do
>I change the server name in ESM?
>
>Th...