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"...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.
-...PROTECTING FORMULAS #2
I have a sheet where when opened, it runs an auto macro to move cell
contents from one
column to another and uses a formula to do some calculations. If I select
the columns I want unlocked, then protect the sheet and try to run the
macro, I get an "run time error 1004 unable to set the numberformat property
of the range class" When I debug the following is highlightd
"Selection.NumberFormat = ";;;" " I was a Lotus user and in Lotus I
could select a range of cells or columns to protect, I'm having a hard time
to get Excel to do the same.
I appreciate th...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-Hfirstname.lastname@example.org> 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 ?
> ...Pressing Change Password -button in WIN XP causes reboot
I want to change my password.
I press Ctrl-Atl-Del buttons and then I press Change Password-button and
WIN XP Pro computer reboots immediately!
I can´t change my password.
...Read 3 txt input files and create an XL spreadsheet
I have 3 txt files that contain data and i want to generate a single
1 Text file contains the data as below:
USER = GARYG
2. Text file contains data as :
GEN WINDOW_LIST GARYGWL
EXCEPTION = N
,INSTALLATION_DATA = NONE
3. Text file contains data as:
DEFAULT_WINDOW = NONE
,WINDOW_LIST = GARYGWL
The report i am looking should be like this:
USER ...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...How do I print a one page spreadsheet multiple time, each with i.
How do I print a one page spreadsheet multiple time, each with its own page
You might want to try this. I used the preview feature. You can use print.
There are may be techniques to setup one print call with new page numbers.
Public Sub Printsheet()
Dim Counter As Integer
For Counter = 1 To 5
Sub PrintSetup(PageNumber As Integer)
.PrintTitleRows = ""
.PrintTitleColumns = "&...protecting formulas
I am trying to find a way to protect formulas on a spreadsheet whil
still allowing users to put in new data. Is there a way to do this?
am using excel 200
Message posted from http://www.ExcelForum.com
unlock the cells where you want input and then protect the sheet with a
Format | Cells... | Protection tab | Locked = false (not ticked)
"Cherilyn >" <<Cherilyn.email@example.com> wrote in message
> I am trying to find a way to protect formulas on a spreadsheet while
...Microsoft Office Spreadsheet 10 ActiveX Object: Question?
I am using this object on an Acccess form and can populate it with some
spreadsheet data. On the form I can edit the data but it does not save back
to the spreadsheet. Is there a way of saving changes made via the object
back to the original spreadsheet... I assume there must be otherwise what is
the point of the data a being editable!!
Grateful any advice.
...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...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...Outlook 2000 will not save password
I have exhausted all my abilities to get outlook 2000 to
save passwords. Operating system is xp.
I have checked and verified settings
I have tried the repair feature
I have uninstalled and reinstalled
I have made sure the Security Accounts Manager is running
I have tried following the instructions from microsoft
knowledge based article 235861 which involves the
None of these have worked. My associate also uses
outlook 2000 and windows xp with no password problems.
My settings are identical.
Any other suggestions are greatly appreciated!!
...Issues with Integrating Multiple Spreadsheets for Reports or Queries?
We are keen to discuss and help with issues arising when needing to
query, or produce reports using multiple Excel spreadsheets (Multiple
Excel Spreadsheet Integration issues):
- We can=92t easily compare a choice of values in one spreadsheet with a
choice in another worksheet
- So we cannot easily answer the question =93what do all these rows have
in common with those rows=94
- We have to do a weekly report integrating multiple Project Plans,
Financial Analyses =85
- We spend tons of time cutting and pasting, sorting and merging =96 the
same process repeated every week...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
Totally close out of WLM. Confirmed that the "remember my password" box is
NOT checked. Open WLM. See my email address appropriately. Do NOT enter the
password but just close the window by clicking on the red boxed X in the
upper right hand corner. WLM thinks about it and then goes right ahead and
opens WLM without any password entered. What setting do I need to change?
When WLMail is running, does it say Sign in under the close button?
The sign in is for Messenger, Contacts, and other Live services.
When not signing in, WLMail uses default contacts.
Http ...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...merging data from 2 spreadsheets
I work in a school and often export or collect data into spreadsheets of
student grades and assessments etc.
I often have to combine different lots of assessments from 1 or 2
spreadsheets into one and do this by arranging windows or 'comparing side by
side' and go down the list of students in both files, (sorted by name) then
when the students are in the exact order of rows, I copy the columns of data
i want from one file into the other. This is very tedious and making me go
Is there a better way of doing this?? Like a query or something. Anything?
I'm using Off...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...Make Outlook ask for the password
I am using Microsoft Outlook 2003. As soon as I launch the applicaiton it is
directly taking me to Inbox. How to change the settings to make it prompt
for the password?
if you mean the email server password you can disable the
saving of the password in the email account settings.
>I am using Microsoft Outlook 2003. As soon as I launch the
applicaiton it is
>directly taking me to Inbox. How to change the settings to
make it prompt
>for the password?
You can easily add a password by clicking on:
File > Dat...Windows 7 Password Recoverey
Need Windows 7 Password Recovery options so you can recover your
Windows 7 password? If you need to get your Windows 7 password
recovered, then I will help you to do this.
I will help you to do this by giving you the best Windows 7 password
recovery options. This way, you'll be able to recover your Windows 7
password on the easiest, fastest and safest way.
the best way to recover your Windows 7 password is by using a Windows
7 Password Recovery program. This way, you'll be able to automatically
recover a Windows 7 password.
The program is called Password Resetter, and It...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...Forgotten Password on Excel Workbook
Can anyone help me. I have forgotten the password on a
worksheet. Is there any way to open the document?
Which is it?
Password on File to open?
Password on Worksheet?
Password on Workbook?
See links to other sites when at John McGimpsey's site.
Gord Dibben Excel MVP
On Sat, 24 Apr 2004 09:23:31 -0700, "mary"