Seeing Two instances of the Data File in the TRee!
I am sorry for the obscure Subject line, but I can't think of a way to
I am using Outlook with regular Internet Email. I have it set up with the
standard one Data File. When I go to the Data Files page, there is only one
file in use.
But.. In the Tree on the Left (in Office 2003) I see 2 personal Folders (of
the Data File) and they are exactly the same thing, when I get new email,
both inboxes receive the file.
Also, when I go to the Email Accounts page, and I want to choose which Data
File to direct the emails to, it shows 2 options, both having the same name
(Duh, ...xml receipt modification
is there a way to have a receipt print the long description on a receipt but
only if the the customer is paying "Price A", and not have it print for all
If you are interested we can offer a custom solution. Please drop a email.
> is there a way to have a receipt print the long description on a receipt but
> only if the the customer is paying "Price A", and not have it print for all
> other customers.
> Please help.
> Thank You
>...how do i see which data matches between two worksheets?
I need to compare a very long worksheet (W1) to a shorter worksheet (W2) to
see if any of the files listed on W1 are on W2. I then need to copy the
matching rows from W2 to a new worksheet.
look CPearson web
second title Extracting Elements Common To Two Lists
> I need to compare a very long worksheet (W1) to a shorter worksheet (W2) to
> see if any of the files listed on W1 are on W2. I then need to copy the
> matching rows from W2 to a new worksheet.
...Template Wizard with Data Tracking #7
Where do I get the Template Wizard with Data Tracking for Office 2003? I
found one for Office 2002 and I tried it, but is doesn't work.
...Can somebody write a sample?
can somebody write a sample to understand better the code in
...Automatic data collection in Manufacturing
How does this work? I see where you can designate a workstation as an ADC
processor, but where do you setup to let your bar code scanner enter
information. What exactly is the setup on this?
> How does this work? I see where you can designate a workstation as an ADC
> processor, but where do you setup to let your bar code scanner enter
> information. What exactly is the setup on this?
If you figure the answer, do post. I will be interested in knowing this too.
> How does this work? I see where you ca...XML file width
I'm converting a 1MB bitmap file into base64
encoding..and saving into an xml file.
the xml file and everything works perfectly...except when
i open the xml file in a viewer I get errors becuase the
file is written to just one line with no coluumn width
how can I ensure the xml writer in vb.net spits out
beautifully formatted xml code like the access 2003
with my 1MB <image> tag spread over thousands of lines 80
chars wide instead of just 1 long line that crashes any
> I'm converting a 1MB bitmap file into b...Excel 2007 crashes after viewing property sheet in Data Connection
I have been using Excel 2007 to import comma delimited text (csv) files
stored on my local hard disk into my personal finance spreadsheet. The
Data>Get External Data>From Text wizard works fine and have had no trouble
using the Refresh function. The problem comes from accessing a Connection
Properties Box from the Data>Connections Box. If I select OK after viewing
the Properties Box, Excel crashes, restarts, and offers to let me continue
working on a repaired worksheet. This behavior occurs even when no changes
are made in the Properties Box. If I select Cancel, Excel exits the...How do I plot Excel data on a floorplan?
I'm trying to find a way to plot data from an Excel worksheet on a floorplan
diagram. The data reflects room assignments for a hospital, so some data
stays the same for days while other data changes on a twice a day basis. I
want to enable someone to be able to enter the data on the worksheet and have
excel output the names, etc in the proper room assignments on the floorplan
automatically. The users could then print this floorplan to locate the
assignments more easily. I can either scan a hardcopy of the floorplan, or I
have access to Visio so I could also quickly construct a d...XML DTD Question
Here is my original xml structure. I want to add another child node called
hyperlinks to the parent graphic. How would I modify this DTD to reflect
this new child being added.
Thank You for any help toward this end!
ich habe folgende Anforderung: Ein XML-Dokument soll in einen Editor
eingelesen werden, also in ein Control das XML als Baum darstellt, die
Node-Values und Attribute sollen editierbar sein. Kennt jemand da ein
geeignetes Control f=FCr (kann auch Geld kosten).
Dank und Gru=DF,
> ich habe folgende Anforderung: Ein XML-Dokument soll in einen Editor
> eingelesen werden, also in ein Control das XML als Baum darstellt, die
> Node-Values und Attribute sollen editierbar sein. Kennt jemand da ein
> geeignetes Control f�r (kann auch Geld kosten).
I d...Sorting Data Employee name time
I have a worksheet of data (Employee names and times from job sheets) which i
need to sort by employee name and then totalise times to find total hours
worked for the job. There name may apear several times or not at all. I need
a total for each person then to be written to the database sheet through the
database template add in.
for this I would use a pivot table. <See:
Frank...Help help, combining limited data
HI guys I was wondering if you could help me with writing a formula that
meets this criteria...
1. I need to combine Text in column A to Column B (=A1&B1)
2. BUT I only need the first letter of coumn A to combine with the rest
of column B
3. Columb C needs to be <= 10 chracters
Text in Column C for row 1 = sAAABBBCCCD
Text in Column C for row 2 = gBBBBBBCCCD
If it doesnt have to be all in one formual, I mean I can combine A and
B and then do a formula for C, i just need the results to be the first
letter of the A column combined with <= 9 digits of the Column B
----------...pasting chart getting source data from new location
I have a spreadsheet and chart of which I need several instances. When I
copy and paste the sheet, the source data for the new chart is pointing to
the original spreadsheet. My goal is to have a new sheet and chart that is
independent from the original, however works the same way. New data entered
into the new spredsheet will display on the the new graph.
This functionality is by design but you can easily change the source of any
chart. To do so, first click on the outside edge of the chart. Next,
right-click on your mouse and select "source data". Finally, in the source...DOCTYPE with Xml Serialization
I have a class that serialize using the XmlSerializer.
I am using several attributes for class members to control serialization
One thing I cannot figure out how to do is how to add DOCTYPE attribute to
This XML file must use the doctype that refers to the DTD rather than an
Could someone point out how to accomplish that using the attributes or by
some other means?
Welcome to MSDN newsgroup.
From your description, when you use the .NET XmlSerizliation to serizliaze
some class instances out to xml stream, you want to also expose the DocType
for ...Change source data of a pivot chart
In Excel 2007 can you change the source data of a pivot chart I have multiple
charts and tables which I want to copy but the copied charts still refer to
the original pivot table
I have limited practice with this, but I think if you copy the sheet with
the pivot table and chart to a new workbook, the links travel with the
copied pivot table, not the original. You can then move the sheet into the
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"MRIreland" <MRI...Equation connecting two data quantities
I have data like this: in an excel sheet.
Q C Equation
1 2 3 4 ; 22 44 34 55 88; ?
Is there anyway that I can get an equation connecting these two quantities Q
and C, (data arranged in this manner only, as I have lot of data where in I
cant put that in two separate rows because of some constraints)
Can I get a formula connecting these two variables in the quation cell.
Assuming that the data fits a linear plot (and that you have a typo):
read help on SLOPE and INTERCEPT
If not linear; find how to draw a trendline; find trendline...Excel 2002 cannot copy data from website to excel
I have data in a website that looks like the following
US 04872 - CASS CITY CASMI CTR 2
US 04881 - FLINT-SOUTH 4881 CTR 2
US 04885 - MOUNT PLEASANT MTPMI CTR 2
In previous versions of excel, when I copy this data it would put
US in column
04872 in column
- in column
CASS CITY in column 4 and so on
The problem is now when I copy this data and try to paste it into Excel 2002 I receive the following error "Microsoft Excel cannot paste data"
What should I do? - Paste Special as text is not a good option cause it doesn't...missed data
The following Vlookup formula has this link to another workbook
supposedly in the same folder where the workbook is placed, but there
is no such a file with this name, where is this DATA.xls stored
=BUSCARV($B76;'C:\Documents and Settings\rjimenez\Mis
thanks for your help
rjl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30117
View this thread: http://www.excelforum.com/showthread.php?threadid=498475
&...Letter Writing assitant to be used with Prospects
Would like to see Letter Writing Assitant to be extended to be used with
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=73b8a531-e5c3-4d8b-91ae-5b1758b9f1a5&...double clicking and draging a column in a chart to chg data
in Excel 2003, double clicking on a column in a chart and then dragging the
column up or down would change the data in a table upon which the chart
How does one do this in excel 2007?
That feature has been removed in 2007, there is no way to do it.
If this helps, click the Yes button.
"Tom of inns" wrote:
> in Excel 2003, double clicking on a column in a chart and then dragging the
> column up or down would change the data in a table upon which the chart
> How does one do this in excel 2007?
&g...Various XML streaming problems
I'm trying to process a MemoryStream of XML data, which at any point in
time may have incomplete fragments (because data arrives from a
If I process data until XmlTextReader.Read() returns false, fills it
with more data, and reverses the position of the underlying
MemoryStream, the XmlTextReader immediately stops working. I apparently
have to re-create the XmlTextReader instance when I make changes to the
The XmlTextReader constructor apparently advances the position of the
MemoryStream to the end even before I've tried to Read(), which makes
it hard to know ex...how can i transfer data from one sheet to another without blank li
I have extracted data from a system to a sheet including blank lines between
Any idea of how i can transfer the data from one sheet to another without
any blank lines, in order to do my job using excel functions?
Thanks in advance
If you mean blank rows why dont you just sort the data?
In case you need to retain the order (you can use a temporary column);
insert an additional column say A. Number 1,2,....till the end in cells a1,a2
...... Sort col B. Delete the blank rows..and then sort by ColA...Remove ColA
Jacob (MVP - Excel)
"Manos&q...Leading and trailing spaces trimmed with SQL XML
I am inserting data into a table using xml bulk insert. One of the
field is of string type and contains data with leading and trailing
spaces. But on insert the spaces automatically trimmed off. Can you
please tell me how to avoid this trimming of spaces, as i have to
insert data using xml.
EXEC sp_xml_preparedocument @hDoc OUTPUT, @InsertLines
INSERT INTO tblLine WITH (TABLOCKX) ([Text]) SELECT [Text] FROM
OPENXML (@hDoc, '/Lines/Line', 1) WITH ([Text] nvarchar(max))
EXEC sp_xml_removedocument @hDoc
bad_clone (email@example.com) writes:
...string.Replace((char)146, (char)39) does not work?
Can anyone tell me why this code doesn't work?
// Key = Char to find, Value = Char to replace.
Hashtable specialChars = new Hashtable();
foreach (DictionaryEntry entry in specialChars)
this.label.Text = this.label.Text.Replace(Convert.ToChar(entry.Key),
> Can anyone tell me why this code doesn't work?
Because C# strings are UTF-16, not some random extended ASCII encoding
you've chosen to use.
Hint: if you are casting numeric literals to System.Char, your code is