I use E2K3 in this configuration : 1 FE; 1 BE
My FE is in DMZ,when my user open thir Outlook 2000 they received an POP, in
this popup, request Exchnage for found information, i read my FE Name.
Have you an idae ? for help to find my pb.
Rem : after this delay , i have'nt any pb for use outlook or on my BE;
I have created a drop down list in excel which is attached to a table (via VLOOKUP). The drop down list contains a code number. What I would like is a comment next to the list saying what each code represents (eg 100 - stationery) but only putting in the value when selected (as it is part of a formula). does anyone know how to do this?
any help appreciated.
If this is a listbox from the Control Toolbox then you can do this:
Call up the listbox's Properties
Select ColumnCount and enter 2
Select ColumnWidths eg 30, 100 (depends on you...Copy Purchase orders #2
Does any one know how to copy a purchase order?
We do booking orders and have different ship dates. I would like to break up
my PO and not have to enter items 2 - 3 times.
No-one answered this one yet. Shame, because I could do with knowing. We
very often want to produce a PO for 8 branch, all identical.
"lax guy" <firstname.lastname@example.org> wrote in message
> Does any one know how to copy a purchase order?
> We do booking orders and have different ship dates. I would like...multiple emails #2
recently whenever i send an email to someone, they receive
at least 2 copies of it, sometimes 3, i just noticed that
when i am sending, the in process shows 2 processes for
each email that i send.
anybody got any ideas.
...Pivot Chart #2
I have Excel 97 at work.
I have a Pivot Table.
I want to make charts for items that their grand total is more than
100, between 10 and hundred and less than hundred.
So everytime the pivot table is updated the charts will update
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
...How to make two codes "Worksheet_Change" work together in same sheet code page
Please, anybody knows how to make these two VB codes work together?
When I put them together in the same "sheet code page" in VBA, th
second one doesn't work. Why?
*** Code 1 ***
Private Sub Worksheet_Change(ByVal Target As Range)
* * On Error GoTo QuitCode
* * If Intersect(Target, Range("c1:c15")) Is Nothing Then
* * * * Exit Sub
* * ElseIf Target.Value <>*"" And Target.Offset(0, -1).Value = "" Then
* * * * MsgBox "You haven't typed the name of the client yet."
* * * * Target.Offset(0, -1).Activate
How should i get the handle of the print dialog that comes up when i
print a file using ShellExecutEx()...?
"gshetty" <email@example.com> wrote in message
> How should i get the handle of the print dialog that comes up when i
> print a file using ShellExecutEx()...?
There's no straightforward way to get it, but this is a reasonable hack:
Use Active Accessibility (SetWinEventHook) to be notified of new window
creations, and identify the print dialog with either the classname or...compare
I have been reading this group for a while, however I am quite a
rookie in using of excel. I would appreciate if someone could help
with this issue.
I quite often have to compare two sheets (from different
workbooks-files, but with the same sheet name). Calculations are thus
updated time by time and I need to check where were the main
differences. Cells contain both values and formulas. I have found
through this newsgroup nice add-ins of Myrna Larson and Bill Manville,
and Rob Bruce. However I would need the macros to highlight only
significant differences (let's say fro...Transaction Logs #2
I've installed Exchange 2003 in my environment.and now there are a
lot of E00XXXXX.log files filling up my hard disk. I've read and heard that
after a fully backup those files would be erased, but it does not happen. Do
I need to configure something?
Tks in advance,
Please detail how you are performing a full backup. In order to purge the
log files, you need to be performing an Exchange-aware full online backup
(Exchange services still running). NTBackup on the Exchange server is
Exchange-aware. 3rd party products such as BackupExec are only ...CFileDialog customization #2
I have my own class I have derived from CFileDialog and I
want to filter the "Look In" combo box so it only contains
the folders I want the user to be able to navigate to.
I can easily gain access to the CComboBox but I'm having
difficulties filtering the contents. I can't really go
from the text of the item, because I really need the full
There is a trick with the list control of the file dialog
in that each item display has its PIDL stored in the lParam
of the list item. I was hoping there would be a similar
trick to the items in the combobox. I can do a GetItemD...Compare two files and update data from another file base on words in a cell separated by commas
I have two file with several colomns. I need to compare two Col B
fileA Col B of FileB as shown in example.
Each col have about 1000 rows.
Each row contains thousands of words and phrases separated by Comma.
As you can see from example, my data has soo many words and phrases
separated by comma in each row of two colomn A and B.
i Need to merge data of corresponding row from COLA$FileB TO
corresponding row of COLA$FileB
Also merge data of corresponding row from COLB$FileB TO correspondin...Posting Status #2
I have a PMPAY batch where the status is 'Receiving' these are configured to
post through to the GL.
See KB850289 for details on how to fix that.
> I have a PMPAY batch where the status is 'Receiving' these are configured to
> post through to the GL.
...extracting data from word to an excel spreadsheet
Thank You for any help. I am trying to find a way to
automate the extraction of data from a form in word2000 to
excel2000. The form is for HR at my company, we want to
track the check boxes that are marked in employee review
forms and bring totals into and excel spreadsheet. I know
this is going to involve macros, but I cannot find any
literature regarding vb in excel. I only find visual
basic and from any of the material I found, Visual Basic
and vb in excel are not compatible. Please help me and
steer me into the correct direction.
Thank You again!!
...On POS (not RMS) Adjusting Time Clock Defaults to Today's Date #2
When an employee negelects to time out and we make adjustments on a
subsequent day, the Time Clock display will default to today's date even
though the correct date is selected in the Employee's Time Clock window.
You have to select Save and Close, then reopen the Time Clock event, then
adjust the time out time to the correct date.
Anybody else notice this bug?
Dogtooth Coffee Company
...Outlook task #2
I am running Outlook XP Pro and Windows 2000 and I'm
wondering is there a way to arraign tasks by categories.
Any help would be appreciated.
Lawrence <firstname.lastname@example.org> wrote:
> I am running Outlook XP Pro and Windows 2000 and I'm
> wondering is there a way to arraign tasks by categories.
> Any help would be appreciated.
In the TaskPad, click View>By Category
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace.com is the domain.
I don't sp...2 workbooks
I have got 2 workbooks with a list of names. I need to find out if a name
appears in both books.
One of the workbooks came from a different source and the other one is a
report I ran from our database.
I need to find out whether the workbook from out of the company has got any
of our own names on it.
I am using Microsoft Excel 97 and am fairly new at this so please be gentle.
One way I did think was to combine the two workbooks into one and find the
duplicates but thought there may be another way.
Hi "queen on",
Assume that In book1 the names are in column A, s...Sheets Skip Macro
I have a lot of sheets in an excel workbook and a front summary sheet where
i have a vlookup formula that i would like to copy across to the right
however each column needs to change the formula to pick up the data in the
different sheets. Does anyone know a macro that will help me so that each
column copied across looks up in the next sheet.
Eg. 5 sheets - Daniel, Mark, Byran, Hugh & Paul
on the summary page i need it to go =VLOOKUP(ref,Daniel!F2:F17,col,false)
then =VLOOKUP(ref,Mark!F2:F17,col,false) then
=VLOOKUP(ref,Byran!F2:F17,col,false) then =VLOOKUP(ref,Hugh!F2:F17,c...Beginer
i got rid of earlier problem but i am facing one more new problem.
How to disable the default buttons present in the tab dialog.
i am attaching the code below. Can one tell me what mistake i have done?
sheet.m_psh.dwFlags &= ~(PSH_HASHELP); //trying to disable help button
i have searched in google and in msdn about this problem but i could not
able to find the solution.
Thank you in advance
>How to disable the default buttons present i...help with formula #2
Here is the answer of my question sent to Google on 2003-
07-15 00:41:33 PST :
""" Tim wrote in message:
> I've got a workbook with many worksheets on it(about
60). On 2 columns
> on a sheet in this workbook i have data and i need to
export this data
> to particular cells in other worksheets. For example on
> and B1:B20 on a worksheet is my data and I want to
export the contents
> of cells A1B1 to cells A1B1 in worksheet1 then data
from A2B2 to cells
> A2B2 in worksheet2 and so on.
> What is the easiest way to do this job?
> ...Removing Delegates #2
I'm trying to remove a delegate from Outlook 2003 and I get this "The
delegate settings were not saved correctly. Unable to active
send-on-behalf-of list. You do not have sufficient permission to perform
this operation on this object." I have checked and no one has a permission
to send-on-behalf-of list. Please help
I have seen this happen when the GC (Global Catalog) server is not
writable by you.
This may not mean much to you, but it will to your Exchange Admin.
Your Admin can either, point your system to a writable GC and/or
Remove the hidden delegates using the Excha...Insert / remove a row from protected sheet excel 2003 #2
I have my worksheet protected. I set the frist 5 rows all cells to Locked.
The rest of the cells are Unlocked.
When applying protection I ticked the boxes saying allow insert of row and
allow delete rows.
Yet when the protection is applied the icons / menu options for inserting /
deleting rows are grayed out. What am I doing wrong? Thanks!
I have two columns of numbers column A could be up to 3500 rows. Column B
may be more or less than 3500 rows. What I'm trying to do is see if any
number in columns "B" appears anywhere in Column "A", and if so we can just
highlight it in both columns. Actually I would want to be able to sort by
highlighted. so maybe add someway to sort by matched or unmatched.
I hope this makes sense.
In column C put...
=IF(ISNA(VLOOKUP($A1,$B:$B,1,FALSE)),"Not in B","In B")
In column D put...
=IF(ISNA(VLOOKUP($B1,$A:$A,1,FALSE)),"Not in ...Command Button #2
How do I create a command button in a worksheet and assign a command t
it using the control box tools, e.g., to sort a list of figures in
vijay22's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3411
View this thread: http://www.excelforum.com/showthread.php?threadid=53885
The macro recorder is your friend. Just use tools>macros>record when you do
your sort manually. Then, assign to a button or a shape. I do not recommend
Don...but there is no macro.... #2
Thank you very much!! I've now got it sorted - I followed the link and
found several little bits of code.
Thank you Thank you Thank you Thank you! :)
grrr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15715
View this thread: http://www.excelforum.com/showthread.php?threadid=272394
...The "Open" statement #2
I'm struggling with the syntax of the open statement, the helpfil
states it as
-Open pathname For mode [Access access] [lock] As [#]filenumbe
I know this makes me look thick but I've tried various things that hav
all failed, can someone give me an example of how this would look for
file named "carrier" that I wanted to input to as the mode?
carl0s66's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1662
View this thread: http://www.excelf...