How to Filter cells and save the file with certain criteria?
Hello. I have a Excel file that contains a large list of Tracking Numbers.
The tracking numbers are from two sets of order types- Internet orders and
Orders that are from the Internet are matched up with a order number such as
"5678". Orders from the mail-order side are designated by initials "MO".
So in Excel it'll look something like this:
Is there a way to eliminate the Mail-Order rows and save the Excel file to
...file send to as attachment outlook 2007
When using in word or excel command "send a copy of the document in an e-mail
message as an attachment", outlook creats a new e-mail message with the
document attached as it should be done. Then I add text in message body, and
send the mail. It arrives only with the attachment. The text in message body
disappears. This happens only if I work in outlook chache mode. My os is
winXp Pro, and my server is SBS 2003. It used to work correct, until somthing
happened. Any idea to solve?
...MFC to open IE
What is the best programmatic way to open a URL explicitly using IE
(assuming IE is installed on a machine, but not assuming as a default
It would appear that the easiest way to do it is to just run (via
ShellExecute, CreateProcess or whatever function you choose) the following
Internet Explorer (at least as it is installed in my windows XP SP2
machine) will take a URL as a parameter and when passed a URL with no other
parameters, it opens that URL in a window (in my case, a new IE window will
be...Dynamic List Box using VBA
I wasn't really sure how to phrase this one -- this isn't your Typical
I have a SELECT statement which queries SQL Server 2005 and displays the
data in Excel.
Let's say that a database lists products that have been delivered to 4
different cities, on 3 seperate days -- without knowing (in advance) the
delivery dates, how could I create an input/drop-down field to allow the
user to specify a particular date? I envision something like this:
VBA code produces a list box of delivery dates based on a particular product
and city. The user selects a delivery date ...If I accidently replace a saved file can I retrieve the old file?
PLEASE write your question in the body of the post and NOT just the subject.
Have a look here: http://dts-l.org/goodpost.htm
Interim Systems and Management Accounting
"kamabiv" <email@example.com> wrote in message
...Best Practises setup with AD or File Server
We have a scenario where we are retiring out dedicated backup server.
Currently we are using Symantec Backup Exec 11d. However, instead of
replacing the dedicated server, their is a suggestion that I use existing
servers for Backup Exec
Are their known issues installing backup exec on a DC which also holds FSMO
roles (PDC etc)?
The other option is to install backup exec (and tape drive) on a file server
which hosts the H and S drives.
what do you think?
I would use the file server. Presumably it is being accessed during the day
when no backups are running. The b...Can't open shared access database with double click from explorer.
While trying to diagnose Access 2007 corrupting Access 2000 databases, I've
come across a situation where if I try to double click an MDB file on a
shared network drive, nothing happens. Access doesn't start (either with
access 2000 or access 2007).
However, if I wait til I get the "Open File - Security Warning" on one
machine, then double click it on the other, then I can open it on both
In addition, I can always open it from the open menu in access.
Obviously something to do with the open file warning is going on here. Is
there any way to set the regist...Fuse box stencil?
I need to create something to help me identify the switches in my home's
fuse box. (I set off the smoke alarm at 11:45 p.m. New Year's Eve because I
had a candle burning almost directly under it for several hours.) It was
late and I was desperately trying to figure out which switch controlled
which circuit. That blasted noise and the knowledge that my neighbor had to
hear it didn't help.
Surely I'm not the first person to do this. And if I am, so be it. I'll
start from scratch but I'm hoping someone can help me. :-)
MVP Microsoft [Publisher]
Please could someone advise how to stop the mail opening for a moment,before
This seems to imply especialy on spam that I have read the message.
The fact that Outlook shows the msg as being read has no connection with the
sender, unless you send a read receipt
"DEACON SCREWS" <firstname.lastname@example.org> wrote in message
> Please could someone advise how to stop the mail opening for a
> moment,before I delete.
> This seems to imply especialy on spam that ...Starting with a new pst file
I would like to start with a blank pst file. I want to start again with no
contacts, no emails, no appointments.
How should I proceed to make this?
Thanks for your help,
Olivier Verdin <email@example.com> wrote:
> I would like to start with a blank pst file. I want to start again
> with no contacts, no emails, no appointments.
Assuming Outlook 2002/2003, since you didn't think it important to mention
your Outlook version, click File>New>Outlook Data File, Browse to where you
want the new PST (or accept the default), give it a name ...Intercept file download in IWebBrowser2
I have a MFC application host a webbrowser(IWebBrowser2).Basiclly ,I
hope when user click a file download url(href="test.zip"),I can intercept
the download message and process it by my own download component instead of
Is it possible?
Any article will be help.
"L.J.S" <firstname.lastname@example.org> д����Ϣ����:Oc7j%23OcAFHA.612@TK2MSFTNGP09.phx.gbl...
> I have a MFC application host a webbrowser(IWebBrowser2).Basiclly ,I
> hope ...Voting Buttons -- Missing drop-down box in Tracking tab
I have a user on Office 2003 who uses voting buttons in Outlook.
She claims that on the Tracking tab of her sent message, a drop-down box
should appear at the right side of each user's "response" column showing the
voting options -- for her to manually populate if the respondent verbally
replies to her.
Our outlook 2003 does not have this. I can find nothing on it. What is she
talking about, and how can I set up this feature for her?
I think she's wrong. That function exists in a Meeting's Tracking table,
not a vote related tracking table from an em...accidently deleted file
Somehow I deleted the file MSMONEY.EXE. It seems I did
prior to a restore point on my system. Is there anyway to
get it back? Thanks....Inker
Reinstall Money from the CD. It won't affect your data - that is kept on the
Microsoft MVP - Money
"Inker" <email@example.com> wrote in message
> Somehow I deleted the file MSMONEY.EXE. It seems I di...how can I get a publisher file to acrobat reader
I have a Regestration Form created in publisher 2003. When a confrence
addtendee signs on to our web site they need to be able to click on a file
(acrobat reader) Hopfuly, and download it and print it so they can fill out
the form and mail it off. (I say acobat reader because that seems to be the
most common way it's done. I dont see an export in publisher or a inport to
acrobat. how can i make this happen
You will need a third party program to create the pdf file. Adobe Acrobat
but it's spendy or a freebee i.e., Primopdf or another commercial program of
modest cost, i.e., PDF-XC...put files together
I have in a directory "summary" some 800 files with a number for a name,
like 8, 23, 44, 124, 2045 up to somewhere in the 2500's. There is no list of
all those file names.
Each file is a workbook with only one sheet called "ABCD". I know that the
last cell used will be a cell in column H. I also know that the content of
that cell will be ==== (4 to 7 times =). Column H will contain text, blanks
(empty cells), numbers and other characters (like f.i. =). The number of
rows used will be at least 6 and could be as much as 200 or so (25 is
I need ...Hide toolbars when file opens
I have created a file for people to use to get quotes. When the file
opens, I do not want them to have access to any toolbars. How can I
hide these when the file is opened, but only for this file - not any
others that the user may subsequently open. All that they may need to
do, is print the page out after getting a quote.
You can use this in the Thisworkbook module Rob
Private Sub Workbook_Activate()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Private Sub Workbook_Deactivate()
Dim bar As C...Permanently open Group Schedule
Is there any way I can configure things such that a Group Schedule is
permanently open, i.e. when I exit and restart Outlook?
Not that I know of in any version of Outlook that supports group =
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Chris Mitchell asked:
| Is there any way I can configure things such that a Group Schedule is
| permanently open, i.e. when I exit and restart Outlook?
...excel opens up looking like it is in ms dos
how can I get my excell to stop opening up looking like it is in MS-DOS mode.
I get an error message that wants to send the info to microsoft, when it hit
yes send or no don't send it then shuts down.
what exact error message do you get and does this happen all the time for
> how can I get my excell to stop opening up looking like it is in
> MS-DOS mode. I get an error message that wants to send the info to
> microsoft, when it hit yes send or no don't send it then shuts down.
Sounds like you...cashbook management enquiry screen is too slow loading
When opening the Cash book management enquiry screen after selecting the
checkbook, the system begins loading transactions which can take upto an hour!
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbro...Problem with .rc files in VS 2005
I have several projects that were created with VS 2003. These are MFC based
applications with .RC files that contain localized strings. Some of these
strings are Japanese, Korean, and Chinese encoded in MBCS. These projects
work fine in VS 2003.
I converted these projects to compile with VS 2005 and if I bring up the
resource editor to view or modify the string resources, VS 2005 will modify
the Japanese, Korean, and Chinese strings. It will replace the characters
with all "?" question marks.
Is there some setting that I need to set to prevent VS from modifying my
string...Configure a shortcut file programmatically?
Under program control, I want to change the paths to point to a database on
the user's local drive. From within Access, does anybody know how to do
Are you saying you want to create a shortcut file? Take a look at my May,
2004 "Access Answers" column in Pinnacle Publication's "Smart Access". You
can download the column (and sample database) for free at
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"David Portwood" <Mondrogan@yahoo.com> wro...Outlook 2003 PST file issues
I created a backup.pst form Outlook 2003. I also copied
the outlook.pst file onto a cd. I had to format my HD and
reinstall Windows XP and Office 2003. When I try to open
either of the two PST files I get an error message "The
file C:\path info\backup.pst is not a personal folder
Can anyone please help me. All of my important email data
is in there. I followed the instructions on the Microsoft
site for backing up the file, not it won't open.
Did you remove the read only attribute these files acquired from being on a
"Brad&...Outlook 2003 attachement not opened
I've just installed Outlook 2003 and I have this problem: a friend sent =
me an e-mail containing an attached e-mail message (signed, if it =
matters), and Outlook wouldn't open it saying "An error occured in the =
underlying security system".
How can I open that file? Note that that file has a ZIP file attached, =
so this could be the problem.
Thanks in advance,
...Outlook SLow #3
ANyone know why Outlook constantly freezes for about 10
seconds at random times? Will service pack 1 fix this??
>ANyone know why Outlook constantly freezes for about 10
>seconds at random times? Will service pack 1 fix this??
>believe it or not, spyware may be causing the problem.
Try running a program to delete any spyware on the system.
This may be one reason.
...Adding attachments to msg-files
I have a big problem regarding editing of MSG-files.
This is what I do:
1. Open a MSG-file from Windows Explorer
2. Add an attachment (i.e a Word-document) to the email.
3. Save and close the email.
When I re-open the MSG-file the attachment is missing! Instead Outlook has
created a copy of the email in my inbox(!), and that copy contains the
This has been tested with different mail-formats (HTML, Plain Text and RTF),
and with Outlook 2000 and Outlook 2003 with the same result.
Can anyone explain this behavior? I would call this a bug in Outlook, since
changes you believe you ar...