/resetfoldernames switch is NOT resetting folder names
The default folders in my recently-installed US version
of Outlook 2003 are in German, and I can't change them to
I've tried "C:\Program Files\Microsoft Office\OFFICE11
\OUTLOOK.EXE" /resetfoldernames which runs, but doesn't
return the default folder names to English. (They remain
I've spent literally hours trying to resolve this
including complete reinstalls of MS Office Professional
Edition 2003 and Windows XP Pro, to no avail.
I tried the various versions of "Outlook Folder Name
Changer" from www.ntx.at, but I get runtime er...Help Me Convert Fraction
I'm trying to customize a worksheet to read the fractions such as 14/16 as
7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
out there explain to me how to do this? I'm using Excel2000. Thanks!! CB
Take a look here:
In article <email@example.com>,
"Charlie Brandon" <firstname.lastname@example.org> wrote:
> I'm trying to customize a worksheet to read the fractions such as 14/16 as
> 7/8, 4/16 as 1/4, 8/16 as 1/2 etc. Can this be done and if so, does anyone
> ...How do I merge 2 Excel files, each with different names and data?.
How can I merge two or more Excel files into one file? Each file currently
has a different name and different data. Thanks.....Chem303
see your other post
"Chem303" <Chem303@discussions.microsoft.com> schrieb im Newsbeitrag
> How can I merge two or more Excel files into one file? Each file
> has a different name and different data. Thanks.....Chem303
I also need to do this. I have one spreadsheet with a list of names I need
labels for and a...Naming Sheets in a Macro
I've run accross a problem many times in Excel where I'm running a
macro that creates new sheets - Sheet1, Sheet2, Sheet3 and I rename
these sheets in the macro using the following code:
Sheets("Sheet3").Name = Range("A2")
It would be helpful not to have refer to new sheets as
("Sheet1","Shhet2" ect) that i'm in when naming them though as it means
that i have to shut down excel and reopen it every time i want to run
the macro otherwise it will break (since the only time the sheets start
back at 1 is w...Can ping IP Address but cant ping name
I have below line mapping in \etc\hosts. a restart of PC was finished
after adding the below line. Below line is not the last line of hosts.
I can ping 192.168.1.10.
But i cannot ping SVR-23.
"DaveHenson" <email@example.com> wrote in message
>I have below line mapping in \etc\hosts. a restart of PC was finished
> after adding the below line. Below line is not the last line of hosts.
> 192.168.1.10 SVR-23
&g...saving a converted lotus file
When I take a Lotus 123 file and save it as an Excel file
and then open the file in Excel, Excel opens the file
twice. In the title bar is says name.1 and name.2. Why
There are two windows open of the file.
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"Pam" <firstname.lastname@example.org> wrote in message
> When I take a Lotus 123 file and save it as an Excel file
> and then open the file in Excel, Excel opens the...How do I set auto reply to incoming emails to both my name and ema
My Outlook Express auto reply via rules and alerts will only reply to emails
addressed to my email address and not those addressed to me.
I'm using Microsoft Office 2003. How do I get it to reply to both?
> My Outlook Express auto reply via rules and alerts will only reply to emails
> addressed to my email address and not those addressed to me.
> I'm using Microsoft Office 2003. How do I get it to reply to both?
"My Outlook Express"
So which e-mail client are you really asking about?
Is it possible to convert an excel file into a word file?
> Is it possible to convert an excel file into a word file?
You can imbed an excel file into a word document, otherwise no not as
such. You could save the Excel file as text and then open in Word. Why
would you want to? Excel is not a word processor and Word is not a
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
to email me remove the obvious!
...convert concencated field to date
Concencate a number of imported fields into a date - Is is not possible to
import the fields as a number. Basically these are the date field from on on
I have tried a number of things
DOB: (TableName!Day & TbaleName!Month & TableName!Year)
DOB: Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))
DOB: #Val((TableName!Day) & Val(TbaleName!Month) & Val(TableName!Year))#
DOB: ((TableName!Day) &"/"& Val(TbaleName!Month) &"/"& Val(TableName!Y...Select Last in Range
I am writing a macro to copy a list of data from one spreadsheet to another.
The list includes blank rows as separators. I want to select the entire
list minus the blanks. I don't know how many rows it has or how many blanks
there are. I would have preferred to use Selection.End(xlDown) but the
blanks stop the selection early.
My macro goes to the cell named "Start" and offsets one row down. This I
know is the top of the list. I then select 1000 rows below that, because I
know the list would never be that long. Then I have
Selection.SpecialCells(xlCellTypeConstants, 2...Graffic converters
Hi i have scanned in some photos using canon D1250u2f
scanner and have saved them as jpeg. When i am in
publisher and use the insert picture from file it tells
Publisher cannot convert this picture.This is because
either publisher does not recognise the format, or there
was an error loading the graffic converter.So on and so
on..... I have reloaded all graffics filters and am still
unable to insert this picture into publisher. Any ideas
whats going wrong? I have downloaded the latest drivers
for the scanner but do not want to spend hours downloading
all the office updates. Is th...convert HICON to HBITMAP
I am trying to convert an icon (already loaded by LoadImage), I have its HICON to a bitmap (HBITMAP), but I don't how. I CAN'T use GDI+( tried do with Bitmap class with the constructor and there was no problem), but I must use GDI.
Thanks to all.
HDC hdcScreen, hdcBitmap;
int x, y;
x = GetSystemMetrics(SM_CXICON);
y = GetSystemMetrics(SM_CYICON);
hdcScreen = ::GetDC( m_hWnd );
hdcBitmap = ::CreateCompatibleDC(hdcScreen);
hbmpBitmap = CreateCompatibleBitmap(hdcScreen, x, y);
Re...Adding a Second Domain Name to 5.5
I am adding a second domain name to our mail. I went into
the IMS and added blazierlaw.com to the routing group for
inbound but I get no mail. The Mx record is pointing tomy
server. what am i missing
The secondary domain name that you have should be registered with internic
or any internet registar '. Also the IP address of where that domain
should be re-routed to from anywhere on the internet should point to a
location or point of presence on the company wan that will send the mail
back to the e-mail server. if the new domain name cannot be resolved on the
open internet, any e-ma...Workbook name as variable to another workbook
Can you save a specific workbook name as a variable, to be used in a
different macro? i need the variable to be saved and available to return to
the specific workbook open if i have a lot of books open to complete the task.
Dim myWkbkName As String
myWkbkName = ThisWorkbook.Name
If you execute runmefirst first, then runmesecond, you'll see that myWkbkname is
available in the second.
If you need to put the routines in different modules, declare myWkbkName as
Publ...Convert uppercase to lowercase
Does anyone have a bit of code to convert a file of conatcts all in
UPPERCASE to Lower Case?
Mervyn Thomas;593677 Wrote:
> Does anyone have a bit of code to convert a file of conatcts all in
> UPPERCASE to Lower Case?
For each cll in selection.cells
cll.value = lcase(cll.value)' either this line or the next
'cll.Value = Application.WorksheetFunction.Proper(cll.Value)
p45cal's Profile: ...dynamically name worksheets
The first worksheet in an excel workbook contains cells that match what the
names of the following worksheets need to be named. We have one master copy
and new files are created from this master daily. Each new copy changes the
cells and the names of the following worksheets. Currently we are manually
changing the names of the worksheets (21 of them) every single time. Is
there a way to have the names change dynamically when we put the new value
in the first worksheet? Something similar to the way we have the heading on
each sheet change by using ='FirstSheet'!A2
Thanks......Linq To SQL and multiple foreign keys naming issue
I have two tables and one points to the other with three foreign keys,
but with different names.
The Linq To SQL designer generates integer fields for the foreign keys
with a meaningful name, but
the object instance with one row of the referenced table has not a
well meaning name.
Table Object -> Table Customer
Col CustBuy -> id
Col CustSell -> id
The generated code has integer fields like these:
But not meaningful names for the objects:
When using that in code, one does...how do you hide a name from the globel address book?
in exchange 2K.
Properties of the user
Check the Hide from Address Lists box
On Fri, 10 Sep 2004 20:34:05 -0400, "Dooma"
>in exchange 2K.
Thanks. Sorry I missed it.
"Andy David - Exchange MVP" <email@example.com> wrote in
> Properties of the user
> Exch Advanced
> Check the Hide from Address Lists box
> On Fri, 10 Sep 2004 20:34:05 -0400, "Dooma"
&...How do I convert cc's to a distribution list group?
I have received email as part of a 40 person cc and want to create my
own distribution list of those other cc's so I can originate messages to the
group (and not just use the 'reply all' key). Is there a way to move the
cc's from the header of an incoming email directly into a new distribution
group with out having to first make each of them a separate contact and then
move the contact into the distribution group?
Any help would be GREATLY appreciated.
Howard M. Rensin <firstname.lastname@example.org> wrote:
> I have received email as part ...Convert DST to STD Time on the Fly?
For a database in the U.S. that sees a lot of analysis, I've
decided that a little reduncancy is a good thing.
Our field crews record DST when it is in effect, but our
analysts would usually like to use Standard Time. So I've
decided that it's better to have a field for each, and have
the form code do the conversion at data-entry time.
But I've taken several runs at coding this, and always get
to a point where I realize my approach isn't going to work.
I'm guessing others have preceded me.
Anyone care to throw something in here?
Instead of saving...Not able to find pdf converter option in Outlook meny
Have installed Adobe Acrobat standard ver. 8 but still not able to find the
PDF converter option in Outlook meny
If it causes a problem with Outlook, it will be disabled. You will have
to re-enable it in Add-ins.
> Have installed Adobe Acrobat standard ver. 8 but still not able to find the
> PDF converter option in Outlook meny
...converting to email
was wondering how you make a publisher file into an email without it becoming
an attatchment. I know it can be done !do i need to go thru another
> was wondering how you make a publisher file into an email without it
> becoming an attatchment. I know it can be done !do i need to go thru
> another programme?
Be aware that due to security settings
some of your recipients will receive your
newsletter as an attachment no matter
how you set it up and may not be able to
view the message in the context that was
intended. This is why...@how to select Name Box from ...
How to select Name box and Formula Bar from keyboard? And how to rename a
worksheet tab from keyboard?
thanks in advance.
The F2 key will cause Excel to enter Edit mode. If the "Edit In Cell"
option is enabled, focus will be in the edit mode of the cell. If
"Edit In Cell" is not enabled, focus goes to the formula bar. For your
other questions, you can only address them with code. To set focus in
the Name dialog, paste the following in a code module:
Public Declare Function SetFocus Lib "user32" (ByVal hwnd As Long) As
Pu...Database replication and removing names of old databases
When you start the process of synchronising one database with another, you
are asked which databse you wish to synchronsie with. The dialogue box shows
ALL names of databases that you have previoulsy synchronsied with and this
list can become quite long (an dyou cannot always see the full names)- is
there any way of getting rid of the history as it were. I realise ofcourse
you can browse to the right database.
<JackatRelaxed@discussions.microsoft.com> wrote in
> When you start the process...Converting to PDF
I'm having trouble converting any Office document (mainly Word and
PowerPoint) into PDFs.
Clicking on the 'Convert to PDF' button tells me that I do not have a
PDF printer installed (even though I have a full version of Acrobat
Professional CS). The only way I can PDF these docs is to 'print' as a
PDF which gives me no output options and I end up with a PDF several
times the size of the original document.
Can anyone give me a pointer on how to get this problem fixed? I have
a PC that works fine (as in the 'Convert to PDF' button generates a
nice small PDF, not a g...