Office Updates #2
How can one determine what update has previously been
accomplished in any Office product?
CES <email@example.com> wrote:
> How can one determine what update has previously been
> accomplished in any Office product?
Not all files are updated at every update.
Check the version number of this file:
/Applications/Microsoft Office X/Office/Microsoft Component Plugin
It gets updated at every update...
- Mac:MS MVP (Francophone) -
(MS) MVP: http://support.microsoft.com/default.aspx?ln=FR&scid=fh;FR;mvp
Newsgroups produits MS: http://support.micros...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <firstname.lastname@example.org> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Insert trigger
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...Not plot a data series in a chart but still display in data table
MS Excel 2007
I've somehow managed to display only two data series on my line chart. They
still display in the data table. How did this happen? More importantly, how
do I reverse it. I don't want to recreate chart.
I see the data series not plotted on chart in the Chart Elements and when I
select the series, the source data is highlighted; it's in the data table.
How do I make it visible?
HAve you perhaps simply formatted the data series as "no line, no marker"?
If so, you can format series, add some color.
Lu...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hemail@example.com> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Updating a table
I have query that relates to a table and i want to be able to automatically
insert a comment into a range.
I.E Table column is called Report name. I want to open the query and have
it ask me the name of the report. When i enter it i want it to
auutomatically enter the name in the column so that all the other information
that i add afterweards is associated with the report. I then want this info
to save when i exit.
Can anybody help?
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Calculation of weather data help
I have a data file (at http://www.weatherweb.net/cliall.dat) which contains
daily weather data from 1881 in the format:
dd,mm,yy,max temp,min temp, rainfall, sunshine, wind speed, wind gust,
What I would like to do is to calculate means for max, min, wind speed, wind
gust and pressure, and also total rainfall and sunshine for each month.
I would like the output in the format:
mm,yy,mean meax, mean min, total rain, total sunshine, mean wind, mean wind
gust, mean pressure
Can anyone give any assistance as to how I might do this in excel to create
a sngle file contain all th...Reading XML from a Continuously Updated XML Log File
We use an application that logs events to an xml file. I am
starting a project to read these events at they are written to the log
file and submit them to Operations Manager 2007 as custom events. I am
currently writing a C# console app to read this file using
XMLTextReader as part of a proof of concept. However, I am having
problems reading the file after the application logs a new event.
<?xml version="1.0" standalone="yes"?>
<Session appName="appName" version="4.0" cmdLine=&quo...How to copy specific columns until end of data
I'm trying to import data from 2 workbooks into a summary (combination)
workbook. The trouble I'm having, is I want to import only certain
columns and have excel know to stop at the last row with data.
For example, from Workbook1 I want to import columns A, B, C, F, and G
(from Sheet2). I want it to copy up to the last row containing any
data--right now that's row 1046, but next month it could be row 1267.
In workbook2 I'm fine with it copying the CurrentRegion--all columns
are important. BUT, it doesn't include the title/category heads in the
first row (Salesperson, ...showing data values on chart
in excel when mouse stand on chart,excel is showing the data values of that
point.how can to do this action in access?
Exactly the same. When you hover the mouse over a data point for a little
amount of time, a yellow bow should come up describing what's in your data
> in excel when mouse stand on chart,excel is showing the data values of that
> point.how can to do this action in access?
Where you insert chart?i insert chart on report,and i can't to see data value
on data point.
"Steve"...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...Editing data from 2 different tables
Could someone please explain to me if it is possible to edit data from 2
different tables that are being showed in the same form?
I created a form which shows fields from 2 different tables and I can not
edit the fields. I would like to be able to change/include data using my form.
The two tables need to be related in some manner and joined in a query for
the RecordSource of your form.
Elaine Parlato wrote:
>Could someone please explain to me if it is possible to edit data from 2
>different tables that are being showed in the same form?
>I cr...Windows 7 fails configuring updates
Windows 7 fails configuring updates
OS: Windows 7 Ultimate 64 bit
Antivirus: Avira AntiVir Personal
> Windows 7 fails configuring updates
> OS: Windows 7 Ultimate 64 bit
> Antivirus: Avira AntiVir Personal
All updates or a specific one ?
When did this issue start to occur ?
Click the Start orb > type the following in the Search field
Under Programs, click on windowsupdate.log
Scroll all the way to the bottom of the log for the most recent entries.
Copy and paste at least the last 50 or so lines of the log into your
repl...excel data to outlook
In my daily job, I need to flash some new data into my excel and use the
excel result to send out mails to report daily result. Is all numbers I need
to report in mails. Wonder if you can tell me if there is any tools to make
the data into text on my outllook.
I tried forming some string using:
="Today we booked "&Sheet1!A4&" MM vs."&Sheet1!A5&" MM expiry"
but when I copied this cells into my outlook, format is rare and pasted as
table / cells where I prefer to paste as text format ( which can be read by
boss with blackberry).
I asked ar...Exporting Data From Query Into Excel
How can I have this process automatically done to have the data from a query
after it's been ran to be exported into Excel in a specified location?
Ronald R. Dodge, Jr.
Master MOUS 2000
I have done some research on this method. While this method looks
promising, there's one limitation. It states one MUST leave the "Range"
argument as blank, when exporting data. The other thing I'm looking for,
putting data from a query into a worksheet, which the name of the worksheet
would be different from the name of the query. Based on the various things ...MSMoney 2005 Failed Update
In the past i was able to update my Account's transactions using
MSMoney 2005. Now i'm getting the message "Update not completed". I
don't really know what the problem is, but i'm able to get the
response from the OFXServer to MSMoney2005. When i analyse this
response with Microsoft's OFXAnalyser i get some "ERROR: Duplicate
FITID in <STMTTRN>:..." errors. I can assure that the transactions
refer to the same <ACCTID>. Can this be the cause of the unsuccessfull
MSMoney 2005 Accounts Update?
In microsoft.publi...Windows update installation problem under Windows 7 64 bit
This morning I noticed a message in the Action Center saying that
there had been a "Windows Update installation problem" dated two days
ago. A Windows update did not install properly, it said. I checked my
system and application logs for the past week and found no error
messages. I checked Windows Update history and I did an update for
Internet Explorer 8 on 1/23, two days earlier, that it said completed
successfully. I do see there is an Internet Explorer 8 update to be
installed.still and am assuming that must be *again*? So I am
confused. Do I have a problem or not? How do...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <firstname.lastname@example.org> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...Uploaded Checking acct data
Just successfully uploaded all 2004 (YTD) for main checking account.
That said, why does the calender not reflect the payments?
My calendar shows nothing just "Add New"
Is there some steps that I need to do or is the calendar information updated
only if I, step-by-step, pay bills in the system?
The data that you have uploaded will be in the account register, not in the
bills/deposits area which populates the calendar. To get it in the calendar,
you'll need to add it to the bills/deposits area. You can do this by either
entering it manually or by...How do you insert page numbers larger than 1000?
I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
Hi mregen (email@example.com),
in the newsgroups
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...Data quality software package
Thanks for helping us on our last question.
We have looked at different open source offers for data integration. And we
are now looking for data quality software able to complete the data
Are there any packages able to suit our needs? Different or same software
makers are fine for us.
On Mon, 25 Jan 2010 08:14:01 -0800, Guertas
>Thanks for helping us on our last question.
>We have looked at different open source offers for data integration. And we