Can someone help me to understand schema locations?
I have this xml:
And, I'm trying to read it... without success. I'm using code from this
KB318545 (http://support.microsoft.com/kb/318545), but not having much luck.
That its not working is probably because I don't understand how to map the
info above to the parameters needed ...How to change macro so it performs actions on ACTIVE sheet?
I want to create a macro that I can run on various sheets. All these sheets
have the same format but different data. I created the macro and opened it
with microsoft visual basic. The problem is the '=Sheets()' command that
selects the sheet that i used to record the data. How do I change it so it
just runs on the active sheet?
Your macro probably contains the line: Charts.Add
When this is executed the chart becomes the activesheet which is why you
can't referen...polling located
Hi, original tankgirl locates polling for Windows Live Mail:
HKEY_CURRENT_USER\Software\Microsoft\Windows Live Mail\mail
...row height changes #2
I've checked the computers and they are both confiured to use the sam
printer which is a network printer and so only one driver used. Whe
opening a different file to previous, in page break preview, on on
the page break is between lines 49 and 50 and on the other between 4
and 47. Both show row height at 11 and both have margins / footer
header set the same. This is not the only file we have this proble
with and it's causing problems that files can not be shared around th
crescent-centr...How do I change the mail format in OWA
I have a Goverment client the stopped all HTML formated mail. I have 50 or so
users that only use OWA to send and recieve email. When ever the OWA user
sends or replys to email from the Gov site it gets rejected. Is there any way
to change the mail format in OWA to RTF or Plain Text?
This is going to be a real big issue as the rest of the Gov site do this.
I didn't test it out myself, but in ESM go to Global Settings\internet
message format, set up a policy for the government domain to use plain text
only would probably do the trick?
---------------------------...Tracking changes to a cell containing formula
I want to track changes to cells because a formula calculates a ne
value, not because i changed directly the value of a cell.
the excel help indicate the following:
Cells that change because a formula calculates a new value---> To fin
cells that change due to recalculation, use the tools on the Auditin
How to do that? The formula auditing toolbar doesn't seem to hav
something like that...
Thanks for your tim
Message posted from http://www.ExcelForum.com
have a look at 'Tools - Track changes'
> I want to track ch...locating .dll
I get the this message every time I try to open the
calendar, contacts, or tasks. "Unable to display the
folder. Microsoft Outlook could not access the specified
folder location. The .DLL file for the information
service could not be found. MAPI was unable to load the
information service PSTPRX.DLL. Be sure the service is
correctly installed and configured."
Does anyone know how to fix it?
Create a new mail profile.
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 sen...Add picture located in same workbook to background of XY Scatter Chart
I need help adding a picture to the background of an XY Scatter Chart.
I was able to add the picture by referencing a .jpg file, but I am
sending this out to ppl who won't have the .jpg file. Instead I would
like to store and reference the picture in a worksheet in the same
workbook as the chart. Any ideas?
Here is the code I have been using to get the picture from a file.
Selection.Fill.UserPicture PictureFile:="C:\My Documents\Picture.jpg"
Thanks for the help
...Refer to a Locations Table in the Lead form
I need to use/refer a ISO location table.
I'm customizing the leads form and need to include an origin and destination
location fields, and would like to choose the values from the locations table.
How can I do that ? Can I create this table in MSCRM or refer to other SQL
You will have to create your own Lead ASPx form and manipulate the data
yourself (via methods described in the SDK).
You cannot add direct "Lookup" fields (referencing another database table)
in the current version of CRM.
It is probable that this type of functionality will be...I changed value scale numbers
I have a range of percentage data values ranging from 97% to 100% and the
chart starts the bar graph at 97%. I tried to override the "scale" numbers
but it goes back to start at 97%. I want it to start at 0% up to 100%. The
only way I can get it to start at 0% is to put a value in the data table of
0% but then it shows on graph and I don't want that. Why when I change the
minimum to 0 and max to 1 if refused to take it. It did not do this is the
old 97 version of excel!!!
After you enter a value, don't check the Auto box. Auto means let Excel
decide what...NumberFormat not getting changing onFly changing the regional sett
Hi Excel experts ,
Sorry for posting a new question over here. I am having a hard time with one
of a Excel related issue.
1) User pulls some data ( includes numeric,Date fields ) to excel when
he/she is with German OS settings.
Date show in following format: dd.mm.yyyy ( eg: 23.09.2010)
2) Now on the fly he/she changes the OS regional settings to En-US
3) Here our code again reformats those columns with current regional
settings and polish the data according to its regional settings.
4) In our case all numeric values are getiing changed correctly to the ...Changing Colours of Button
I want to change the colour of Button on Form when i roll over the mouse or
click the button. is there any coding required for this? please help
To change the button's ForeColor property from black to red for instance, in
the button's MouseMove event procedure put:
Me.[YourButtonName].ForeColor = vbRed
Add another button to the form and size in so that it is bigger than the
original button. Set its Transparent property to true. Move it so that it
overlies the original button and place it behind the original button using
'Send to Back' on the For...Changing a transaction to be in Foreign currency
I am having problems with my investment accounts. My base currency is
canadian. However when I do a transaction in a security that is based in the
US, MS Money assumes that the price entered is in C$. Hence the purchase/sale
price is not reconciling with my statements adn I show a lower/higher cost in
FYI The security is shown to be in US in the security details.
In microsoft.public.money, VUSA2006 wrote:
>I am having problems with my investment accounts. My base currency is
>canadian. However when I do a transaction in a security that is based in the
>US, M...Invoicing with Multiple Bins
Does the invoicing module work with multiple bins enabled ?
A client of ours is receiving an error message when trying to enter
invoices: "You can't create or post invoices with the multiple bin
If using mulit bins you'll have to use Sales Transaction Entry for
Invoicing. The Invoice Entry window does not provide for selection of
the bin, only a Site.
Hope this helps,
MCP-GP, MCT, MVP
East Coast Dynamics
Thank you, Frank.
I had to figure this out the hard wa...i couldn't open my excel files,it gives location couldn't find err
i am trying to open my excel files but it gives me the following error:
"If you are trying to open the file from your list of most recently used
files on the file menu,make sure that the file has not been renamed,moved of
But if i renamed the same file to some other name then it works.so please
tell me how can i fix this problem.
Thanks & Regards,
How are you trying to open the file?
Are you double clicking on it in windows explorer?
Or are you using File|Open and choosing the file?
Or are you using File, then clicking on one of the files at ...OPEN WITH "MY SHORTCUTS"
How do I get Outlook 2000 to open with "My Shortcuts"
instead of the default "Outlook Shortcuts"?
Please, you don't have to shout (ALL CAPS). I don't see
any easy option to do what you want. But if 2000 is
similar to 2002, you might want to try opening your My
Shortcuts group and clicking and dragging each item up
until it jumps into the Outlook Group. Do the same with
the Outlook Shortcut items dragging them down into the My
Shortcuts Group. Then right click each tabs and rename the
>How do I get Outlook 200...Cancel user's changes but save other changes
I've modified the workbook before close function as follows...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Not Me.Saved Then
RetVal = MsgBox("Do you want to save the changes you made to '"
& Me.Name & "'?", vbExclamation + vbYesNoCancel)
Select Case RetVal
Me.Saved = True
Cancel = True
// my code with some changes
...Why does it change size in IE
Everytime I use Outlook, it has an annoying habit of
changing the text size in IE. This is annoying, how can I
get it to stop this?
...Can Access 2007 track who changed an entry last and when it happen
I am considering to buy Access to be used by a handful of people at work but
I know little about it. If I have a customer entry with many fields
containing different information, is it possible to track when an individual
field was last updated and who did that update?
to get the name of the current Windows user, and add a timestamp to a date
field in your table. Use the AfterUpdate event of your form to add the user
and date/time info to the table.
Tables have no triggers and therefore require forms to run code.
Arvin Meyer, MCP, MV...Mark cell when changed
I have an Excel sheet which is filled with formulas linked to a data
warehouse. To be able to easily detect changes in the the past I was
wondering if you can format a cell so that it (for example) turns red
as soon as the value in it changes due to an update of the sheet.
Hope that someone can advice me.
Thanx very much in advance.
A worksheet_change event macro could mark the cells with red, but since
you're sheet is links to the original data, that won't fire the macro.
You need to think about when you'll reset the colors. Perhaps a bette...Word 2007 Outline Level changes keep on reverting
Hi, I'm trying to tidy up the formatting of a 120 page report in Word
2007, which was written by someone else and originally based on a Word
2003 Template / doc. The main problem is with the Outline Level - text
(some Normal text, some text formatted as Captions, but not others,
some Bold Text, some Italics, etc.) which should be Body Text appears
as Level 1. When I change it to Body Text in Paragraph formatting,
close the document and re-open it, it usually retains the Body Text
formatting I want, but when I open it a second time, it's reverted
back to the old formatting. This...changing user password
I have a user that is not able to change her password. I set her up as a
user with a temp password, thinking she would be prompted to change at first
login. She was not. When she tried to force a change, it said she was not
Where do I give this authorization? I am on v.10
Did she try to change the password in User Preferences => Password?
> I have a user that is not able to change her password. I set her up as a
> user with a temp password, thinking she would be pr...Why does sheet formatting change when pasting into a new book?
When I select Move/Copy... for a sheet in Excel 2007 and select a new
workbook, sometimes the formatting changes. Usually the charts will have a
new color scheme, and cell colors will change to strange color schemes as
well (bright red and green, anyone?). I am copying from one XLSX file to
another, both files are open at the time, and there are no macros enabled or
How can I retain the formatting, and what is causing this issue? Several of
my colleagues experience the same issue with reports.
...Location of CRM data File #3
Could anyone please tell me the location of the CRM data file (not .pst) in
Outlook 2007 Small Business.
It would also be good to know if its' location can be moved.
...Dates change to prior year when page moved to new book
Excel 2003. I have columns containing dates in 2004 and 2005. When I move or
copy the page to a new book, all of the dates change to 2000 and 2001. How do
I correct so that the page can be moved or copied?
Tools>Options>Calculation, make sure that "1904 date system" is the same in
"David_UCSF" <David_UCSF@discussions.microsoft.com> wrote in message
> Excel 2003. I have columns containing dates in 2004 and 2005. When I move
> copy the page to...