Macro to delete an entire row with cells missing a specific chartacter #2
This is the script I am using to remove "IS"
Dim rng As Range
Dim what As String
what = "IS"
Set rng = ActiveSheet.UsedRange.Find(what)
If rng Is Nothing Then
So...my programming experience is a tiny bit limited, not sure how t
delete anything missing the IS as opposed to containing the IS.
understand in theory but my knowledge of syntax is the limiter.
Harald Staff Wrote:
> Hi Asf
> This is far more useful if you figure it out yourself, since you'r
> pr...Old Users in a single mailbox
I have had a request to forward all emails directed to old employees to a
single central folder that could be administered easily.. i am thinking this
is possible with exchange, but dont know how to achieve it.
I imagine i should have to create a new mailbox that admins can add to their
Outlook folder list, and then somehow make a list of all incoming email to
the server to certian addresses to be forwarded here..
any ideas guys?
Add all the email aliases to a single mailbox. Not very elegant but it
"Chris" <Chris@discussions.microsoft.c...Writing the DBF file
I have a trouble with writing a database to a file.
Here's my code:
// Write the file structure
dbfHdr.nVersion = 0x03;
dbfHdr.nNumOfRecs = m_ctrlList.GetItemCount();
dbfHdr.nNumOfBytesInHdr = 32 + (3 * 32) + 1;
dbfHdr.nNumOfBytesInRec = m_nFieldsLength + m_nFieldsLength +
m_nFieldsLength + 1;
dbfHdr.nReserved1 = 0x00;
dbfHdr.nIncmpltTrans = 0x00;
dbfHdr.nEncrypt = 0x00;
dbfHdr.nIndex = 0x00;
dbfHdr.nLangID = 0x00;
dbfHdr.nReserve...Excel missing file
I am a registered user of Office XP Pro. Excel will not start. It is missing a file. In the process of moving, disks in storage. Where can I go online to download the missing file? And, how?
...Hotsyncing Entourage X with Palm Tungsten E
Does anyone know whether it's possible to hotsync Entourage X for Mac
OS X.2 with the Palm Tungsten E, which runs Palm Desktop software OS
I'm currently using an older Palm handheld, which hotsyncs fine with
Entourage X. The Microsoft website description of the MS Handheld
Synchronization Software says that it works only with 4.0. I'm not
sure whether Microsoft considers 4.1 the same version or an entirely
different one. (Since all new Palms run either OS 4.1 or 5.0, I'm
hoping that I'm OK.)
Thanks! I'm eager to buy the Tungsten E to replace my old Palm, but
I...Time Clock integration with Office Accounting
Does anyone have a solution that can bring time clock information from POS
into timesheet entries in OA?
Do you mean POS or RMS. I have a solution that imports timeclock
hours/receipts and sales from RMS Headquarters to Office Accounting.
"Steve Jensen" wrote:
> Does anyone have a solution that can bring time clock information from POS
> into timesheet entries in OA?
...Retrieving deleted e-mails
A former employee deleted their e-mails before they
left. Is there any way to retrieve these e-mails?
Thanks for your time!
In the future just a suggestion put all users PST files on
the network drive and back them up nightly.
The only thing to do is look in the deleted folder if its
not there it is likely gone.
If its really important you can try your system admin that
runs the email server to see if they have anything cached.
>A former employee deleted their e-mails before they
>left. Is there any way to retrieve...sqlcmd and Error(s) to a file
sqlcmd File Names
sqlcmd input files can be specified with the -i option or the :r command.
Output files can be specified with the -o option or the :Error, :Out and
=========above lines are from the URL listed above=============
If I set this command, I get the desired behavior:
(The desired behavior being, if no errors occur, then that file is created,
however, it is empty, which is a great indicator for "nothing bad happened")
...Error after Outlook reinstall
This would pop up. Error - Could not obtain Microsoft Outlook version
Also, I can't install the microsoft updates to outlook because it says
because it doesn't know it's version.
So what version of Outlook did you re-install
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"SFKate" <SFKate@discussions.microsoft.com> wrote in message
> This would pop up. Error - Could not obtain Microsoft Out...Deleting transactions #2
Help! We had problems with one of our registers and we had to replace the PC
that we were using and and when we finally got all ready to operate we lost
everything that we had rung in (which we re-entered later) but now when we
run a detailed sales report for that day it shows all of the sales that we
cannot see in the journal but they show on the report, I want to delete them
but there is not a batch for those transactions only the transaction # and I
do not want to delete all of the transactions just the ones that are
incorrect for that day. I hope someone can help
You can v...Active X Controls Shrinking on Excel worksheet
I have a workbook and sometimes the ActiveX controls such as listbox,
options, checkboxes on the worksheet shrinks or expands while clicking on the
Does somebody has experirenced same kind of problem or somebody knows the fix.
The only to fix this problem is to restart the machine again.
Thanks in advance.
...Deleted Accounts still generating Failed Delivery Reports
Here is a strange one for you:
I send an email to email@example.com and it gets there and thats it.
I send a calender invitation to the same mailbox and it gets there. But then
I get a failed delivery report for former employees who used to use belong
to a Distribution list with the same name. I used to belong to that
distribution list and I do not recieve the inivitation. I am not really sure
if the failed delivery report is because of the Distribution list or because
the old users used to use the mailbox.
This happens from any machine using Outlook.
Needless to say those users are long gon...Excel 2002: Can I save all files by just one click ?
I have 10 working files in an active window.
There is no Save All button under the file menu.
May I know if I can save all the files at one click without having to exit
This delivers it in 2 clicks ...
Hold down Shift key, click File > Close All
Then click "Yes to All" in the ensuing prompt to save changes
Success? Celebrate it, hit the YES below
"Mr. Low" wrote:
> I have 10 working files in an active window.
> There is no Save All button under the file menu.
> May I know if I c...Refreshing a Microsoft Office Excel Chart Object
Can a Microsoft Office Excel Chart Object be refreshed by linking it
to an excel spreadsheet? The "chart object" is being copied from the
originating excel spreadsheet, using the special past function to make
an Excel Chart Object in a Word doc.
Use Paste Special, pasting it as an Excel Chart Object in the Word document. Use the Paste
Link button. Now it's linked to the cells of the original worksheet.
"DonC" <firstname.lastname@example.org> w...Big Problem! How to overload operator delete?
Big Problem! How to overload operator delete?
According to C++ standard, "A deallocation function can have more than
one parameter."(see 184.108.40.206); however, I don't know how to use an
overloaded delete operator. Let me use an example to illustrate this:
using namespace std;
void operator delete(void* p, const nothrow_t&)
cout << "Hello" << endl;
} // (1)
void operator delete(void* p, int a, int b)
cout << "World" <&...Modern.ttf font file requested
Hi, I have bought a Dell computer almost 2 years ago and it already had
the modern.ttf font file installed (no, I am not talking about the
modern.fon file). I have first reinstalled Windows XP without any
problems. When I have installed Windows XP for the second time and
thereafter, the modern.ttf file was not installed or it was missing
from the Windows XP installation disk. I have looked all over the
internet for a possible download link, but have not had any luck. Is
there a way that someone would send me the modern.ttf file or tell me
of a place to download the file or exactly what sof...Error with the Deployment Manager- access to the file \CRM\_xslfiles\1_Create.xsl refused
Configuration: CRM 1.2 on a SBS2003 with the rollup 1.2
I 'm unable to deploy my customization .
Indeed, as usual i created some new customization fields through the
deployment manager and i added them to the account form. No problem with
this. But when i launched the Deployment Manager for publishing it failed
after a while and it seems there is a problem to access to the following
..xsl file: ...\CRM\_xslfiles\1_Create.xsl.
Before i didn't have this problem. Strange?
In the event log i have the message:
"Erreur ProcessImportWorkItem : Access to the file
&...Out of office reply
I am trying to make an out of office reply. I know how to create the rule,
however I do not have any templates. When I tried to make a template I do not
have the option to save as.... a template.
I have tried to manually save it in the correct folder, however it does not
allow me to get to that folder via save as...
I have Outlook 2007
Thank you for any help or suggestions!
...merging files #2
My wife has a number of separate publisher files that she needs to combine
into a single file. There doesn't seem to be an obvious way to do this.. I
have looked at the "insert" menu and it looks like you can insert a blank
page but not an existing file…
How do I combine multiple publisher files into one document?
mlsred <email@example.com> was very recently heard to
> How do I combine multiple publisher files into one document?
Copy and Paste.
Ed Bennett - MVP Microsoft Publisher
On Fri, 6 Jan 2006 15:20:03 +0000,...Best way to delete duplcate records in a table.
I have a table that has duplicate records in it. I ran a duplicate query
that returned all duplicates.
What is the best way to delete the duplicates since you apprantly can not do
so while in the query?
Any responses are greatly appreciated.
Without any specific information about your table/fields, that would be
hard to say.
Give us a bit of info about the relevant fields in your table, and... how
you would determine that a record is a duplicate or not. Then we might be
able to find some logic (if possible) to assist in their removal.
As a very general rule though, d...Backing Up Outlook Files #2
Hi I would like to know how I could back up my Outlook
files and folders, so that I can trnsfer them to another
http://www.slipstick.com/config/backup.htm is a good place to read about
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
"Muhammad Yusuf" <firstname.lastname@example.org> wrote in message
| Hi I would like to know how I could back up my Outlook
| files and folders, so that I can trnsfer them to another
| Please assi...Hot Link
I am trying to remove screentips associated with a hyperlink in some cells.
I have tried editing in the hyperlink dialog box but nothing seems toremove
So far, my clumsy workaround is to copy the cell to create a duplicate,
apply the command "clear all" to the cell, then copy back the duplicate I
made using paste-special formulas, paste formats. There must be something
better than this...
Any helpgratefully received
...Outlook duplicating read/deleted e-mails
My outlook is dulicating every e-mail since last Monday
over and over again. What is going on?
What version of Outlook do you have? What sort of mail account(s)?
This posting is provided "AS IS" with no warranties, and confers no rights
"craig" <email@example.com> wrote in message
> My outlook is dulicating every e-mail since last Monday
> over and over again. What is going on?
> Any ideas?
...Can't open Excel files
I've never had this problem until now. When I try to open
either the Excel application or an excel file on my
desktop, a window pops up trying to install Windows XP
Professional w/Front Page and the application nor the
files will open. I have XP home edition. I can open PPt
and Word documents just fine. What's going on??
...Cannot freezr/delete messages
In Exchange 2003, I have several messages in queue that I
cannot freeze or undelete. These options are greyed out.
Properties shows no Message ID, no Sender, and the expire
date is now over a month old. However, in the queue
display screen (Queues), they show with a recipient.
Does anyone know how to clear out these "hung" nessages?
>In Exchange 2003, I have several messages in queue that I
>cannot freeze or undelete. These options are greyed out.
>Properties shows no Message ID, no Sender, and the expire