Programming PowerPoint using VBA
I have been working on a project where I need to add some shapes to a
presentation using VBA. Of course I run the code as I test many times and
each time I do notice the shapes just keeping getting added to the slides.
What I don't understand is why the objects I am adding persist after the
slide show is no longer executing. They even remain part of the presentation
when I close and reopen it. Why is that? I haven't even saved the
I know I am missing something fundamental here, but it has been difficult to
find a resource on the Net to explain away my co...Using Microsoft Help: Add Text Boxes, etc.
I have MS Excel 2000 (v. 9.0.3821) and need help on working with its
map function--the MS Map in my Excel is MapInfo version 8.0. I have
never used it before. My eventual goal is to import this map into a MS
For a upcoming report, I'd like to do a few maps of the U.S., where
I'd be able to congregate neighboring states together into separate
regions and add some text annotation. I'd also like to individually
color selected states.
After receiving help from a Word group and some hair-pulling, I
managed to create a map in MS Map, put it in MS Excel, ...Use Value In An Adjacent Cell
I would like to find the maximum number in a column of numbers and then use
the value in the cell one cell above and one cell to the right of the
maximum number. Can someone assist me with the formula?
B C D
10/25/2004 57,636 19.039
11/03/2004 58,015 19.627
11/12/2004 58,431 17.774
This formula will return 58,431 (the maximum number in the range)
Once I find that number I need the value one cell above and one cell to the
right (19.627 in this case).
...Generate number NOT using a form
I've searched hi an low on this site and others, and the nearest match was a
question from Galaxykid in November.
I'm running Office 2000 and have used the Template Wizaed to create a
template that is used as a form to input data into another spreadsheet. I
would like one field on the template (which appears as a spreadsheet NOT an
Excel Form) to generate sequential numbers for each new record that is
entered and saved using my template.
I know it can't be that hard but I've been trying to figure this out for two
Thanks in advance.
Try loo...Import Data using Forms
Can anyone tell me how I can set up a form to import an excel sheet into an
exisiting table in access?
You can use the TransferSpreadsheet Method to import a spreadsheet. The
click event of the button would run the code you write for the import.
"carolini" <firstname.lastname@example.org> wrote in message
> Can anyone tell me how I can set up a form to import an excel sheet into
> exisiting table in access?
> Thank you!!
On Mon, 23 Apr 2007 12:24...Using IF and MAX (and IF and MIN) together
I am a newbie to Excel. I have a spreadsheet for a class in which I am
required to find the most sales by using IF and MAX. Also, I must find the
least sales using IF and MIN. Can anyone help me put a formula together?
> I am a newbie to Excel. I have a spreadsheet for a class in which I am
> required to find the most sales by using IF and MAX. Also, I must find
> least sales using IF and MIN. Can anyone help me put a formula
Assuming your sales figures are in A1:A100, use
*=max(A1:A100) * to determine the maximum number in the range a...Is it possible to use USB ports in Visual C++ 6.0 (MFC)?
> Best regards
It depends on what you mean by "use."
"Nikolaos D. Bougalis" <email@example.com> wrote:
>> Best regards
> It depends on what you mean by "use."
Now that is really helpful, how about "communicate with USB device" ?
In my case I have a GUID and driver supplied by the device
manufacturer, but cannot see how to use them.
I have a gsm phone. I want to write a program that will send SMS. My gsm
phone can be connected to my computer from USB . S...Change xlstart path
Is there a way to change the path of the xlstart folder , so that it points
to a network path. I know there is an alternate startup path but that is for
XL templates. I need to point to a macro , so that the macro starts up when
Hope this makes sense.
I wouldn't change this setting (even if I knew how). And I wouldn't want you to
change it for me, either.
Have you thought of just telling people to install an addin:
and point to that network workbook
> Is there a way to change the path of the xlstart folder , so that it points
...Problem adding email account in outlook 2002
problem adding hotmail account to outlook 2002
<firstname.lastname@example.org> Sent: 1/21/2004
I'm running into a problem UNSUCCESSFULLY connecting to
hotmail after adding a hotmail address to my Outlook 2002
email accounts. I've successfully added one previously
and have double checked all the setup information is
correct (http server, email address, pw, etc.). I can add
the account but not connect to the mailbox. I get
a "timeout from server" message. I've been trying to
troubleshoot this but ca...How to get the value of AD user attributes in vbscript?
i want to get the field value of the AD user address attributes in VBscript.
just like city, country, etc.
how can i get it?
thank you very much.
The ones you are interested in are
"Kino" <Kino@discussions.microsoft.com> wrote in message
>i want to get the field value of the AD user address attributes in
&...Can I use a 'lookup' to a Pivot Table?
I am attempting to compare one column of data (a list Employee numbers)
to another (on a different sheet in the same workbook, also of Ee #s
but not as complete) and put the number in the corresponding cell back
to the original spreadsheet. Since the lists aren't exact, I can't
simply do an (='other sheet'!A1)and drag it down. The lists are both
formated as numbers and in numerical order but not the same length.
The oddity is that the sheet I'm referencing to is a Pivot Table. I'm
getting a #N/A message.
Thanks in advance
You could use the GETPIVOTDATA function:
...Add a month
I have 1/4/04 in column A1. I want to write a formula in
Column B1 to add one month to the date in A1. In A2 I want
to add a year to A1. Result would show: B1=1/5/04 and
A2=1/4/05. How do I do this?
Your help is appreciated. Thank you
HTH. Best wishes Harald
Followup to newsgroup only please
"Newbie" <email@example.com> skrev i melding
> Hi All,
> I have 1/4/04 in column A1. I want to write a ...Am using avery business cards top margin does not print
I CAN SEE THE MARGIN IN THE PREVIEW BUT IT DOESN'T ALWAYS PRINTS. I'VE TRIED
DIFFERENT PAPERS AND DIFFERENT PRINTERS.
See http://word.mvps.org/FAQs/Formatting/BottomsDontPrint.htm for a possible
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"LSMITH DESIGNED EQUIPMENT" <LSMITH DESIGNED
EQUIPMENT@discussions.microsoft.com> wrote in message
>I CAN SEE THE MARGIN IN THE PREVIEW BUT IT DOESN'T ALWAYS PRINTS. I'VE...Help, please, adding on to items in a column...
I've tried, no luck, redefining contents of cells in one single column....
and would like to ask your help!
Column F is a truncated listing of email addresses (A thru E, name, tel,
However, this column only contains 'jdoe', which is their first initial and
last name- which is how the email system is set up..(jgarcia, rstarr, etc!).
All of these are '@xyz.com'. Is there some way to add the ' @xyz.com' to
what is already contained? I tried defining as special, but that hasn't
Unless I'm doing it wrong??
--...Current Login Username
how can i getting username which is login in CRM 3.0 ?
please help me.
...Adding new Internet address
In Exchange 2003 how do you add a new email address? In
5.5 admin program you could add an Internet address as a
new address. Can't find in Exchange 2003 this ability.
You can add it directly on the AD user account object. Go to properties,
then click on the E-mail Addresses tab.
Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stu" <firstname.lastname@example.org> wrote in message
news:284b301c46435$970bbe30$a401280a...Error on saving a form, when few extra controls are added dynamica
I am dynamically adding a readonly textarea on a CRM form, which is
populated with some data, based on few conditions at runtime. Using
"Close" button, I get runtime error and data is not saved.
Code to add fields at runtime:
objAddress = oCurrentTab.appendChild(document.createElement('textarea'));
objAddress.id = 'objAddress';
objAddress.innerText = "Some Text which is to be displayed";
Can anyone point me to what I am doing wrong? Also i...Using DateAdd function with cell values
Both F7 and H7 contain a date yet this sub does not execute the
statements after Then.................Please help.
Dim TestDate As Date
TestDate = DateAdd("m", Range("F7").Value, Range("H7").Value)
If TestDate < Range("I7").Value Then
Read help on DateAdd. It is not two dates, but an interval and a date.
(replace somewhere in email address with gmail if mailing direct)
"loren.pot...using exchange 5.5 for calender sharing only
We have a client who is running an old exchange 5.5 server on a WinNT4 sp6
PDC machine for the sole purpose of sharing their calendar. They have
multiple pop accounts handled by outside ISP's and all of the clients (5)
have their own pst files stored on the server. they are able to send emails
with two of the three pop accounts but not their primary one - the one that
has a connectoid on the Exchange server. they get a replay saying
undeliverable. But the message itself is not returned.
My question is since there is no need for the exchange server to process any
mail do they need any speci...Two Computers on the same network using the one email address!
I have two networked computers sharing one email address. I have outlook
2007 and the other computer has Outlook 2003.
Is there a way that both computers can share the one email address with out
all mail going to one or other computer??
I'd appreciate any suggestions as mail is getting lost and mixed up.
Assuming a POP3 account;
Configure your account settings to leave a copy on the server. For details
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.how...highlight cells to obtain total without using formula?
In previous versions of Excel, I use to be able to select a group of cells to
obtain a total, without having to use a formula. The total would appear at
the bottom of the window. Is this function still available in Excel2003?
Do you have a visible status bar (Tools>Options>View, and see if status bar
(remove nothere from the email address if mailing direct)
"rdavia" <email@example.com> wrote in message
> In previous versions of Excel, I use to be able to select ...appending data to ms access table using ms excel
Help, I am trying to update an Access table that has one
field with a value that is coming from an Excel table. I
looked through several cites are I have been
unsuccessful. I believe that ADO would be needed to
accomplish the task. If anyone has a short example of the
code that would be needed in Excel to control access
please let me know. Thanks in advance
Here's a routine that I use to append daily stock price information to the MDB
file where I keep historical quotes. I have a generic function that sets up
the connection, rather than doing that in the sub itself.
Prices() is...Exchange 2003/AD/Anonymous Logon access
Looking at users in Active Directory on Windows 2000
Server with Exchange 2003 server.
Under Mailbox Rights on the Exchange Advanced tab,
the "ANONYMOUS LOGON" user has read rights. Should it?
If I try to get rid of it, it says I can't because it's
inherited, but I'm not sure where the PARENT to this tab
even is. All the users are under the standard USERS
folder in AD.
Not sure if this is what MS intends or if I have mischief
going on here.
...Setting up/using Analytical Acctg.
I have what I think is a very simple requirement. The client wants to be able
to track jobs. Specifically he wants to be able to run a report and see how
much money he made or lost on a particulr job.
Now this seems like a pretty straightforward and simple use of AA to me, but
it seems that simple still does not mean easy.
I set up AA with a single Trx dimension (JOBS), and assigned Transaction
Dimesion Codes (JOB01, JON02, etc).
I can post POs and Saels Invoices, distribute amounts to the various jobs,
and the Posting Journals (and AA porting journals) show all the correct
amounts. ...Adding 529 account to Money '06
I have a new 529 college plan I would like to add to my portfolio. The
account is made up of 5 mutual funds with an allocation percentage in each.
Under the investment drop down, it doesn't offer an option to add several
mutual funds and allow for allocation percentage in each. I would like to
allocate a percentage of my investment dollars to these 5 mutual funds as one
investment. Is there a way to do this?
In microsoft.public.money, JazzyJ wrote:
>I have a new 529 college plan I would like to add to my portfolio. The
>account is made up of 5 mutual funds with an alloca...