Excel 97 #3
what is the Red triangle in a cell called, I believe it is
some type of handle.
Is it in the top right corner?
If yes, then it's probably a comment indicator. Let your cursor linger over
that cell. If you see a comment, that's it.
> what is the Red triangle in a cell called, I believe it is
> some type of handle.
The red triangle indicates someone has inserted a comment
to give you information.
Move the mouse over the cell to show the comment.
Right- click on the comment to edit or delete it.
>----...Help with using data
I would really appreciate some help with extracting data from
Outlook. I have been building up a database of clients/prospectives,
these are in various categories. I would like to extract/search on
various fields as well as my own categories, all i can do with export
is extract the whole lot to a tab delimited file. Or export categories
to an rge file which I can't use.
Any ideas out there?
Outlook's Search doesn't suffice?
There are 3rd party search applications that might help.
What sprcifically stops you from exporting to a format other than TSV? There
are other...I see that Publisher 97 can be upgraded to 2003; what about 98?
I have Publisher 98 but want to upgrade to 2003. On the sales page it says
that one can only upgrade from 97 to 2003. Is that right?
Publisher 98 qualifies...
Mary Sauer MS MVP
"Gigi" <Gigi@discussions.microsoft.com> wrote in message
>I have Publisher 98 but want to upgrade to 2003. On the sales page it says
> that one can only upgrade from 97 to 2003. Is...GDI Help Please
Windows ME, HP 970CXI Printer, Publisher 2000
Keep getting the following error message when I try to
print from Publisher:
Mspub has caused an error in GDI.EXE.
MSpub will now close.
If you continue to experience problems, try restarting
I just installed the latest driver that I received from
HP,and I keep getting this problem. It's getting very
fustrating. Can anyone help?
Update your video driver and your problems should be over.
Next time buy a quality brand of printer, not a lemon brand.
The US should free all those
illegally held prisoners they are
tortu...Help with simple arithmetic
i have the following declaration and piece of code
Dim netProfit As Long
netProfit = (7364 - 2298) * 20
Why does it fail with "runtime error 6" Overflow.
the result should be 101320, should be okay for Long right ?
Any help appreciated.
Message posted from http://www.ExcelForum.com/
The right hand side involves only integers, so it evaluates as an
integer expression (which overflows). The final result (if it hadn't
overflowed) would then be coerced to long.
To perform the multiplication as a long instead of an integer, at least
one of the numbers must be ...MS Access 2003 and Outlook 2003/Website
I'm working with someone developing a website for our company, and had some
questions. I've read alot of resources and articles on how to integraste
these thigns, but can't seem to get to the right spot.
What we want to do, is have a webpage, that a customer can access, fill out
a small form for RMA requests, then either email that to a specific email
address which would be filtered to a folde rin outlook, and then have the
Access database look in that folder for new emails and add that info in to
the db. I have that part partially figured out, but another option we were
...Option Buttons Help
I hope I can explain my problem if you need further details please advise:
I have 6 Option Buttons (Form Control) on a worksheet, when I click
(Checked) any of them the rest automatically unchecked themselves, how can I
modify them, since I want to create two groups of 3 Option Button on each
group so if I click (checked) any of the Option Button in a group of 3 it
does not unchecked any of the Option Buttons on the other group of 3?
Thanks in Advance
Put each group into its own groupbox (also on that Forms toolbar).
> I hope I can explain my problem if you n...HELP! Adding Account Features in Money
Any Money users here? I had been using Quicken for ten
years and it does not have a feature to add a VUL
(insurance) policy where I have "investments" to track in
the policy. Does Money have that feature? Please help. I
am considering in switching to Money if it does.
In microsoft.public.money, Adelfa wrote:
>Any Money users here? I had been using Quicken for ten
>years and it does not have a feature to add a VUL
>(insurance) policy where I have "investments" to track in
>the policy. Does Money have that feature? Please help. I
>am cons...Macro Help Please excel 2003
I need a button so that when pressed it exports the data from the cell range
sheet 1: A21:S81, it also exports the info from the same range A21:S81 on
sheet 2 to an external excel workbook.
I need it to export all the data onto sheet 1 of the external workbook, and
each time the button is pressed it needs to find the first available row of
the external workbook and copy over, this is so that all data is always saved
on a massive long list.
Neil. let us stick on to the original post. I have posted a response for your
"Neil H...Outlook 2002 on XP
I attempt to open Inbox email with no attachment and
okay. I attempt to open Inbox email with attachment and
Outlook appears to hang in send/receive mode. I have to
use task manager to end app then XP generates the error
send report. Then I have to restart PC. Any ideas why
...accessing address book in Outlook 2002
I recently had a fire and had to get a new computer. My
ISP is MSN dialup. My new computer has Outlook 2002 and
I want to use this instead of Hotmail to access my mail.
I now am able to send and receive messages through
Outlook but I cannot access my address book that I had
with Hotmail. I need help b/c i have 3 pages of
You have to use your browser to access the web based
address book at Hotmail. Outlook is better used for POP
>I recently had a fire and had to get a new computer. My
>ISP is MSN dialup. My new computer has...MSCRM API failing with User defined fields.Help !
Iam programming in ASP.NET for my company's MSCRM. I use MSAPI to retrieve
and update field values in MSCRM. Iam able to do it with ease by programming
in VB.NET with the MSCRM object library.
strUpdateXml = "<account><name>Steve
CRMAccount.Update(UserAuth, RECID, strUpdateXml)
It works fine for the normal MSCRM fields
LATER, I created USERDEFINED fields in MSCRM. ( with the Deployment Manager
and published). The new field created can been seen in...Need help editing budget
In many catagories of my budget, the budgeted amount
includes a billed amount rather than only what I
budgeted. When I go to edit budget, I highlight the area
I want to change and a copy of the reoccuring bill shows
up. What am I doing wrong?
...DataSet Question-Please Help
I need to compare the count of an amount of matches in one column to a match
of a dataset in 2 columns- An example is best:
Column 1 Column 2 Result
2 1 1
2 1 1
2 1 1
2 1 1
3 4 blank
3 5 blank
So in looking at column 1 and 2 if the count of column 1 equals the count of
column 1 and 2 matching then the new column equals co...help with lookup formula (SHEET 1 attatched)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...need help managing volume size
I use an array for automated daily backup,
I have set up three folders on the array A,B, C.
The array stops accepting data after it reaches a certain level so
backups are not executed until I notice and take action.
I also wish to keep the size of each folder at a certain level.
Right now I am merging files across the array initially loading files
into the first folder (A) than moving to the next (B), then the last
(C), then purging from the last folder (C) using a program called
delinda which uses the files' creation date as the trigger for merging
and purging....Query--using Access 2007
I have a tblAddress table with a lookup field called TypeofAddressID.
A company may have many addresses with different TypeofAddressID—such as 1 =
Business, 2 = Mailstop, 3 = PO Box, and so on.
I need to pull out TypeofAddressID # 1. Then if a 1 is not available, give
me the type that is (which may be the PO address or Mailstop).
I tried DLookup, Xor, and IIf([TypeofAddressID]=1, 1, IIf([TypeofAddressID]=2,
2, IIf([TypeofAddressID]=3, 3, 4))), but it is listing all addresses per
company instead of either or.
Message posted via http://www.accessmonster....Refresh problem for the size grip with Windows XP style #2
I have a dialog application with a scrollbar size grip. On Windows XP with
the visual style, there is a refresh problem for the size grip region when I
move the application out of the screen; only if I go to the bottom of the
screen. It's OK if I go out by the right side.
Without the XP style, everything is OK. I have noticed the same behavior
Do you know how could I solve this problem?
Any ideas will be appreciated,
It's a known problem in XP (non-client area is erased incorrectly between
scrollbars). Will it ever get fixed? I would not bet on it.
&qu...An error occured and this feature is no longer functioning properly. help!
This is what I get when saving my workbook. also it offers install some
soft to repair the "feature". A runtime error happens when installing.
I don't understand what feature is it about.
Before that I made a copy of this book in csv format (when saving as
csv, I also got a message that some features will not be compatible
with csv format and I agreed because I guessed it was about a command
button in the worksheet). When I opened xls book next time and tried to
save it, it gave me the subj message, but saved after all in the end. I
wonder if it is likely to cause me problems i...HELP WITH A MAIL MERGE
...Setting excel to landscape and setting print area from access
I have an excel file that I create from access and I was wondering if there
is an easy way to set the page setup to landscape and to set the print area
width from access.
Is there an easy way to do this?
I created a macro with the excel macro recorder but I am not sure if I can
somehow use this code to have access do this. Any direction on this would be
.PrintTitleRows = ""
.PrintTitleColumns = ""
ActiveSheet.PageSetup.PrintArea = ""
With Active...Vista start-up & networking w/ XP
I have two questions if someone can assist or at least direct me where to
find some answers. Where is the "correct place" to store start-up scripts in
Vista and Windows 7? Traditionally in Windows XP this is done using local
policy editor and setting the startup/shutdown scripts. Because I have Vista
Home Premium, this feature is disabled. I know this is probably stored some
where in the registry, but I am not sure where this is.
The second question has to do with networking. I have two machines one
running Vista Home Premium and the second is a Windows XP machine. I h...Hyper V, SBS 2008, Server 2008, XP
I have a a Dell PowerEdge T610 with the following config:
16GB of RAM
Dual Quad Core Processors
RAID 0 - Two 500gb 10,000 rpm drive (500 gb total)
RAID 5 - Three 500gb 7,200 rpm drives (1 terabyte storage total) -
with on addition Global Hot Spare drive
My question is how best to setup the Windows 2008 Server Hyper OS as
well as the Virtual Machines (SBS 2008 Premium, Windows 2008 Server
for SQL, & Windows XP) on the Hard Drives and Arrays.
My thinking was the following: put the Hyper V OS on the RAID 0 array,
on a C: parition 60GB in size. Afterwards, I was thin..."Native" e-mail from access
Is there code out there that I can copy that makes a native e-mail
window open for users to send e-mails? What I want is for an outlook (or
whatever) e-mail window to open like it does when you click a hyperlink.
Just to clarify, I've made the SendObject call work for behind the
scenes sending, and am looking at the redemption library to get around the
Outlook security popup. What I want is an actual Outlook window (or a window
from whatever the default e-mail program is on the machine) to open so the
user can create a message from scratch.
I appreciate an...Workbook_Open Help
I got a splash screen in place so users know that the macros have bee
enabled properly. However when the file is started it starts on �Error
Sheet telling user that they must enable macro and how. This was don
prevent user going into the file without enabling macro.
The issue is when the user does enable they can still see th
background of the error sheet instead of the main page, it�s not unti
the splash screen disappears; it redirects to the Main Page. I change
the order of events so the redirection would happen first on th
Workbook_Open, but it continues to show the error sheet. Any id...