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?
...Can I use a Report expression for queries?
Is it possible to use the following expression that is used in reports on
Or some expression to get the result.
No. In your query, you can refer to text boxes on a form, but not on a
That's because of the way reports are formatted (sequentially.) Forms have a
current record, which identifies which value you want. Reports don't.
In the context of a query, there are other ways to get totals, such as
or a subquery:
Allen Browne ...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...Help with Html Help in MFC
I am using Visual Studio .net 2003.
I have created a CDhtmldialog. I also created a html help file using
Html help workshop. According to some source from web saying that I
can call this method: BOOL HtmlHelp( HWND hWndMain, LPCTSTR lpszHelp,
UINT uCommand, DWORD dwData ), directly from anywhere in my code. So I
include the htmlhelp.h and htmlhelp.lib to the project. But I don't
know how to call this method, since there is a another htmlhelp method
in Cdialog too:
UINT nCmd = 0x000F
Please give me a hand.
Thx in advance.
...Using ExecuteQuery to get Listing of Cases
I'm attempting to programatically extract a listing of Cases (similar
to the Cases listing in the Case Manager of the CRM app) using the
I can successfully extract Account and Contract info using
ExecuteQuery, but I've been unsuccessful in locating a sample of a
"QueryXML" string for listing Cases.
This is my latest attempt, but I'm not even sure if "Incident" is the
correct Entity for what I'm attempting.
<order a...OT: What tax software is everyone using this year?
TurboTax is too expensive ($40 + electronic filing fees), TaxCut is $30 and
included filing fees, TaxAct is $20 for the same thing.
Do Money 2006 Deluxe owners get any special offers on Taxcut?
to reply by e-mail remove 123 and change invalid to com
I'll probably use the Quicken free efile and then put my own data in the
free state online system.
"Aloke Prasad" <firstname.lastname@example.org> wrote in message
> TurboTax is too expensive ($40 + electronic filing fees), TaxCut is $30
> and i...Question regarding the simultaneous use of tape drives
a customer of us wants to use DPM instead of their current Symantec
solution. A question I coudn't answer was if they could use their 6-drive
tape-robot to for example backing up and restoring at the same time.
Thank you in advance for your support!
Christoph Schmidt || IT Consultant @ TOP TECHNOLOGIES CONSULTING || MCITP EA
If there 6 drives available in a library 6 tape related jobs can be run
in parallel at any time.
Praveen D [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christop...Using a Button to increment numbers in a database among other things.
I know that it is difficult to assess and solve a problem without
being able to look at it physically. Therefore I have included a
download link to the database I am working on.
I have been have some trouble with this database what I would like to
do is set up the logdb form to increment the lab number field with the
click of a button following a format of the last two digits of the
year "-" "0000", otherwise I would just like the field to be entered
with a format of "00"-"0000". I tried using a ...Entourage without HTML-display
I am new to the Mac and in my compay we use office:mac
Here's my problem:
I compose eMails just using text, I do not use HTML to compose Messages.
But if someone writes me a mail that is formatted in HTML Entourage shows
the formatted Mail. The only thing that I found so far is to not allow
"Complex-HTML" (whatever that means). But even when I turn off complex-HTML
Entourage shows HTML.
I was used (using Outlook Express 6) to turn off the display of HTML-Mails
Even Lotus Notes (v.5.0.9a) shows the eMails without HTML-Formatting.
And if I send an eMail f...Using Emit to Return a Value
I am trying to write a piece of code that can implement an interface's
methods simply by returning a specified value. I am trying to see how
Mock libraries are written.
For instance, I have a piece of code that looks like this:
What I want to be able to do is somehow implement ISomething.Foo so
that it returns "abc". However, I am having a hard time figuring out
the Emit code for taking an arbitrary object and incorporating it.
I've never want...I have SQL Server installed on my workstation, can I not use MSDE
I have SQL Server Developer Edition on my workstation and I don't
really want another instance of SQL on my box. Is there anyway for MS
CRM 1.2 to use my existing installation?
If you are referring to the MSDE datastore for the SFO client, then no, there
isn't. It will install a new instance, but many of the underlying files are
shared amongst the instances.
On 23 Apr 2004 10:07:41 -0700, email@example.com (Shawn Ramirez) wrote:
I have SQL Server Developer Edition on my workstation ...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 <firstname.lastname@example.org> 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" <email@example.com> д����Ϣ����:Oc7j%23OcAFHA.612@TK2MSFTNGP09.phx.gbl...
> I have a MFC application host a webbrowser(IWebBrowser2).Basiclly ,I
> hope ...How can i use DAO Application
I have a software which is made in MFC and connected with MS Access 97
through DAO(Direct Access Object via MS jet Engine).
Now i want to use same software for Postgresql and wanted to connected
it through ODBC.
Problem is that Old software has been developed for DAO,all main file
like ,recordset,view doc r made for DAO.
If i want to make it in ODBC,my classes like Set ,view Doc and other
would be generated for ODBC.
I dont know any option to use same software,
Should i write whole software from the begining?
I need ur help.
...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" <firstname.lastname@example.org> 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...Problems with Using Word as Email Editor
We use Hummingbird DM 188.8.131.52 for our document and record
management. When using this program, it has a problem
with Outlook using Word as an Email Editor. When this is
turned on, it seems that Outlook opens a different
instance of Word. When you try to open or create a word
document, you lose the ability to save or print. These
features return to normal when you uncheck Word as an
Email Editor in Outlook. I have heard that Microsoft was
taking this up with Hummingbird to have them fix it. I am
just wondering if this was to be resolved, or if it is
Hummingbird's problem to ...Using OUTPUT TO in VBA, then how to modify the XLS from Access?
I'm using the simple "OUTPUTTO" command to send a query over to Excel,
however we will have many users and we would like to programmatically add the
header rows, date printed, turn on the auto filter and freeze panes, all of
which I can do within a Macro in Excel, but how do I call that macro to run
from Access and How to run it on the file that they just created?
DoCmd.OutputTo acOutputQuery, "MainRptWUser", acFormatXLS, , True
> I'm using the simple "OUTPUTTO" command to send...Inability to connect with exchange server using entourage
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
I have a 2008 version of entourage that I connect with my exchange server. I added a ms office home edition to my computer, and now I am unable to connect to my server. The error message now says that I must upgrade to a std edition of office in order to connect to an exchange server. If my previous version of entourage would connect and it is still on the computer, why won't it do it now with office installed? Any advice? <br>
What version of Microsoft Office 2008 entourage did you down...How to best imitate using Word macros in Outlook 2007
In my previous Office 2003 setup, I used Word for email editing,
allowing me to use Word macros to generate common sections of text in
the emails, etc. I see that in Office 2007, the email editor does not
support the Word object model. How do I program a macro that would
allow me to enter a certain text in the Outlook message under 2007?
What happens when you try using the Outlook Macro editor?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After furious head scratching, AMolotkov asked:
| In my previous Office 2003 setup, ...