I have a problem where I am working with extended character sets in XML but
I have also found that any time I work with a translation or internally
generated Xml document I get the dreaded message, "Data at the root level is
invalid. Line 1 position 1".
If you run the following code there will be extra bytes at the beginning of
the resulting string. I believe this is some type of BigEndian encoding or
something. My question is this, how do I do this and load the result into
the DOM object and keep all character encoding in tact?
using System.Xml...MSN-Like Chat window
Im trying to put an msn-like chat window on my program.
I want to be able to select text in the window, and it needs a vertical
I also want to be able to put images in the text (smileys).
How can i do this?
And also, how can i put the window on top of its parent window without
Any help would be appreciated :)
and if you cant help me, thx for reading anyway :)
...chart in excel like google finance chart
I've been playing around with google finance and am wondering if a
chart like that can be implemented in excel. Some of the features I'm
very interested in is the ability to be able to select a time window
and chart the trend. I need to create a chart that is basically
identical to the google and yahoo finance charts. Is this possible at
all in excel or is this an impossible task and I should look
elsewhere. If impossible what are some suggestions for accomplishing
Can you post back with the chart you have in mind? More than likely you can
create the chart in Exc...I would like to increase my budget figures by a percentage
It is buget time and we need to increase the 2004 figures by 2% for 2005 is
there a formula that can do this in one command
enter 102% in a separate cell
Copy that cell
Select all the cells to increase
Goto Edit>PasteSpecial and select the Multiply button in the Operation
(remove nothere from the email address if mailing direct)
"Wendy" <Wendy@discussions.microsoft.com> wrote in message
> It is buget time and we need to increase the 2004 figures by 2% for 2005
> there a formu...I would like to add a base line to a chart ...
I have a chart which tracks workhours per week. Across the bottom are the
dates representing the ends of the weeks (1/7/07 through 12/30/07), and along
the left are possible hours per week (0 through 70). I am using a line chart
I would like to add a base line or indicator line across the chart at 45
How can I add a base line at 45 hours. (I don't have the base line data in
Thank you for your help.
Add a line to a line or column chart:
Jon Peltier, Microsoft Excel MVP
Tu...255 Character Truncation, Vlookup Macro vs. Opening Workbook Macro
I just posted an entry on the microsoft.public.excel.programming forum,
but thought I'd post it here as well.
I forgot to complete the subject line on that post.
But you already have a response in .programming.
It's pretty unusual that you'd have to post to multiple forums. But if you
think you must, try to post to both at one time.
> I just posted an entry on the mi...Preserving character attributes in a RichTextBox
I am using a RichTextBox to display many lines of text, where the characters
are of various colors. To keep the text box from getting fuller than I would
like, each time it reaches a specific number of lines I copy its contents out
to a string array, copy only the last "n" lines of that array into another
string array, then reassign that new smaller array into the text box. As a
result the text box then only displays the newer lines. For example:
int linesInBox = richTextBox0.Lines.Length;
if (linesInBox > MAX_LINES_WANTED_IN_BOX)
// Get all lin...Choosing the square character as a delimiter
Just wondering if anyone knows how to choose the square character as a
delimiter when importing a text file into Excel. I can't copy or paste it.
Thanks in advance.
Depends on what that is.
If it's alt-enter, you can hit and hold the alt key while typing 0010 on the
numeric keypad (or even just hit ctrl-j).
You can use Chip Pearson's Cell View addin to find out the character it is:
Once you know what it is, you could try the alt-#### to see if it works.
If it doesn't, you could use a macro to change it to a different charact...Determine last character typed
Is there a way to determine the last character typed in a text box? I want
to run code in the on change event of a text box but not if the last letter
typed is a space.
Read the Text property of the textbox (note: Text is a property that can be
read only when the textbox has the focus) and test the last character in the
Text property's result:
Private Sub TextBoxName_Change()
If Right(Me.TextBoxName.Text, 1) <> " " Then
' your code goes here
<MS ACCESS MVP>
"Tim J La Fazia" <timj.lafazia@idc-...In Excel Remove what looks like a key with + on it. Anchored on pa
On my EXCEL SCREEN I have what looks like Keyboard keys with + or +- on them.
How do delete them? What are they?
* 'Data' >'Subtotals...' > 'Remove All'.
* 'Data' > 'Group & Outline' > 'Ungroup'.
"Ed Walsh" wrote:
> On my EXCEL SCREEN I have what looks like Keyboard keys with + or +- on them.
> How do delete them? What are they?
...How do I get entries over 1000 characters to display in a cell?
I'm converting a paper form to an excel version. I need one cell for the
user to enter a narrative. I want the printed copy to show the full entry.
I think 2000 to 2500 characters is probably long enough for most users.
The problem I'm running into is text that stops wrapping after about a 1000
Thanks for any help.
Whilst there is the method of inserting ctrl/enter characters to reflec
more text you will find the odd user who will demand that 'more
characters are displayed.
This, of course, also applies to printing.
One method is to insert 31 following r...Can I use a header or footer more than 255 characters in Excel?
What can I do if I need to insert more than 255 characters in a header or
footer in Excel 2003?
And can I make some grid lines for a header or footer in Excel 2003?
Thank you for your help!
The combined length of all third headers or footers (left, center and right)
may not exceed 255 and you cannot change it. The only 'workaround' I can
think of is to create them right in the worksheet itself.
"Jin Qingfeng" <Jin Qingfeng@discussions.microsoft.com> wrote in message
| What can I do if I need to i...How do I display unicode characters in a web page using an isapi dll?
I have an ISAPI extension DLL that needs to output unicode data using
the WriteClient() function. The unicode characters are not displayed
properly. The text that is displayed in the web browser looks like
garbage even though viewing the source HTML shows Chinese characters
DWORD WINAPI HttpExtensionProc(EXTENSION_CONTROL_BLOCK *pECB)
html =3D L"<html><head><meta http-equiv=3D'content-type'
content=3D'text/html; charset=3Dutf-8' /></head><body><p>=C6=...Using a IF formula, I would like to drop the 2 digits in front of.
Using a IF formula, I would like to drop the 2 digits in front of the
decimal, and only use the 2 digits after the decimal
will return decimal
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"osuhoosier" <firstname.lastname@example.org> wrote in message
> Using a IF formula, I would like to drop the 2 digits in front of the
> decimal, and only use the 2 digits after the decimal
Not sure I get this but the form...How many characters per cell
How many characters can you fit into one cell.
We are having a problem with text being cut off when printing, but i
shows up when viewing on either Print Preview or normal view
aletoconstco's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3533
View this thread: http://www.excelforum.com/showthread.php?threadid=55334
Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.
However, it goes on t...Character Query
I have a file that I need to query that has names of cities in a particular
field. I need to find all cities that have more than 4 characters in its
name. Thanks in advance.
"KIMA06" <KIMA06@discussions.microsoft.com> wrote in message
>I have a file that I need to query that has names of cities in a particular
> field. I need to find all cities that have more than 4 characters in its
> name. Thanks in advance.
WHERE Len([NameOfField]) > 4
If the value may be null, you might need to modify that to som...Trim characters
Which are those characters that CString removes when you call
CString::Trim function of it? One of them is \0, I want others or
As well as what is similar function to trim those characters for LPSTR
or LPWSTR ?
>Which are those characters that CString removes when you call
>CString::Trim function of it?
The documentation says:
"Removes all leading and trailing occurrences of one of the following:
The character specified by chTarget.
All characters found in the string specified by pszTargets.
>One of them is \0
I...Looks like a bug with copy\paste from cmd to word.
WinXP 5.1.2600 SP3 Build 2600, and word 2007 v12.0 bulid 6514
When I paste from CMD to Word, space between letters and "%" symbol
disappears; for example every time I copy from cmd something like "md
%xxx%' and paste it into word, I get "md%xxx%"
Is it a bug? or it is a kind of feature?
"Dmitry" <Dmitry@discussions.microsoft.com> wrote in message
> WinXP 5.1.2600 SP3 Build 2600, and word 2007 v12.0 bulid 6514
> When I paste from CMD to Word, space between letter...set up a worksheet in excel like a check register with auto sum
I would like to set up a worksheet in Excel for my check registor that will
automatically give me the balance.
jthhousing, have a look here and see if this will do what you want,
If not I have one set up, if you would like to have a look at it let me know
and I will send you a copy
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"jthhousing" <jthhousing@d...Tab Key acting like Alt-Tab
Lately, when I've been trying to use the tab key, I get that Windows switch
thing that supposed to happen when you alt-tab. I don't know whether I'm
doing something to make that happen or need to re-map my keyboard. It
usually starts after I'm using FaceBook weirdly enough. Any ideas?
Could be option enabled in "Ease of Access" (used to be called by a more
sensible name "Accessibility").
So check those options, e.g. 'sticky keys" options, etc.
If that doesn't solve issue, are you sure "Alt" is not faulty i.e. not stuck...Specialized Spreadsheet
Anybody want to tackle a special request for a specialized spreadsheet
function? I need a way to track persons progress on a project. for example,
they have 2080 hours in a work year. I need to account for holidays and
weekends then if they are what ever project they can charge to. For example
if they have 500 hrs on one project, 300 on another etc, planned days off and
vacation it should project their time etc.
My office e-mail is email@example.com
Do you use MS Project. You can write macros in MS project that wil
export the data into...Special Rights needed for ODBC access in WIN 7-64?
I have an access 2007 database, frontending a MYSQL database. Works
fine on all of our XP boxes.
When I go into ODBC administration, I can set up the ODBC connection, as
a System data source, and it tests fine.
When I actually try to use the database, I get Connection failed, even
just trying to open the ODBC linked tables.
If I try to create a new link, it is really weird. I get a dialog box
with two tabs: File Data Source and Machine Data Source. SYSTEM data
source, which is the way my source is configured is not even an option.
When I hit NEW connection...15 character field truncating
This isn't really a question. I just need to explain properly from a more
authoritative voice than myself why something is happening to a client. She
is entering a 15 digit character in excel (all numbers). It is truncating it
down to a few numbers plus that e+ thing. For example entering
153469874563216 becomes 1.5437E+14 when the cell is formatted as general or
number. I explained as best I could why and to format the cell as text or add
a single quote to the beginning, but she said it didn't work for her that way
before. She has Word XP and I had several others try and it did...Character Spacing Problems
When attempting to print in Publisher 2002 my text
appears disjointed and expanded. if I use character
spacing to correct this it only makes the printed copy
worse! The text looks fine of the screen before I print
but prints out all weird. Can anyone help me?
It isn't a Publisher problem. It's most likely a printer driver problem. Go
to the web site of the printer manufacturer and download the latest drivers.
"Elizabeth" <firstname.lastname@example.org> wrote in message
> When attemptin...Extracting Everything From Right of A Group of Characters
So I've got a field, and I need to extract all characters to the right of the group of characters -1\.
I created a right function but it gives me some random result where -1\ is in the middle of the result.
So I think I screwed something up.
Thanks so much!
EggHeadCafe - Software Developer Portal of Choice
BizTalk Application that inserts records into SQL from *.CSV File
could do with nowing the following
1. Query that has the problem