Help on Excel controls
Hi, how or where can I go to get help on the use of the
various controls that I have access to in the "More
Controls" option of my VB toolbox? In particular, I want
to employ a dialog box allowing the user to choose a file
to process. It's been awhile since I've done this outside
of Excel in "regular" VB and I don't remember the code to
make the dialog box appear and reference a default
location, etc, etc.
Be very careful with "more controls", they must be installed and licensed to
run in design time on...Word 2003 has no Menu items showing
I am unable see other than the outer frame. Is there a keyboard short cut to
restore the menu bar?
Microsoft Word MVP
"Charles W Davis" <firstname.lastname@example.org> wrote in message
>I am unable see other than the outer frame. Is there a keyboard short cut
>to restore the menu bar?
Stefan, Thank you. That worked perfectly.
"Stefan Blom" <StefanBlom@discussions.microsoft.com> wrote in message
...Using 2 versions of Mac Office 2004 (Japanese and English). How do I set the default for which version my machine uses to open office files?
I using 2 versions of Mac Office 2004 (Japanese and English). How do
I set the default for which version my machine uses to open office
files? It would of course be better if MS allowed users to switch
menu languages within the program just as Mac does with its OS and
associated software. But since that is not the case, I have had to
purchase install the English version of Office 2004 (at great expense
both monetarily and memory wise). When I open files already on my
computer it always opens them with the "default" version of Office
2004 which is in Japanese. I can't seem to ...exchange 2003 rule wizard not working
I had a email rule set-up which use to forward a copy of some emails I received from selected people in my mailbox to my home email address, and also move it to another folder now since my work has moved to active directory from novel this does not work.. please note it does move it to the other folder just doesnt forward it to a external email address
Any ideas why this doesn't work anymore and how it can be resolved. or if there is a setting or something that needs to be changed.
Any help would be appreciated
Automatic forwarding and replying to the Internet is disabled b...Using Lotus 123 command in excel 2003
I m using Office 2003. But problem is that there i could not able to use
lotus 123 command.
Please help me
Rao Ratan Singh
Why would you? I believe it allows for some things to be done and you can go
to tools>options>transition to change a few things
(No private emails please)
"Rao Ratan Singh" <RaoRatanSingh@discussions.microsoft.com> wrote in message
>I m using Office 2003. But problem is that there i could not able to use
> lotus 123 command.
> Why so?
...Out-of-office twin replies
I've seen some posts here with regards to OOO replies
generating two replies, one of which is blank. This is
happening on at least two different versions of Outlook
and Exchange 5.5/2000 so it appears to be a server side
Does anyone have a solution to this?
...outlook 2003 #358
I work with outlook 2003, and I ned to download only header of mail.
How can I do?
Outlook\Tools\Options\Mail Setup\Send Receive and highlight your account and then
Edit and look on that page and it will show you there on what to do
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"xxx" <email@example.com> wrote in message
> I work with outlook 2003, and I ned to download only header of mail.
> How can I do?...Vista
I have just purchased a PC with Windows Vista already installed, and have
installed Microsoft Office 2003 on it & registered it.
However, whenever I launch Excl I am confronted with a screen showing a
Microsoft Office End Users Licence Agreement which requires me to agree to
each time before the programme will launch.
Does anyone know how to stop this happening?
You registered but did you activate?
Gord Dibben MS Excel MVP
On Thu, 6 Dec 2007 22:55:54 -0000, "Gunga" <firstname.lastname@example.org> wrote:
>I have just purchased a PC with Windows Vista already installe...0x8004010f error starting Exchange 2003 info store
I've deployed a few Exchange 2007 servers in our org and moved some mailboxes
to them. Additionally, I've moved some roles (OAB generation, RUS...) to
those Exchange 2007 servers. Immediately, and without warning, our Exchange
2003 servers are no longer able to start their Information Store or MTA Stack
services. When trying to start the info store, I get these two errors:
Event Type: Error
Event Source: MSExchangeIS
Event Category: General
Event ID: 1121
Time: 4:34:13 PM
Error 0x8004010f connecting to the Microsoft Act...Office 2007
I have Office 2007 installed on an WinXP machine.
I've added to my start menu the following short-cuts:
New Microsoft Office Document
Open Microsoft Office Document
I have a few questions,
1. What is the default location of the files listed in the New Microsoft
Office Document window?
2. Can I add tabs to the New Microsofot Office Document window? If so, how?
3. What is the default location for the Open Microsoft Office Document
Assume I've made no changes to the install of Office 2007.
Your assistance and help is greatly appreciated!
...Outlook 2003 Message Field "In Folder"
I am having a problem (I think) with moving messages in
Outlook. I move a message for example from the Inbox into
the Drafts folder, and the "in folder" field on the
message shows Inbox, instead of Drafts. This only seems
to happen when moving messages to the Drafts folder. Is
this meant to do this or should the "In Folder" field say
Drafts and not the previous folder the message was in?
Any suggestions or comments would be appreciated.
Appologies the user has informed me that this happens
when moving messages to ANY folder, the previuos folder
name is dis...Office Macros
What is the latest about when we will be able to upgrade our Office
for Mac so that it can run all of our spreadsheets with VB macros?
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."
- James Madison
The only official word from Microsoft is that VBA will return in the next
release of Mac Office which is tentatively scheduled for "Holidays 2010" - I
take that to mean late 4th quarter of next year. I would not expect to see
anything m...Exchange 2003 SP1 install problems
I am trying to install SP1 for Exchange 2003. I cannot seem to get past the
"Component Selection" window (which is right after the License Agreement
window. No matter what components I do or do not select I do not have the
option to select the "Next" button to continue. Anyone else experiencing the
same or knows how to get around this. Thanks.
Are you sure that you have installed the hotfix that is required for SP1? KB 831464? http://support.microsoft.com/?id=831464
Normally, when you are installing a SP, the action to be taken should be Update. If that option is...?? Continual Open/Write/Close to CSTdioFile -- is there a better way
I have an error log file (CStdioFile) to which I am logging errors using the WriteString method. However, if the program terminates prematurely, the file is empty (presumably due to lack of a Close being executed) and hence I can't see the key information that my program wrote to the file just prior to crashing
I think that I can explicitly Open the file (using CFile::modeCreate | CFile::modeNoTruncate) each time prior to writing a message, then write the message, and then close the file. However, this seems like a lot of unnecessary OS interaction
Is there a way to write messages...Send Exchange 2003 Out of Office Replies to non Exchange mail serv
I am new here, so please bear with me. I am hoping someone can help me. I
have looked and looked and looked for the answer to my question with no luck.
I am wondering if it is possible to setup Exchange 2003 Out of Office
replies to respond to a non-Exchange mail server within the same domain
without opening up to the internet. The reasoning is to prevent spam
programs from detecting legit addresses.
Main Mail Server for Staff & Faculty: Exchange 2003 Enterprise Edition
Main Mail Server for Students: SurgeMail from NetWinSite.com
They are in the same domain, but I am wanti...Can I enter a 24 hour time without typing colon?
I am an inexperienced Excel user. I have a new job
assignment where I have to enter a lot of data in
spreadsheets. A lot of the data is time in 24 hour format
such as 16:00 for 4pm. I am using the number pad and
have to continually shift to the keyboard to enter the
colon. The cells are formated for the 24 hour time. Is
there a way I can just enter the four digits and have the
colon inserted automatically without having to type the
colon in? This would be similar to formating for currency
or accouting where the decimal point and the commas are
http...Transfer / combining Excel data
I have a data worksheet created in excel with a column containing 5 digit
serial numbers, up to 300 diferent serial numbers (in individual rows). I
have the data sorted in assending order based on serial number column.
Serial numbers are random and not consecutive (ie. 05943, 05944, 05945,
05968, 05988 etc..)
1) I need to be able to select all the serials and transfer them to another
worksheet in excel, placing them in one cell, table, or ? - for purpose of
issuing a certification to our customer listing all the serial shipped- is
2) If they can be in be transfered, i...how can I build an online store with frontpage 2003?
I like to build a user friendly dvd, cd online store. How can I do it using
frontpage 2003 and where can I host this site?
Do you intend to accept credit cards on this site? If so, I suggest you
talk to your bankers before you go any further.
For hosting you will need a server that supports PHP, ASP or asp.NET,
together with a database server such as mySQL or MS SQL Server.
You may also need a security certificate installed.
PayPal can handle the credit card transactions for you, so you don't have to
deal with those.
For the site itself, look for a Shopping Cart appl...CRM Mobile 1st time registration
I have two new hp phone edition PDA's with MS OS installed. I used the
selfSSL to create a certificate. On the first users PDA the installation of
the .exe package worked fine. But when I tryed to add another PDA I get the
following error event log message.
Exiting service abruptly. Details: Exception details :
Source : .Net SqlClient Data Provider
Message : User does not have permission to perform this operation on view
Line# : 1
Message : User does not have permission to perform this operation on view
...Categories disappeared after upgrade from Office 2k3 to 2k7??
After upgrading from Office 2003 to Office 2007 all of my categories are
I still have a complete backup of my system containing Office 2k3 with
working categories, is there a way to manually transfer the Categories to
Any help in this area would be completely appreciated.
> After upgrading from Office 2003 to Office 2007 all of my categories
> I still have a complete backup of my system containing Office 2k3 with
> working categories, is there a way to manually transfer the Catego...Opening/importing data from database takes forever after upgrading office!
I recently reinstalled a users computer and upgraded his
office version from 2000 to xp. Now when he imports data
from a database it takes forever. It can take several
minutes and before the reinstallation the operation only
What could be wrong? I did the same on his coworkers
computer with the same result so there must be something
that can solve the problem. I just can't figure it out.
The run windows 2000 sp4.
Please help. :^)
It never hurts to empty the windows temp folder (with excel closed), but it may
You may want to take...Problem writing Time-Out function
Alright this one might seem a little odd. Basically when I initialize my
dialog I have to call a routine (RunSameThread) which unfortunately calls
some functions set with a library (which I don't have the source code for)
which may not exit. (Basically this call should initialize the COM port and
send's some commands to a transceiver attached to the port, then wait for a
response before returning). Now, if the transceiver is not hooked up (or
turned on) the COM port initialization will go though, but the library
function will sit in an infinite loop :(
Thus, I am trying to write a t...How do I change the data set on the X axis? (office 2003)
OK, so I created a frequency histogram (bar chart) by selecting the values
for the Y-axis, but I can't figure out how to change the values on the X-axis
to fit the rest of my values....
When I make the graph using both sets of data, it gives me two separate bar
charts on the same plane.
Help please :)
Remove the text in the top cell over the x-values; now make the chart.
Excel thinks you have two data series
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"jrexattack" <email@example.com&...Where do you find clip art in Publisher 2003?
I just upgraded from Publisher 97 to Publisher 2003 with digital imaging. I
have not figured out how to find clip art. I am used to putting the CD in to
pull up the clip art. I have uninstalled and reinstalled the program twice,
as I was instructed and still cannot get passed the insert, clip art command.
Thanks for any help,
Bunny <Bunny@discussions.microsoft.com> was very recently heard to
> I just upgraded from Publisher 97 to Publisher 2003 with digital
> imaging. I have not figured out how to find clip art. I am used to
> putting the CD in to pull up the cl...Excel Formula Needed
Our DPW director is looking for a formula that he can enter the date and
time that a plow driver started and the date and time that he ended and
have it give him the total hours worked
~~ Message posted from http://www.ExcelForum.com/
With start time in A1 and finish time in B1, in C1 put = B1-A1
Format all cells as Time.
If you need to multiply this by an hourly rate, you will need to multiply the
value in C1 by 24, then by the hourly rate, eg in D1:-
Ken....................... Microsoft MVP - Excel
Sys Spec - Wi...