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...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...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?
I need a simple Save-As macro but I need to save to the current name and
It's easy to record a macro to do the Save-As command, but it uses the
specific file name and path in the script. Is there a string that will just
reference the current file name in the current directory, so the macro will
work in any file without having to modify it. Don't ask me why, but I need
to do a Save-As as opposed to a Save to make a different macro work.
Save -As must do something slightly different.
Below is what I have now
ActiveWorkbook.SaveAs Filename:= _
...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...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.
...Problems with backupexec 10d second storage group info. store restoration.
We have three mail box mailbox groups, we backup the information stores
using backup exec 10d
I have confirmed that mailbox permissions are the same for all three.
But the problems is that when I try to restore using the recovery
storage group I am successful using backup exec for the first storage
group but it does not work for the second or third.
I have dismounted the first storage group and deleted the files and
have added the second storage group to the recovery storage group but I
get the below error.
The error from backup exec is:
Final error: 0xe000ff00 - Unable to restore some Mi...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...pivot table macro
I want to create a pivot table using the pivot table wizzard from a worksheet
into a worksheet with the name table by running a macro. when I record the
macro I create the pivot table using the wizzard and it works fine but when I
try to run the macro again it errors "unable to get the pivot tables property
of the worksheet class" any help?
Post the code you have created
"skippy51" <email@example.com> wrote in message
> I want to create a pivot table usi...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...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...Waiting for Input in a macro
In a macro I am running, the cursor is required to select a cell 'E1',
where the user is expected to enter some value and once the value is
entered, the macro should execute the remaining lines. However, I am
unable to cause the macro to wait till the input is actually entered
and the macro executes all the lines without waiting for input. Can
someone suggest a solution ?
ActiveCell.FormulaR1C1 = ""
ActiveSheet.PageSetup.PrintArea = "$A$1:$I$51"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Coll...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 ...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...Macros #20
Problem Description: The default file location to open and
save files on our network is our S:\ drive. However, I
have one excel worksheet that, when completed, needs to be
saved to a different drive (E:\ drive). Unfortunately, no
one remembers to change the drive letter when saving these
special forms, so these worksheets, that our auditors look
for, are never saved in the correct location and makes
them difficult to find when needed.
I want to create a macro so that after completion of this
special auditing form, the user can click a hotkey
sequence (CTRL-X) and the form will autom...Is this possible
I want to make a list of the files in several different
folders. Is it possible to somehow "Copy and paste" just
the filenames into a list, in either Word or Excel or
Wordperfect. I am just trying to sort the files in
several different folders to weed out duplicates. There
has got to be an easier way then typing them all or screen
printing the lists and manually weeding them out. Any
Here is some code that will start in a directory and list all files in that
and any sub directories. It uses recursion to go through all the subs.
Just ch...Is this Possible ?
Have a newsletter document with text boxes that have no outlines but
internal gradient colour fills.
Is it possible that a macro could remove all colour fills in one hit just
leaving the text in place ?
Dim oShape As Shape
For Each oShape In ActiveDocument.Shapes
If oShape.Type = msoTextBox Then
If oShape.Line.Visible = msoFalse Then
oShape.Fill.Visible = msoFalse
should clear the fill from text boxes that are filled and have no border.
<>>< ><<> ><&l...