Share data across web applications?
I would like to share data across two separate web applications. Is this
possible, other than with Cookies? If so, how might I do it?
I would like to pass non-sensitive information from one web application to
another, on the same web server and running within the same website. I'm
using .NET Framework v2.0 on a Windows 2003 server (IIS 6.0).
Jason Barnett wrote:
> I would like to share data across two separate web applications. Is this
> possible, other than with Cookies? If so, how might I do it?
> I would like to pass non-sensitive information from one...Keeping the format but update the data
I have a report I run everyday. I want to update the data, but keep the
column sizes and formatting. Any suggestions? Anybody suggest a good ebook to
become more formuliar with excel?
JoeM, this could be as simple as recording a macro during the formatting of
the sheet after importing the data once. Then each day, after importing the
new data, you simply run that macro.
As for online eBook's for Excel, I'm not actually aware of any although I
suspect a Google search would turn up several. It's hard to beat the "For
Dummies..." series of hardcopy...How do I get the data/xml/export option
My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?
One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import
(No private emails pleas...I would like to export the data from a drop-down list to a table
I have a form with several drop-down lists, I need to have the information in
these lists in another document/spread sheet. Is there an easy way to copy
the data in these lists to another location?
The long way would be to re-type all of it.
...changing sort order
I have followed the TK "How to BCP Data Out and Back into a New Database
(875179)" a few times and it seems to work great. However, when bcp'ng the
data back in, I do notice some errors as it flashes by in the dos screen,
however, NONE of the .err files show any size other than 0k. After logging
into Great Plains, I do notice that some information is completely missing.
I check the tables and they are empty. I checked the in and out bat files
and those tables are exported, then imported, the table is empty and its .err
file is also blank.
If the .err files do not show...Import data from Excel with main tasks and subtasks
I'm new to MS Project and need help with importing data from Excel into
Project 2000. The data consists of Work Request numbers, individual phase
numbers for the Work Request, name of each phase, and (phase) start and end
I can open the Excel file in Project and map the fields, however, the data
shows up as individual tasks. I need to have the Work Request number and
project name be a main, or top-level, task, and the data related to the
phases be sub-tasks.
Here's an example of how the raw data appears in the Excel file:
Phase# P...Can I move the data files?
I just installed Money 2005. I let it take most of the defaults, It
choose to store the data files in \My Documents. I would like to move
all of them to \My Documents\My Money.
Is there a way to do that?
Simplest way is to use My Computer or Windows Explorer. Navigate to your
..mny file, click on it, click on edit > copy, navigate to where you want the
..mny file to live and click on edit > paste.
When the file is in it's new home, double click on the file name. This will
call up Money and this will then remember where it found the file.
Now go back to the original locati...Move data from column to rows HELP!!!
Hi thanks for taking the time to look at my problem, currently i have
column that has thousands of rows of information in it, it looks lik
numbers that go on into mabye the 5000-6000 range
what i need to do is have that data moved So it looks like this
A | B | C
40432 | 32432 | 532
432654 | 523 | 523
3432 | 52432 | 111
532543 | 532532 | 222
So on and so on,
so instead of 1 column with 6000 lines it ...Copying specific data from Word to Excel
What I need to do is
1) Extract the monetary amount (always after the 2nd asterisk (*) after the
2) Extract the number (always after the 2nd asterisk (*) after the letters
3) Place the numbers in the same row on an Excel spreadsheet.
4) Repeat to the end of the document.
The file I need to extract from is always text.
Is this better done from a Word macro or an Excel macro. Or can it be done
at al...How do I sort a proctected worksheet
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Audrey" <Audrey@discussions.microsoft.com> wrote in message
That is a given, but I have columns that I don't want sorted.
I have locked those columns in hopes they would not sort and the others would.
Thanks for the help.
"Chip Pearson" wrote:
> Unprotect it.
> Chip Pearson
> Microsoft MVP - Excel
> Pearson...Free/Busy data setting in OWA
We implemented Exchange 2003 and pushed a client setting to all users to
extend the number of months available in free/busy to 12 months with a group
policy. It works fine if everyone is using the outlook client when they are
in the office. But, if a user works at home one day or goes to a conference
and does anything that updates the free/busy data, the OWA overwrites the
users free/busy data setting it back to 2 months of free/busy available.
Where can I set the free/busy data number of months available, in OWA? Is it
a policy setting?
On Wed, 31 Jan 2007 13:54:01 -0800, SKS <sks...Import data not in correct format
Import data reads: Need to do statistical anaysis on hundreds of numbers
Cell value # of Cells don't want to enter the numbers by hand.
...Restoring Exchange Data
HI. I experienced a crash with my Windows 2000 server which is the Global
Catalog and dns server.
Anyhow in my infinite wisdom I decided to do soemthing with the exchange
server and in the meantime - it blew any active directory info which had
replicated to the exchange server. The Exchange server was a part of the
domain with AD installed, etc. The exch. server is a running windows 2003
server w/ exch. server 2003.
Fast forward...I rebuilt the Windows 2000 server and its backup. I also
rebuilt the Exchange Server...not completely knowing how to proceed....I
installed w2k3 with all ...Adding data to a list
I have a list of data that I want to add to or subtract from and I would
like to be able to click on a button which would bring up a text box where I
could insert the new data then sort the new list.
Take a look at data>form
"Mike" <firstname.lastname@example.org> wrote in message
> I have a list of data that I want to add to or subtract from and I would
> like to be able to click on a button which would bring up a text box where
> could insert the new data then sort the ne...center data labels on my column chart
How do i get my data labels to appear in the center of
each column on my chart? Thanks.
Click on one of the labels
(that will select all the labels in the series)
Choose Format>Selected Data Labels
Select the Alignment tab
From the Label Position dropdown, choose Center
Immediately after formatting the first series,
if there are other series in the chart --
Select a label in another series
Press the F4 button on the keyboard, to repeat the
formatting from the previous series
Repeat for all series
> How do i get my data labels to appear in the center of
> e...topographical data maps in excel
I have seen this done, and would like to know how to create topgraphical maps
of data sets using excel. I want to take a sample of data ponts and plot the
points (easy), than color the plot based upon the values of the points
You seem to have been neglected by our community.
Yes, it can be done, if I understand your intention correctly. The
topography in your approach means, in a sense, the 3D chart. The first two of
the three values defininig each point specify the x- and y-coordinates (like
on a map); the third value is represented by prescribed colors or shades.
You must have you...Get External Data
I have the Office 2003 Student and Teacher edition of
Office 2003 on my home computer. I have occasion to use
the Get External Data, New Database Query function in some
of the work I bring home from work. On my version it says
it is not installed. Does the Student and Teacher edition
of Office 2003 in Excel have that option or will I need to
upgrade to a different edition to get that function?
see your other post
> I have the Office 2003 Student and Teacher edition of
> Office 2003 on my home computer. I have occasio...Get Subform Data
I'm looking for a way to get the data from a chosen record in a
continuous subform. I have a customer form and a continuous subform
with all of the charges associated with the customer. Is it possible
to have a button on the form, prompt the user to highlight a record
(the charge info.) in the continuous subform and get the information
about the charge?
If there is not a way to do this, I'm pretty sure that I can achieve
what I want to do via a list box.
Open the subform in design view, and set its Record Selectors property to
Yes. (This is a property of the Form, not o...Dynamic references in diagram source data?
Have encountered problems when copying and pasteing diagrams and their source
data areas. I wish to exclude the $ signs in the source data formulas in
order for the diagrams to retrieve data from different areas in the same
spreadsheet. This however seems impossible because excel automatically
reinsert the $ signs when I manually remove them from the source data
Any thoughts? Thanks.
...How to bind an ActiveX control to a Data Control?
I am building an ActiveX control and I need to bind my
control to a data control when using it in VB6. My
control is a multi column List. I know I should add a
property called "DataSource" that returns the recordset
of the Data control, then should move into the recordset
and add the records one by one to my list. The question
is how can I add the DataSource property and be able to
read from the data control and retrieve the data. Is
there a direct way or should I do it manually?
...copy data to differences places based on selection
I have a master list of entities name in master name sheets. Let say
entity 1 to entitiy 100.
If I select Entity 1 to Entity 10, these 1 to 10 entities insert below
group1, group2, group 3 in sheet1. It also insert below group4, group5
in sheet2. I don't have preference about how to select the names in
master list. Anything like check, or yes is fine to me. I am open to
any idea or method. thank you in advance.
...PDK Personal Data Keeper Timesheet Modification
Is it possible to modify the form for entering a timesheet in PDK? I would
like to have the project name as well as the project number display on the
time entry screen. Currently only project number displays on the timesheet
form, although you can see the project name in the related look up.
I would like to hear from anyone who uses PDK about how to make the product
simpler to use, or what product you are using in lieu of PDK to track time.
My e-mail address is email@example.com.
...Changing cell from formula to data.
Is there a way to change a cell from a formula (that is returning data) to
the data it is returning. I realy hop it it becuse it would help out a ton.
If you select the cell and copy then edit - pastes special - values on the
cell you will have the value and not the formula. HTH
Sincerely, Michael Colvin
> Is there a way to change a cell from a formula (that is returning data) to
> the data it is returning. I realy hop it it becuse it would help out a ton.
Select the cell(s) contain...Force data type from Text to Memo in a simple Make Table Query
I'm concatenating fields of various data types that upon completion sometimes
reaches around 500 characters. Not huge, but larger than the Text limitation
to which is what Access 2007 of course converts this. How can I force the
data type to be Memo while I'm in the query so the resulting table displays
all the data without any truncation.
I don't believe you can.
I think you'll have to create the table first, and then append to it.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"E...Business Data Lookup 07-11-06
I have installed the Business Data Lookup add on which is supposed to allow
CRM data to be inserted into office documents such as a Word file.
Inside of Word 2003, I see a "Insert from CRM" button, but when I click on
it, nothing happens. It is just clicked, but no options come up after that.
Is this a bug?
Office Equipment & Supplies
I think it is. I experienced the same.
On top of that it will slow down MS Office heavily. Forget it.
> I have installed the Business Data Lookup add on which...