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" <email@example.com> 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"...Visio Viewer 2003 now available for download!
Microsoft has released the latest version of the Visio Viewer, compatible
with Microsoft Office Visio 2003 and all previous versions of Visio back to
Visio 5.0. Currently the English language release is available with other
languages to follow.
Microsoft Internet Explorer 5.0 or later is required for the viewer.
This posting is provided "AS IS" with no warranties, and confers no rights.
Outstanding! Thanks Mark.
Randall Arno...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.
How to download New Stationeries in c:\program
files\common files\microsoft shared\stationery .Does
administrator alone has the option of accessing
stationeries? or can i download too ?
Don't download the stationary and run it. Install it right from the website,
when it gives you the option to save, choose open.
"Guest" <firstname.lastname@example.org> wrote in message
> How to download New Stationeries in c:\program
> files\common files\microsoft shared\stationery .Does
> administrator alone has the option ...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.
...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...Unremoveable downloaded headers
I'm using Outlook 2002 in Windows XP Pro. I have about 100 downloaded
headers that I cannot remove. I believe that these files do not exist
on the server anymore. How can I remove these headers? I select them
all and hit delete but nothing happens. I cannot move them either.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
I had a similar problem as well in the inbox for 2003. I couldn't delete
the header because it says I have to download it from t...Downloads Same POP Messages Repeatedly
I'm using Outlook 2002 (SP3). Messages on my pop server get downloaded
repeatedly -- every time I send/receive. This happens only for some
The same problem is not occurring on the same server with the same account
in Mozilla's mail client, so it's not a POP server issue; rather an Outlook
I see several posts here with similar problems, but no solution. Is there
...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...Transactions not downloaded in Money 2007
I've used 2004 and 2006, so I know what to expect. I just downloaded 2007
and have it configured to sync with both Chase and Discover, and, although
it does get the current balances, it fails to download any of the
transactions. Since this occurs with both accounts, I assume it must be a
configuration issue on my side. Does anyone have any insight as to why I'm
seeing this behavior?
I've resolved this. I had to uninstall Money 2003, Money 2006, and Money
2007, reinstall Money 2007, and delete and recreate the accounts. Finally
after all this the synchroni...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...Is there any specific setting for MS excel to download CSV in fin.
I have set my local setting of my PC to finnish and trying to download CSV
But the data is displayed in a single cell instead of splitting across
Is there any specific setting that should be set in EXCEL to display CSV
files in the correct format?
try renamin the file to *.txt and open this file in Excel.
>I have set my local setting of my PC to finnish and
trying to download CSV
>But the data is displayed in a single cell instead of
>Is there any specific setting that should ...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...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...Where do I find the Publisher 2003 template I downloaded from Ms?
I downloaded a coupleof templates from the Microsoft Office site, but where
can I find them?!
When you download from the template site, you have to save the templates. Look in
your temporary folder, they maybe there.
If you cannot find the templates at all, empty your temporary cache and try the
download again. In Internet Explorer, tools, Internet Options, delete files.
Mary Sauer MSFT MVP
"1techgirl" <firstname.lastname@example.org> wrote in message
news:A1DE5675-A71C-46DF-8293-061F...insert downloads into power point
i downloaded an application called "BioDigital Simulator" of an animated
cleft lip/palate surgery and need it put into my power point presentation,
but can't fiugre out how to do so.... very frustrating...
What kind of file is this application? Is it a video? If so, what kind?
MPEG? AVI? MOV? Or is it an EXE file? Something else?
Which version of PPT are you using?
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoice.com/2010.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover...Insert dataset to another database
I'm posting this to this group also since it pertains to queries, primarily.
Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a
single query. But, I can't seem to get it to work, even in an experiment in
My sql in Access 2K:
SELECT D.lorder as Ord, A.Lorder
FROM [;Database = C:\MyDocuments\Acc2K\Wrk.mdb].OrdersData as A INNER JOIN
[;Database = C:\Access\Work\Sales06.mdb].Detl1 as D On D.Lorder = a.lorder
WHERE ((D.fg)= 'MXX-NC' Or (D.fg)= 'MXX.NC')...Fancier chart downloads?
Are their any free add-ins or downloads to dress up the plain and simple Excel Charts for Excel 2002?
Thanks for any help!!
Check the various commercial products. For a list search the
google.com archives of the XL NGs.
You can also check my web site and those of Stephen Bullen
(www.bmsltd.co.uk) and Jon Peltier (www.geocities.com/jonpeltier).
Tushar Mehta, MS MVP -- Excel
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <F88CF07D-9147-4F9C-9372-22B6E2AA27A4@microsoft.com>,
billg714@adelphia...Insert a blank row
I need some help to insert a blank row in a range where column A has a
series of dates. There will be several of the same dates and I need to both
sort the dates and then insert the blank row at the end of each sequence. In
the blank row I need to total figures that will be in columns B through to
maybe an easier solution
1. Sort your data (use 'Data - Sort', e.g., column A ascending)
2. Use 'Data - Subtotals' This will insert a row after each date and
calculate subtotals automatically for you
> I need some...How do I insert a letter into an existing word document?
I am working on a large document that I need to add several letters that are
on our letterhead. If I cut and paste the letter, the letterhead header
becomes skewed. This is just one issue I'm having with the document! Also
need to know how to merge 3 separate documents together once I insert the
letters that I need! Help!
What do you mean by "skewed"?
To preserve the data from the header of the document, you will need to
insert it into a Section of its own separated from the rest of the document
by Next page Section breaks before and after it with the headers...How do I insert backround into my picture inserts?
Could you please elaborate on your question, and give us details such as
your version of Publisher.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"TAMOS" <TAMOS@discussions.microsoft.com> wrote in message
How to Compose a Good Newsgroup Post
How to Act Smart on Usenet
Getting Your Post Noticed - and Answered
http:...How can i change chart data point format based on value?
I have a simple column chart with a single data series. I would like to
change the color of an individual data point column depending on value.
Thanks very much.
You want to make a conditional chart:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"Harold96" <Harold96@discussions.microsoft.com> wrote in message
>I have a simple column chart with a single data series. I would...Inserting images into excel conditionally
I have a large product price list (1200 items) with one column for quantity.
I would like excel to import the appropriate image for a product once the
condition entered is that quantity is > 0. Is this possible? If so then
can be adapted to your situation
"Pav" <Pav@discussions.microsoft.com> wrote in message
> I have a large product price list (1200 items) with one column for
> I would l...