HI EVERY BODY
I AM NEW IN HERE AND I REALLY NEEDS HELP IN THIS ...PLEASE HELP MR
*set up a spreadsheet to calculate the amount of french franc you can
buy.all the answers should be rounded to the nearest french franc .
you have 1� equals 9.2754 franch franc*
thanks a lot
firouz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35235
View this thread: http://www.excelforum.com/showthread.php?threadid=550105
email@example.com...adding cross-functional flowchart changes page-layout
i would like to add to a "landscape" page a
stencil>flowchart>cross-functional flowchart shapes vertical.
when adding it the page converse automatically to a "portrait" page,
while it should remain "landscape"
the same happens if I add cross-functional flowchart shapes horizontal
to a "portrait" page. it changes into a "landscape" page.
can I avoid this?
I can't think of a way to avoid having the page orientation switch to
portrait when you drop the functional band shape out and pick vertical.
Visio automatically cha...Changing to Outlook
I have been using Outlook Express and now have Outlook. Have been able to
import address book and mail but emails are still coming to Express. How do I
change things so they come to my Outlook inbox? Thanks
You have to setup your account(s) in Outlook (Tools\Email Accounts in 2003)
and then quit using Express. You can also import your mail, address book,
and account settings from Express using the Outlook Import/Export tool
(File\Import Export...). Afterward, you should delect your account in
Express (Tools\Accounts\<select mail account>\Remove) so that you do not
accidently do...How change Sign-in Name?
I've been using Money for years. Recently I've changed my passport
account email address because the old one will no longer be available to
me in the near future.
When starting Money, I entered the new email address and password and
Money allows me to log in.
However, the issue is, the next time I start Money, the old email
address is back in there and I must enter the new email address every
time I start Money.
How can I change the Sign-in name to same the correct email address?
(I tried File/Password Manager and it will show the new address... until
I close and re-open mone...How to prevent item changed in a CListCtrl?
I use MFC Visual C++ 4.2.
I have a CListCtrl in a Detailed View.
Below the CListCtrl there are a few CEdits to display the value of each
So it's kind of the data form.
I need to do like this:
If users has changed one of the CEdits BUT they haven't save the data and
they want to change the selected item of the CListCtrl to other item, a
confirmation message will appear to ask if the data they have been changed to
be saved or not.
There are 3 options:
Yes: the data change is saved and the current focus is on the item user
No : the data change is NOT saved and th...change date in a sql statement from a cell
I am using Excel 2007 I have a pivot table that gets refresh everyday. The
data from the pivot table is based on a sql statement, which the data is
connected to a AS/400 table. Here is my problem every morning I go in the
connection properties and change the SQLstatement (date) in the command
text. I don't want my user to do this. What other option can I do? I was
thinking change the date in a cell (A1) and somehow the SQL statement picks
up the new date or maybe some sort of parameter, but I am clueless in how to
do this. Any tips or website to visit I will a...Data labels: need value AND % change
I'm working on a series of column charts that show annual data for #
sold, $ volume, average price, median price, etc. I want it to show
the 2002 and 2003 values for each of these but I ALSO want to be able
to show the % change between the 2, so we can see trends.
So far, I only see that you can label the data with the value, or the
percentage. I haven't seen how you can show the values AND the %
change. Any ideas? I'd really appreciate it!
Message posted from http://www.ExcelForum.com/
Create the desired label in a separate column (the 2003 price
concatenated with t...How to create treeview active control as another activex control's child?
I want to create an activex control who will wrap a treeview active
control but has some its own logic. I don't know how to create it and
how to set its position and size. say,if I want my active control's
size is the same as the treeview active control. Any idea ?
...setting timeout in XML controls
Is there a way to set a timeout in either MSXML or in .NET's XML classes?
If you're using MSXML4.0 take a look at the ServerXMLHTTP:
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
"Buddy Ackerman" <firstname.lastname@example.org> wrote in message
news:uHqaoAkmDHA.2068@TK2MSFTNGP09.phx.gbl...Form Header Control problem
I have a form based on a query that displays fields in the form header and
data is entered in the detail section. When I use the record selector to go
through the records the data in the detail area is updated but not the header
section. I added the header section so that I could insert a tab control at
the top of the detail section. Thanks in advance for any input.
...ActiveX Property Page OK button
I would like to know how can I trap ActiveX Property Page OK button
event ? I want to do some checking of property controls before user
clicks on activex property page OK button..please help.
...Changing Outlook 2002 email "From" field without the "on behalf of" text
I occassionally want to send emails from an address
different to my standard email account. I'd prefer not to
have to change the email account details on these
occassions. I have the "From" field in my New Mail
template which I populate with a contact showing the email
address I want the email from.
Unfortunately, when the email arrives it appears as
From: [mailto:myEmailAccountAddress] On Behalf Of
I've searched my Outlook settings and the MS site but
cannot see how to get rid of this undesired annotation
i.e. "[mailto:myEmail...Pick list width changes by itself...why?
I have some columns with the width 4. Sometimes the validation pick list is
wide like 40 and sometimes it is only as wide as the column. I already know
there's code to temp make the column wider when you click on it. But this
behaviour of the pick list sometimes appearing much wider than the column
makes me think there's something influencing the width of the pick list
itself. Is there some way to control the width of the pick list without
changing the width of the column or is what I'm seeing occur just an Excel
...How to change appearance of the links, pointing to subdocuments in the master document
I want to change the appearance of the links, which are pointing to subdocuments in the master document (Word 2003).
Specifically I want those links to look more descriptive with regards
to their contents - specifically making those links to appear like
those are entries in the Table Of Contents (like it would be looking
if those subdocuments were just paragraphs in the single monolitic
document). Please note that I DO NOT want to rename the filenames of
those subdocuments - I just want to change the appearance of the links
to those documents, in the way I already described above....Excel should have a "Change Case..." menu Item like Word!!
See the subject, I know you can set up a formula to do it I want a button!
PLEASE, for years I've just wanted to change case on the fly, YEARS!
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=3c7554c...I did install Genuine Advantage ActiveX control. But why could not find it in my IE Add-ons List?
Several days ago, I downloaded Windows Mobile Device Center from Micorosft
web site for my Windows 7. As it needed Windows Genuine Verification, I
installed the Genuine Advantage ActiveX control for my IE8.
But now, I can not find this activeX control in my IE Add-ons List( IE ->
Tools -> Manage Add-ons options of Internet Explorer ).
Anyone could tell me why and where?
Thanks in advance.
It installed and it is not removable in any shape or form. Once done (Genuine
Advantage ActiveX) it is done :-)
Please Reply to Newsgroup for the benefit of oth...Change Display Order in Charts
I have an X-Y chart with a cloud of points and a line. When the chart plots,
the line is always hidden behind the cloud of points. Can I bring the line
to the top so it becomes visible? I tried making the line first and last,
but it always ends up behind the cloud.
Lines for a given chart group (group of data series) are plotted behind
points of that same chart group in an XY chart. However, you can change the
chart group by changing the axis on which the chart group is plotted. Make
the plot with one series formatted as markers only and another as lines
only, double cli...Get control of a Userform by the Name
I want to change the text of a form.
I know the name of the form and the name of the control in it.
How to get the control of a form if I know the Name?
Below post refers to adding a form. But I already have a form, just
need the control of that!
Thanks a lot in advance
If you are talking about a VBA user from in VBA window press F4 (View
properties window) and click on the control....How do I calculate the change in stock price in excel.
How do I calculate the change in stock price from the previous day.
Put yesterday's price in cell A1 and today's price in cell A2. In cell A3
put the formula:
> How do I calculate the change in stock price from the previous day.
...How to control network shares programatically?
I am trying to discover a non-GUI method of recording a network
share's permissions and security settings, taking the share
off-line, doing a bit of maintenance on the data on the share,
bringing the share on-line again, and restoring all of the
security and permission settings. Only the top level (shared
folder) permissions and security settings need to be preserved.
The individual files don't have special settings.
The general NET SHARE commands can remove and install a shared
folder, but can't help record and manage the security and
permissions settings. I'm tr...Rules not working after profile change
1. I created a new mail profile to solve problem of email stuck in Outbox.
2, After re-starting Outlook, Rules to flag email and put in Alert window
3. In Rules Wizard '(for other machine)' now appears after each Rule Name
iin Wizard's first screen.
4. "On this Machine' is checked in options.
Any ideas on how to get the rules to work again without redefining them?
Unless you can open the old profile and remove the 'this machine only' tag,
or remove it from the rule, you]'ll need to make new rules.
Diane Poremsky [M...Control dispatch for module load ...98 OS
Is there any control dispathc for module load? Like "Create_Process" is
there for process create and whenever any process gets created corresponding
dispatch function gets called up.I want similar control dispatch for module
load or module terminate.Ex: If any .EXE or .DLL gets loaded i want my
control dispatch function to catch it.
I am using Win98/ME OS.Writing small Driver call "Process notifier driver".
...Date Format Changed when convert to Excel
there is a problem that when i convert the text file to excel then
date formart for the first 12 dates have been changed with "/"
sepreator and other remains with "-" that creates a lot of problem
please help to reslove the issue.
On Wed, 19 Sep 2007 22:27:06 -0700, Ather <email@example.com> wrote:
>there is a problem that when i convert the text file to excel then
>date formart for the first 12 dates have been changed with "/"
>sepreator and other remains with "-" that creates a lot of problem
>pl...Print 12/1/1 in cell (Excel changes it to date or another #
While trying to formulate a magazine order list, Excel changes the number of
magazines needed (12/1/1) to a number other than that typed into the cell.
What I need is the number 12 (for English), 1 (for MP3) and 1 (for Finnish)
in this particular cell. How do I get it to print the actual numbers?
try putting a ' infront of the numbers
"Say Goodnight, Gracie" wrote:
> While trying to formulate a magazine order list, Excel changes the number of
> magazines needed (12/1/1) to a number other than that typed into the cell.
> What I need is the number 12 (for Engli...Custom Properties Pop Up????
Is there any way to have the Custom Properties Windows, or the infor
contained in it, pop up when you click on a device?
We have a Visio Drawing of our Server Racks and it would be nice if we
had a feature that if you wanted info on a certain Server, all you have
to do is click on it or move your mouse over it and it would
automatically display the Properties?
Thanks for any help!
Open the shapesheet of your shape go to the event section and in the cell
"EventDblClick" put the formula DOCMD(1312). It will open the custom
property dialog of the shape.