Take advantage of a great deal
...SIGNUP FREE and Get a 6000 SQ FT HOME
As one of the Nets TOP Millionaires I never do free opportunities.
A good friend of mine and fellow top earner showed me a check from
this free opportunity that was so big it paid for a 2008 Range Rover
and his 6000 Sq Ft House.
I was shocked. I said you kidding right? He Wasn't.
He just threw up banners on safelists and ad sites.
I had to try it since it was free.I did and got a check for 10 Grand!
Listen to this audio: http://www.byoaudio.com/play/WpmTgFBk
Go to my website and lock your position in now!
...Changing File Icon
Is there a way to change the file's Excel icon into another Icon (.jp
Do i need a ResEdit type of software?
I'm trying to make easier to identify the different sheets to severa
In Mac OS i saw someone changing the icons so i would like to know i
it is possible in Win Excel.
Thanks in advance
jose luis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1331
View this thread: http://www.excelforum.com/showthread.php?threadid=39307
Jose Lu...Getting vba Macros to work again in Word 2004 for Mac
The macros I wrote myself for my work as a translator quit working in office
2004 - trying to open or run them causes Word to shut down. Reinstalling did
SOOO I bought Word for Mac 2008, only to learn that VBA macros are not
supported in that version.
1. Are there any patches or fixes out there for Word for Mac 2004? Can I
2. Or - when will Word for Mac 2010-11 be out, and will it include support
for VBA Macros?
3. Or is there another solution you recommend? I wrote about 30 Macros, each
of them with more than 50 commands. It's hard to...Can't get Vista recovery CD to recognize installation
I'm trying to get a Powerspec B647 Vista64 Business PC to boot. After
booting to the Vista Recovery CD and choosing to repair, the process
can't find any installed O/S.
So I press the Load Drivers button to load the B647 RAID controller
drivers, which I downloaded from Powerspec to my flash drive. After
pointing it to the "sataraid" folder, the system installs some
controllers and drivers but still doesn't find my Vista installation
afterwards. Even worse, the C drive letter is given to one of the
removable media drives.
After pressing the Next button I'...UI won't update (2nd try)
my application still won't update the tool bar (when I set a breakpoint
at the OnUpdate handler, it shows that this method is never called).
When I showed a message box or used the scrollbars of my view, the app
started idle processing (and the method was called in certain
intervalls, just as one would expect). Now that I have changed some
parts of my app, it won't even do this. How can I find out what's wrong
in my app? How can I determine if idle processing is done? I think that
this is the bug, the app doesn't start idle processing.
It'...Installing Money without access to updates (as Money is retiring)
I have a copy of Money 2006 (I think, the version isn't the point here).
When I do a new install, I cannot open my existing .mny file. I first create
a dummy file, wait for Money to mention it has updates to install, and then
install them. Once this is done, I can open my existing file.
My problem is this: Five years from now when Money is a distant memory, I
may want to install it on a new computer. I fully intend to stick to my
retirement plan in Money using Money, and so I see a long, long life for this
product on my current and future computers. How, then, can...Find nth instance of a character in a string
I'm sure I've done this in the past but for the life of me I can't remember
Say I have a string "http://www.theexceladdict.com/tutorials.htm" in cell
A1. I want to determine the position of the last "/" (forward slash). The
strings won't always contain the same # of "/"s.
I need to be able to do this as a formula and also in VBA code.
I appreciate your help.
Have a great day,
Francis Hayes (The Excel Addict)
Helping Average Spreadsheet Users
Become Local Spreadsheet Experts
If you want to extract ...How do I determine default instance vs. named instance install?
I need to determine the status of a server built by another Admin before he
left the company. One of my tasks is to determine if the SQL 2005 workgroup
SQL was installed as a default instance or a named instance. Can someone
either tell me how or direct me to a document please. Thank you.
Bo (Bo@discussions.microsoft.com) writes:
> I need to determine the status of a server built by another Admin before
> he left the company. One of my tasks is to determine if the SQL 2005
> workgroup SQL was installed as a default instance or a named instance.
> Can someone either...how do i get excel to show mm/yy
How do i get excel to show mm/yy in Funcation bar like it does in the cell
instead of the mm/dd/yy and I know it can be done I have seen it done in
2000 ver I just dont remember how to do It, PLEASE help me out.
before entering any data, format the cell as text. Then, for example, if you
enter 11/05, that's what will appear in both the cell and the function bar.
> How do i get excel to show mm/yy in Funcation bar like it does in the cell
> instead of the mm/dd/yy and I know it can be done I have seen it done in
> 200...automatically update the pivot table
I am using excel 2003
How can I update the pivot table automatically when I open the workboolk ?
you can try with this link
"eva cheng" wrote:
> I am using excel 2003
> How can I update the pivot table automatically when I open the workboolk ?
> eva cheng
eva cheng wrote:
>I am using excel 2003
>How can I update the pivot table automatically when I open the workboolk ?
Pivot Table Options> Da...change background-color depending on cell-content
There is one cell per row which can have six different
contents. Depending on what there is chosen, I like to
change the background-color from different cells in the
same row. How can I do that? Is it possible without VBA?
Please help me!
Have you tried to use the "Conditional formating"
In the menu select Format->Conditional Formating
PS: I have a portuguese version so I don't know if the
terms in english are those I mention, but they must be
>There is one cell per row which can have six differen...Can't get the proper display of a field in my report.
I have 2 tables, both using autonumbers for their primary key. The first
table is for contacts (i.e. last name, first name, etc.). The second table
is for businesses (business name, etc.) I have a field in my contacts table
that has a number format so it can be used as a foreign key for the business
table. I then set up the relationship between them & enforced referential
integrity. When I run a query, I see the name of the business (after setting
up a combo box) - no problem. When I run a report based on that query, a
number is displayed (not the business name).
Suggestions, pleas...Get the full xpath of a XmlNode
How do I get the Xpath of a XmlNode?
"Aaron" <email@example.com> wrote in message
> How do I get the Xpath of a XmlNode?
...Avoid sorting fields when update from external database
I have a privottable in my Excel 2007. Data comes from a view in my
sql-database on a server.
When I connect or update the fields are shown in alfabetic order in
the pivottable, not in the order used in the source.
The order in the source-view is more logical for the users. Can I keep
that order in my pivottable ?
On 25 Nov., 11:52, Peter <pgrandj...@jubiimail.dk> wrote:
I found the solution. There is a checkfield in the PivotTable Option
...getting a message that auto recovery is postponed?
Message says AutoRecovery postponed for <file>.
AutoRecovery box is checked in Word Options.
Running Windows 7 and Word 2007.
...Excel will not change cell border colours
I can change the border patterns using format-cells but when I try to change
the colours excel will not do so but reverts to "Automatic", any ideas
...I cannot read forwarded messages. I only get an email address
For some reason, when someone forwards a message to me all that shows up is
the email address of the person who originally sent the message. Any ideas?
Change your View>Encoding setting.
> For some reason, when someone forwards a message to me all that shows up is
> the email address of the person who originally sent the message. Any ideas?
...Change activity vies on account
On the account, the defauls views on "Activity" is open activities, and
"History" for closed activities.
A client wants the view to be change: He wants to views all actities by
default. (open and closed, and without the "next 30 days filter).
Is that posible? The filters on assosiated views for activities on account
can not be edited, as I can see?
The answer to your question can be found at:
"Jacob ...Upgrade 9 to 10 only work if update instance, not if new instance
I'm testing a GP 9 to 10 upgraded on a test server. Everything
installs; however, GP Utilities will bomb out if I created a new
instance when installing 10. There is no error message, it just fails.
If I do an update to the 9 instance, it works fine. Why should this
make any difference? It's the only thing I'm changing in the two
Not sure I understand. What do you mean by "instance"?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster...Get rid of "Date: Today" sub-headers from Inbox???
I just installed Outlook 2003.
In my Inbox, the email is divided up and organized by
these collapsable little sub-headers, such as:
I really want to get rid of these so that my email simply
appears as one long list. Can someone help me figure out
how to do this?
Disable "show in groups."
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.co...How to get the value of ID columns from older tables?
I have several SQL Server tables with ID columns (the property of the
columns specify that it "Is Identity Yes").
The tables have many rows but I only want the value of the ID column
from a table when the where clause is satisfied.
These are "not" newly inserted in fact these rows can be very old and deep
within the table.
Can anyone tell me how I can extract the value from an Identity column from
> Hello Community
> I have several SQL Server tables with...Update
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past several years while customers and participants are increasingly finding
solutions in the forums on Microsoft properties and third party sites. This
move will unify the customer experience, centralize content, make it easier
for active contributors to retain their influence, mitiga...OWA
When using Outlook Web Access, some content in received emails, such as
graphic images, doesn't show. This seems to be a result of some security
setting where OWA is protecting me from myself. Where and how do I reset
this so I can see all of the content in my email?
> When using Outlook Web Access, some content in received emails, such as
> graphic images, doesn't show. This seems to be a result of some security
> setting where OWA is protecting me from myself. Where and how do I reset
> this so I can see all of the content in my email?
This is on Vis...How to get cell background color
How to get cell background color by Formula ? just in A2 input formula
to get A1 background color.
Use the following UDF:
Public Function BColor(r As Range) As Long
BColor = r(1).Interior.ColorIndex
User Defined Functions (UDFs) are very easy to install and use:
1. ALT-F11 brings up the VBE window
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window
If you save the workbook, the UDF will be saved with it.
To remove the UDF:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE wi...