VBScript Issues (and the missing auto configuration)
I used the script from the MS KB site to add a corporate sig to all
outgoing SMTP email. It works when my AV software sends an alert and it
works when our sole Mac user sends email via Outlook Express. This may not
be related but, when I use logon scripts to map printers, etc, I get a "no
such printer" (paraphrase) type of error when I know that the printer URL is
correct. The printer mapping at login script worked once - when I wrote it
and tested it. Running on the same machine, nor any other on the network
now, no luck.
Back to the sig issue, none of th...Averaging numbers but ignoring < and
I have a column of data as illustrated below than contains numbers, blank
cells, dashes and < entries. Is it possible to average only the numbers
ensuring that the divsor is the number of cells that contain number entreis
rather than all cells containing an entry (eg for below example answer should
On Wed, 23 Feb 2005 06:29:03 -0800, KIM <KIM@discussions.microsoft.com> wrote:
>I have a column of data as illustrated below than contains numbers, blank
>cells, dashes and < entries. Is it possible to average only ...File Association problem
I'm using Windows 98 Second Edition and VC6.0.
I have an mfc/sdi app which runs fine; both its debug and release
versions, when executed using Run, its shortcuts, the Start button, etc. I
used Install Shield to install the release version of my app.
I have associated a particular file extension with my app and verified
this by going into Windows Explorer / View / Options / "File Types" tab.
The "open" command is shown as a valid command for this association.
The problem: When I'm in Windows Explorer and try to open a file that has
the associated file ex...Average of Averages
Another seemingly simple process which I can't figure. :)
I have a list of averages, and I want to get the average of them.
I need a formula to average something like the above.
=AVERAGE(A1:A4) is one possible solution.
Hope it helps.
goober's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19838
View this thread: http://www.excelforum.com/showthread.php?threadid=513937
It really depen...Need to extract XML or SGML entities from a Unicode text
I'm working on a list of japaneese entities that contain the entity,
the unicode hexadecimal code and the xml/sgml entity used for that
entity. A unicode document is read into the program, then the program
sorts out every doublet and the hexadecimal unicode code is extracted,
but I dont know a way to find the xml or sgml-entity equivalent to the
unicode code. Anyone who could give me a pointer?
> I'm working on a list of japaneese entities that contain the entity,
> the unicode hexadecimal code and the xml/sgml entity used for that
> entity. ...2 data files with same address....
When looking at the acct. settings for my data files, I noticed I have two
Personal Folders showing, each with the the file name:
Outlook.pst\Documents and Settings\Lenovo User\Desktop\Company Name. One is
When I click on the "open folder" button, I get the same file in the above
referenced folder on my desktop.
Why would I have two and should one be deleted? BTW, I use OL2007 and Win
XP Pro SP 3.
This would indicate a corruption in your mail profile. You can recreate it
via the Mail applet in Control Panel.
See http://www.how...Excel view backwards
I have an user running Office 2000 and when she starts a new workbook her
view opens up backwards ie the row were it says A-ZZ that is usually left to
right is right to left and her column numbers that mark each column are on
the right side instead of left side, Anythoughts. I have looked for the
template that the new workbook access but cannot find it in the tree to
replace the template.
any help is appreciated
Goto Tools>Options>International tab>Right-to-left
"Christine" <Christine@discussions.microsoft.com> wrote in message
news:CCC879...Cursor position doesn't stay put when revealing hidden text
Word 2003--In a long document with lots of hidden text that codes many table
of authorities entries, when you press "show hidden" the placement of the
cursor stays at the same position on the page instead of staying with the
word I left it on. How can I make the cursor stay where I left it?
Janet N.--Legal Sec''y
Hi - I am trying to find a setting that will enable the file browser to
autocomplete the file path when you are trying to open a file. my hard drive
crashed so all my previous settings were blown away. It used to be that when
I started opening a file, if I started typing in the browser window, the file
path would auto complete.
for example, if I were going to "c:\my documents", as soon as I typed
"c:\my" then the rest of the c:\my documents string would appear in the
browser would appear automatically. Does anyone know how to enable this
feature? It u...Excel Autofilter Copy and Paste with Changing Values
I have used a macro written by Ron de Bruin entitled “Copy5” that uses
Autofilter to find, copy, and paste rows from one worksheet to another.
My search criteria are called out as follows:
My_Range.AutoFilter Field:=2, Criteria1:="=" &
My_Range.AutoFilter Field:=3, Criteria1:="=" &
My_Range.AutoFilter Field:=4, Criteria1:="=" &
My_Range.AutoFilter ...Outlook 2003 Exchange Caching
Anyone know where the exchange cache file is created on
the outlook 2003 client machine?
It's an OST file. Search for that. You may need to enable showing
hidden and system folders to be able to see the file in Windows
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
<email@example.com> wrote in message
> Anyone know where the exchange ...averaging less than values
How do I average a column of numbers where less than values are calculated as
In the average I want the<2 to = 2. So the answer should be 3
Assuming source data as posted in A2:A7
Paste this in say, B2,
then press CTRL+SHIFT+ENTER to array-enter the formula:
Adapt the ranges to suit
Downloads:17,500 Files:358 Subscribers:55
> How do I average ...How to open publisher 95 file in publisher 98
I have Publisher 98. I was given a file to work on that was created in
I cannot open it, I don't understand why newer version files cannot open
older ones. Is there any help out there?
Are you using Norton anti-virus by any chance?
MVP Microsoft [Publisher]
"westpix" <firstname.lastname@example.org> wrote in message
>I have Publisher 98. I was given a file to work on that was created in
> Publisher 95.
> I cannot open it, I don't understand why newer version fi...insert a JPEG into EXCEL 2002
Hello - I was asked to "pretty up" an Excel invoice for work and need to
place a JPEG into the file. I know I can't insert a picture into the
header/footer with Excel 2002, but can't I just insert it into the body of
the file? In Excel Help it simply says to click on Insert Picture, but for
some reason the Insert Picture option is ALWAYS greyed out. Any suggestions?
I would REALLY appreciate it!
You can insert a picture into the header / footer with XL 2002. Go to
File>PageSetup. Select the "Headers / Footers" tab and select "Custom
...greyed out files
I have just transfered files from an old imac to a new powerbool (office =
office 2004), The flles on the new computer are "greyed out". any ideas?
Tom wrote :
> I have just transfered files from an old imac to a new powerbool (office 98 to
> office 2004), The flles on the new computer are "greyed out". any ideas?
Did you use a MS DOS formatted disk to do the transfer? Or through an email
software that puts files in a Windows format? This could be the reason (I
did the same), as the "Creator" and "Type" of your files seem to have been
l....PST File won't decrease in size
1. I had over two years worth of e-mail in my PST file
that made the file size aproximately 850 MEGS.
2. I needed to shrink file size.
3. So I deleted in Outlook ALL MESSAGES and only left
contacts. This should have decreased the file size of
the PST file. However it has not.
4. What can I do now to decrease the file size of the
Reduce the size of a data file
A data file is a Personal Folders file (.pst) (Personal Folders file
(.pst): Data file that stores your messages and other items on your
computer. You ca...IF=text then go to...
I've this trouble...
I want that if cell A1 value of sheet1 is equal to one word (example X) then
go to cell A2 of sheet2.
Is it possible?
Formulas don't do the "goto" stuff. They retrieve values from other locations.
That's about it.
> I've this trouble...
> I want that if cell A1 value of sheet1 is equal to one word (example X) then
> go to cell A2 of sheet2.
> Is it possible?
No, there is no formula that will do this
Bernard V Liengme
Microsoft Excel MVP...Scanning issues
We receive items on purchase orders by scanning our vendors UPCs. When we do
this, we have one person do the UPC scanning and another person watching the
computer screen to make sure each item goes in okay. Not the most efficient
system. Is there anything we can do to have the computer give some sort of
audible warning if the UPC isn't recognized or the item wasn't on the
not a total solution but scanners can be programmed to allow only certain
types of barcodes.
this may help. not sure about the pc end because I don't use rms.
"Kris"...Insert a file path as a hyperlink
Is there a way to browse and select the file path and
insert it as a hyperlink like in Outlook 2000?
Like, in what application?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Brooke asked:
| Is there a way to browse and select the file path and
| insert it as a hyperlink like in Outlook 2000?
First, you have to select HTML from the Format menu. Then, type or past...Averages
I have an interesting situation. I basically inherited an older
database that is used to enter dates, usage and charges for accounts.
The situation is that we are attempting to do averages filtered by
account, and averaged against the number of days that data has been
entered. So, for example, we had 7 months of data entered, our query
should total the number of days in the seven months (x), then average
that with the total usage number (y). This data currently resides in
the same table labeled "data" in the form of from and to dates
(6/1/1999 to 7/1/1999) and usage (32...Exchange 2003 and Win2003 problems with mailboxes
I installed Windows Server 2003 and Exchange 2003 2 weeks ago. After the install Internet email would not come through, I fixed that problem but after the fix there are 6 emails in the server that keep downloading into the mailboxes. you can delete all of the new emails that show up but they start downloading again and again. It seems as if the email never leaves the server. I have checked all of the Outlook setting and it is to remove the mail from the server (not leaving it on the server for X days). When I go into OWA you cannot delete the emails at all but they only download once. If...According to posts on this newsgroup... importing a .pst file is a 'no no'
What about the Files & Settings Transfer Wizard? Will this method corrupt a
Got xp home on a slave drive.
Got xp pro freshly installed on a master and I want to get outlook over FROM
xp home on the slave.
Same copy/version of outlook on both drives.... slave will be formatted once
all is tested.
Importing is bad but the FASTW is not an import. It simply places items
where your programs will likely find them, such as your .pst file, among
other attributes (like accounts settings transfer, etc.)
Milly Staples [MVP - Outlook]
Post all replies to the group to ...Removing shadowed Text boxes
I'm using Excel 97 to revise a document which contains shadowed text boxes that I can't select. They span across cells and aren't aligned to them. I've unprotected the workbook and sheet but I still can't select them to get properties, or to modify. Can someone help identify what they may be and/ or how to revise/ delete them
Thank you in advance.
Don't know if I've seen this one. Try holding Ctrl, as you try to select it.
Or try turning on the Drawing Selection tool (a arrow toward the left of the
Drawing toolbar). Be sure to turn it back off when you'...How can set to default the Format Text with No Spacing in Word / Outlook 2007?
I am using Office 2007 package, including Word 2007 and Outlook 2007.
I have noticed that when I open a new document (or email) my Word always
deafults to "Normal" in Format Text, which means that there is a one-line
space in between each line that I write text in Word or Outlook.
How can I set that both Outlook and Word always deafults to "No Spacing"
between the lines of text. I assume that whateevr setting I have in Word
are automatically used by Outlook when I open a new email or select reply to
Michael B. <mystic02removethisplease@ver...OWA Front-End Server Issues
I have setup a front-end OWA server to allow remote users to read their mail
remotely (obviously). The problem I encountere is as follows; the OWA is on
a DMZ and can be accessed from the internal network. When connecting to the
OWA server from the outside (public ip) I cannot even connect to the site.
Here is what our network looks like:
|_____DMZ-----OWA Front-End (Using NAT IP 208.xxx.xxx.xxx
| Other Web Servers
Internal Network (Win2k3)
1 Exchange2k3 Ent. Server