UI Data Validation using XML Schema
Has anybody done UI data validation usinf XML Schemas. Any pointers will help.
...Excel 07 selects 3 cells when I click on 1
Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an
empty cell 2 or more below it are selected and the typing goes on the bottom
row. I just want to select the cell I click on.
Are the cells merged??
I don't like the 2007 either!
If i could i would have the look and feel of 2003 on the engine of
On Thu, 1 Nov 2007 20:21:01 -0700, Brian
>Hi I just got 2007 (I want 2000 back) and a lot of the time when click on an
>empty cell 2 or more below it are selected and the typing goes on the botto...Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.
Under Look In options
Find allows for search by formulae OR values OR comments
Replace is restricted to formulaes ONLY
Have a look at this google search result. This topic came up a couple days
ago and was addressed by Dave and Myrna.
Gord Dibben Excel MVP
On Fri, 28 Jan 2005 03:49:02 -0800, "cp" <email@example.com> wrote:
>Under Look In options
>Find allows for search by formulae OR values OR comments
>Replace is restricted to formulaes ONLY
...how to use the type member in System.Web.Services.Description
I want to parse the wsdl file . It is ease to parse the parts of wsdl except that the part of types.
Because I don't know how to use the System.Web.Services.Description member types . I have searched the MSDN to find answer , but , it tell me very less. So I come here for help. For example, there is a types is defined as follows:
- <s:schema elementFormDefault="qualified" targetNamespace="http://www.webservicex.net">
- <s:element name="GetGeoIP">
<s:element minOccurs="0...how do i enable dde in excel?
i am posting a DDE link into an excel cell from an external program and
getting the message
' DDE Not enabled' in the cell once the link is pasted in.
how do i enable DDE?
...Paste Several Values into one Cell
Hi all. I have data in several cells (I2:GJ2) on one row. I want to copy all of this data into one cell as it appears now (in a particular sequence). Is this possible? Thx in advance.
Not sure if this is what you want but to concatenate data from several cells
into 1 cell, use formula =Concatenate(I2," ",H2," ",G2) just add more cell
references with commas and " " to give a space between each cell value for
all the cells you want.
"sgarrett" <firstname.lastname@example.org> wrote in message
news:110F5183-D1CE-4C5A-A7F8-90D01E500FBE@micr...excel file can't be opened #2
I have a recent excel file (about 1 month),but since two days ago,the file
can't be opened completely or always not responding.
What should I do so that I can use this important file.
Any help would be appreciated
...How to transpose in excel file
Hi I would like to make a transpose like this?
House Defect How much
#1 Broken Sinks 1000
#1 Bad Paint 2000
#1 Bad Lighting 1000
#2 Broken Sinks 0
#2 Bad Paint 2000
#2 Bad Lighting 100
and Transpose into
House Broken Sinks Bad Paint Bad Lighting
#1 1000 2000 1000
#2 0 2000 100
A Pivot Table will do that and more.
Set House as row field, Defect as column field and How much as data.
HTH. Best wishes Harald
"vilfood" <vilfood@d...Office 2007 and Windows 7 Multilingual Issue
Need some help setting up multilingual for Office 2007. Here's what I have:
OS: Windowns 2007 Enterprise
Office: Office 2007 Pro w/ SP2
Language Pack: Install several language packs thru the Windows 7 Update
So, here's the thing. I can't get the UI in the office apps (WOrd, Excel,
etc) to display the language I want. For example, I want the ribbon to
display in Chinese. Reading thru the documentations from Microsoft, it saids
I need to select the laugage in the "Display Language" tab on All Programs ->
Microsoft Office -> M...Outlook 2003 attach File Browse Window Stops Responding
In outlook 2003 when I try to attach a file and the browse window pops open
to browse for the file I want to attach the window will stop responding and
I have to force quit the outlook.
do you have mapped network drives? how long do you wait before quitting
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipsti...Headers in Excel #3
Can you tell me if it's possible and if so, how I can
change the header cells, i.e. A B C D E ... etc?
no this is not possible. The best workaround you can achieve is:
- use row 1 as header
- goto cell A2 and to the menu 'Windows - Freeze Panes' to always show
- in 'Tools - Options - view' you can hide the row and column headers
"Andrea" <email@example.com> schrieb im Newsbeitrag
> Can you tell ...windows xp frontpage error
Just got a call from my child at college, is getting a message saying to "put
in windows xp cd with frontpage", it was installed at the factory and the cd
says nothing about frontpage, was installed in coputer in2004 windows xp
professional, autoupdatw won't do it. any clue to what is going on? Is
freezing computer and won't open excell.
Though this is the newsgroup for Microsoft Dynamics GP and not Windows XP or
Ofice, I will try to help you out. In future, please post to the appropriate
I believe the error message being received is infact askin...Office XP on a windows 7 machine
I currently own Office Professional XP. I have to buy a new machine
that will have Windows 7
as the OS.
Will I still be able to install my software on this new machine w/o
any issues? Or will I be forced to buy a newer version?
I don't know about 32 bit vs 64 bit, Or various versions or beta's, I
just want to use what I have on whatever machine I buy.
If no naswer here check the Win7 forum at:
"Tom" <TesnoBay@yahoo.com> wrote in message
news:38e18fec-2219-467c-...Excel -> Access Import Bizarreness
A guy gave me an Excel file that he needs me to covert to XML. No problem.
Slurp it into a database and use a DataSet.WriteXML() call to turn it into
an XML file.
But I can't import it into Access because it has "Merged Cells". For
example, data that should look like this:
The three "this" cells have been merged into one tall cell:
I need to "unmerge" these, but I know almost nothi...Importing Outlook 2003 to Win 98 Outlook
I'm trying to import contacts from my office XP system running Outlook 2003
back to my home computer running Win 98 with Outlook, unsuccessfully. I've
also tried to install Outlook XP software onto Win 98 and while it appears
to be installed, there is no difference. Can anyone advise me on what to do?
Outlook 2003 pst-files cannot be opened in previous versions of Outlook.
You'll have to move them to an Outlook 97-2002 pst-file first. For detailed
Robert Sparnaaij [MVP-Outlook]
www.howto...Is this possible within Excel 2000?
Hi, I've used Excel on a get by basis for many years at work, and I'm just
beginning to realise its vast capabilities, having viewed several groups
which I didn't know existed previously.
I subsequently would like to ask if it is possible for Excel to look at the
numerical or text content of a cell on one worksheet and then look at a
predefined range on another worksheet and find the equivalent cell content
and then move the cursor to that cell? This has me stumped presently.
Thanks in advance for any assistance.
To actually move the selection, you'd need to use a litt...Excel 2000 fail to open workbook
I have one Excel template. If we open it on Excel 2000, the Excel will hang,
and the process occupy cpu 95% ~98%.
But we can open this tempalte in Excel 2003 normally, and if we save this
tempalte in Excel 2003, and then open it in Excel 2000, it work normally
Excel 2000 (9.0.3821 SR-1)
Excel 2003 (11.8231.8221) sp3
Would you help us to find the reason for this issue?
Perhaps there was some (probably minor) corruption/inconsistency in the workbook that Excel 2003 could fix but Excel 2000 couldn't.
[Microsoft MVP - Word]
...How can I create an invoicing database in Excel?
I would like to know how to create an invoicing database, or register in Excel.
(Invoice + tax = total) Are there any templates free online?
How about a web search?
search for invoice
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Vcollins" <Vcollins@discussions.microsoft.com> wrote in message
>I would like to know how to create an invoicing database, or register in
&...Windows 7 taskbar API problems
The background is that an Access MDE/ACCDE created by a developer is
not conceptually the same as an Excel spreadsheet or Word document
file created by the user. My Auto FE Updater utility automatically
downloads any new version created by the developer from the server to
the workstation as well as doing lots of other stuff such as creating
shortcuts on desk tops. If this was a user created Access database
file which resides in the users My Documents folder, or similar, than
they are conceptually the same as a Word or Excel file.
The problem is if the user right-clicks on...Excel prints some sheets very small
When I try to print multiple sheets of the same workbook at the same time,
one of them (a different one each time) prints very small (about an inch
tall) in the upper left hand corner. I am printing from a network file but I
don't know if this has anything to do with it or not. Please HELP!!!
...Proper use of categories in invoicing?
I am a freelance web developer. I use Money to print and track my
invoicing. Being a freelancer, I often have a wide variety of clients:
there is a continual influx of new clients, as well as a stable of regular
The regular clients often bring their own clients with them, and in this
case, my role is only to develop the site. As a result, I will often send
out 10 or 20 invoices to one of these regular clients over the course of a
year, covering work that I may have done on 20 or 30 sites.
As it is now, I can sort for invoices to the REGULAR CLIENTS, but I cannot
search/sort for i...EXCEL 2007 acting up
j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Using EXCEL 2007, I get an error with the line above as a macro.
It does not recognize CHR$.
What am I doing wrong?
Not for me it didn't.
Check for MISSING references in Tools>References, uncheck them if there are
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"pcor" <firstname.lastname@example.org> wrote in message
> j$ = "THIS MACRO WILL...problems loading excel documents
When I try to open up an excel document via my documents
it says that the same document is open already how can
this be stopped
First try the standard fix(es)......Tools>Options>General uncheck "ignore
OR Start>Run "excel.exe /regserver"(no quotes and note the space before the /
You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver
Gord Dibben XL2002
On Sat, 15 Nov 2003 09:16:14 -0800, "Tina" <TinaSCovell...Can we make a document frame window title bar disapper?
I registered a document template in InitInstance(). It may
not be an MDI child.
When I created a new document, I tried to make the frame
title bar disappear by setting:
cs.style = WS_DLGFRAME;
in function PreCreateWindow(CREATESTRUCT& cs).
Unfortunately, the title bar was still there, although no
I also tried setting:
cs.style &= ~WS_CAPTION;
and some other combinations, no luck.
Could anyone tell me how to do it? Or, can we do it?
You need to remove WS_CAPTION style. You can do it in Precreatewindow and
for mainframe do it after it ha...how to convert word file into excel file
If any body know about how to convert MS Word file into MS Excel file please
let me know.
I am unable to do so.
> If any body know about how to convert MS Word file into MS Excel file
> let me know.
> I am unable to do so.
> Help me
Try Copy and Paste
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=467752