Is it possible
I would like to know is it possible to make million dollar in the internet, if you have any suggestions, write on my forumhttp://isitpossible.truemillion.comMark...Numbers starting in 0
I have a csv file that has PO numbers in it. Some of the PO numbers start
with zero, which is required. When I open the file in Excel 2002, Excel
drops the zero off thinking it is a number not text. How can I keep Excel
from dropping the 0 off?
Try changing the file extenstion to .txt When you import
the file, set the column with the PO numbers to text
>I have a csv file that has PO numbers in it. Some of the
PO numbers start
>with zero, which is required. When I open the file in
Excel 2002, Excel
>drops the zero off thinking it is a n...having trouble creating chart to show monthly totals
I'm using office XP.
I keep a single spreadsheet were I record orders received.
Its a very simple sheet with one order per row.
In col B I place the date the order was received (in the format DD/MM/YY)
I'd like to make a chart (pie or column) which displays the total number of
orders per month so that I can see at a glance when were busy and quieter
I've tried using the wizard but all I ever get is a mess and not what I
expect to see at all.
I suspect I may need to separate my data by month? But is there a way for
Excel to work that out for itself from a sin...Aligning an excel table w/ a cluster column chart x-axis columns
I'm trying to create my own data table for the x axis of my cluster col
chart. The x axis is the months of the year. I want WSheet col A to align w/
the chart margin, col B to align w/ the Jan chart col, C w/the Feb chart col,
thru col M w/ Dec. How do I do this?
Every time I change the col widith of the excel columns, the chart stretches
or shrinks as the col width does. I can move the graph in the chart to line
up the first col, but then adjusting the size of the graph, moves the chart
around. Nothing seems to work to get all the chart cols to line up w/ the
I hop...Minimum permissions needed to create mailboxes
We have Windows 2000 Active Directory and Exchange 2000. How can I give someone the minimum permissions needed to create mailboxes without giving them Domain Admin or Exchange Admin permissions? Thanks.
I can give you a start.. not a whole solution.
Since mailboxes is nearly users in Exchange 2000 you must give the rights/permission to create a user.
I would delegrate at the lowest lever (OU) and run the delegation wizard and give him/her the rights/permission to creat user and Exchange attributes
Hope this helps :)
> We have Windows 2000 Active Dir...How to NOT autosend workflow created emails?
I can't find the answer to this. Is it possible to create an email as part
of a workflow and not have it automatically sent? I want to queue the email
as part of a sales process so that the opportunity owner can then modify the
email content or add custom attachments before sending to the contact. To
date, I've been creating tasks to send emails, but it seems a little
redundant. It's not uncommon that an email template still requires
considerable ad-hoc modification before sending that can't be accomplished
through slugs or dynamic content.
when you write .Net asse...creating a custom signature
I want to create a custom signature to sign ALL emails automatically.
Also wish to add to that below my signature my personal mission statement.
how do I do this?
The tutorial below can help show you how to create and setup a signature
in Windows Mail.
Hope this helps,
> I want to create a custom signature to sign ALL emails automatically.
> Also wish to add to that below my signature my personal mission
> how do I do this?
B...How do I create a dual axes column chart in Excel
Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
moment I add the secondary axis the bars are getting overlapped.
This example should help:
> Hi...I am trying to create a dual axes column chart in MS Excel 2003. But the
> moment I add the secondary axis the bars are getting overlapped.
...Personal Folders in OWA
I have just enabled OWA on our Exchange 2003 SP2
through ISA Server 2004. Is there any way to
access personal folders in OWA?
Thanks in advance.
If by personal folders you mean .pst files, the answer is NO! Sorry.
C C wrote:
> I have just enabled OWA on our Exchange 2003 SP2
> through ISA Server 2004. Is there any way to
> access personal folders in OWA?
> Thanks in advance.
"C C" <firstname.lastname@example.org> wrote:
>I have just enabled OWA on our Exchange 2003 SP2
>through ISA Server 2004. Is there any way...Downloading Statements Directly Not Possible
I have Money 2002 installed on an Win XP Pro SP1 machine. Something
happened and I probably did it, that causes the statement downloads not to
go directly to the account. Rather they want to be saved in a file and then
opened into Money. I then have to delete the download.
I have tried several things in order to fix this:
1. I verified the file associations of OFC, OFX were correct. They were.
2. Lowered all my security settings in IE. Even put banks into Trusted site
zone. No go.
3. Made new accounts. Didn't help.
4. My IE cache is large (500MB) and regularly cleaned out.
5. I made s...Radar Charting problems, Can I change...
I have 2 queries relating to Radar charts in Excel (Office XP/2002).
Can I change the angle/start position of the first plotted point? I
always starts at 12 o'clock but I want it to start at 9 o'clock. I ca
re-order the data to achieve this effect but the data, to the viewer
is not in a logical sequence if I do that.
Then also, can I change the direction of the plotting from clockwise t
Thanks in advance.
Message posted from http://www.ExcelForum.com
You can't do these things (unless someone smarter than me knows how),
but you c...is this possible? reload a form that is based on a query with new query that is defined in the form.
I have a basic form.
The form is based on a query, so when I open the form, a pop comes up
where I enter in what I want to query.
So instead of 30,0000 records, I get 1-10 records.
on the form, I have a text box. I want to be able to enter in what I
want to query next and afterupdate have the recordset/form reload with
that query instead of my original qeury.
I figure this has to be done with VB. I am just starting to learn some
VB but I am lost.
Any info would be great, thank you.
You need to apply the new query or table name, or the sql string to
the forms recordsource, then...How do I copy a Word File to an email that has numbered lists in
When I send an email and copy a Word Document that has a numbered list in the
body such as 1. 2. 3. etc. the numbers for each line disappear in the
email message. How can I prevent this?
Email messages generally don't preserve formatting. Send the Word doc
as an attachment, or (probably better) convert it to pdf and send
On Feb 23, 4:05=A0pm, Edward P <Edward P...@discussions.microsoft.com>
> When I send an email and copy a Word Document that has a numbered list in=
> body such as 1. =A0 2. =A0 3. =A0etc. the numbers for each line disappea...Portfolio Manager stock chart
Since a few days, I can't get a stock chart when I click its icon in
Does anyone know why?
...Create Web Share
I know how to create shared folder.
But don't have any idea how to create a web share.
I'll appreciate any help/suggestion I get.
>I know how to create shared folder.
>But don't have any idea how to create a web share.
If I understand this correctly, you should be able to create a share like you
usually do on a server that has IIS and then you can reference it via a URL,
such as http:\\servername\sharename
I need to create the web share using vb.net.
"m...Set "ALWAYS CREATE BACKUP" Option
This is a multi-part message in MIME format.
In Excel, I keep setting the "always create backup" in the "save as" =
tools>options menu, but it keeps on getting erased. How can I =
automatically produce and keep backups in Word, and Excel on a times =
basis. Using Windows XP and MS Office Professional components if Office =
2000, although I have Office 2007, but have not installed it as yet? =
------=_Next...Possible to detect changes to an XmlDocument object?
If I instantiate an XmlDocument object, the load a file through the Load
method, is there a way, later on in execution, to easily determine if the
XmlDocument object has changed from the original version loaded?
I'd like to be able to check a condition to see if the document in memory
has been editted (i.e., nodes added, attributes changed, etc.) so that my
user can decide whether or not to commit changes to the disk file before
moving to another file.
Will I have to resort to re-loading the file, and comparing OuterXml
Gabe Covert wrote:
> I'd like t...My Bar Chart Is Missing
I have inserted a bar chart and I have used one of PowerPoint's built in
templates. I saved the presentation and now when I open it up the chart
outline opens up, the Chart Tools contextual tabs open up, I can view the
data, but the slide does not show the bar chart?
Your help is greatly appreciated!!!!
...Is it possible to compare a string and a field name
I have the following tables: Membership, Subscriptions, OfficeUseOnly. The
Office Table contains a Year, Year To and From [financial year] and the other
fields are the 5 membership types (regular, student etc) and these 5 fields
contain the different amount each type of member has to pay.
I want to create a form whereby on entering the financial year and the
membership type the correct amount is automatically inserted into the
FinancialYear - in current form = OfficeUseOnly SubsFinYear
and then if MemberType = 'Student' find Student field ...Bank reconsolidation/Create Outstanding list
Is there a template or macro that can match downloaded bank information with general ledger information exported to excel. Then create an outstanding list and list of discrepancies. Thank you.
If your downloaded bank information is in the form of a text or csv fil
then both can be imported directly to Excel.
Comparison then is relatively easy if both sets of information star
with a date field for instance
Message posted from http://www.ExcelForum.com
It's unlikely that there will be such a template because different
banks record the data in different ways.
If you can co...How to create a CImage into a COleDataObject?
I need to create a COleDataObject from a CImage to be used in another
application. But I can't get it right...
The receiving application works fine with PBrush-objects, but I can't
get my to look like that. Please help me!!
If I do like this:
oledataItem.CreateFromFile("temp.bmp", CLSID_NULL, OLERENDER_ASIS,
CString strProgramName = "PBrush";
LPOLESTR progid = strProgramName.AllocSysString();
CString strUse...mailbox unable to create for a user in exchange 2003
I am facing a problem with exchange mail box creation for a user in
Actually, we have a datacenter with PDC (like PDC.abc.com) and Additional
Domain Controller (like EXG.abc.com) with Enterprise exchange server 2003
installed in it. And I was installed a child domain (TEST0.test.abc.com)
with windows 2003 server standard edition, exchange server 2003.
Installation was successful and I didn’t get any error messages in
installation log file. And replication is happening properly from child
domain to PDC and child domain ADC and vise versa. Now, I am trying to
create a user in c...Create sequence number for table
I have a table with a Title field, comment field and a Sequence field. I
would like code to sort the table by Title and then fill in the Sequence
field based on the order of the records. The first record would have a
sequence number of 1, the second record a 2, etc.
Can someone help me with code to do this?
Thanks in advance.
"Phillip" <Phillip@discussions.microsoft.com> wrote in message
> I have a table with a Title field, comment field and a Sequence field. I
> would like ...Chart Variables
I am using Excel 2003. I'm using "Option Explicit" to force variable
declaration. I want to tie the axes of a chart that I have named "MyChart"
to worksheet cells. I've been working with the following but continue to get
Dim Cht as ChartObject
Set Cht = Worksheets("Model").ChartObjects("MyChart").Chart
.MaximumScale = Sheets("Charts").Range("C7")
.MinimumScale = Sheets("Charts").Range("C9")
.MajorUnit = Sheets("Charts").Range("C...pictures in various shapes
Is it possible to insert a picture and make it into a circle or an oval or
various other shapes than just squares and rectangles? Thank you ahead of
with a graphics editor
Microsoft MVP - FrontPage
"Stephanie" <Stephanie@discussions.microsoft.com> wrote in message
| Is it possible to insert a picture and make it into a circle or an oval or
| various other shapes than just squares and rectangles? Thank you ahead of
> Is it possible to insert a pict...