Excel macro to close powerpoint
I have an excel macro in excel 2000 which opens a powerpoint slide show.
How do I get it to close powerpoint when the show finishes?
sarahl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29281
View this thread: http://www.excelforum.com/showthread.php?threadid=490026
If you have a reference to the PowerPoint application, use the
where PPT is your reference to PowerPoint.
Microsoft MVP - Excel
Pearson S...Linking 2 workbooks
What is the formula/procedure to link an entry in a Source workbook to an
identified name in another workbook? Example: Sam makes numerous donations
over time that are entered into the main spreadsheet. Entry of a given
donation should automatically appear as a separate entry in his own
...2 different Deleted Items folders??
Decided to try Outlook after years with OE. Set up email and news accounts.
Imported messages from OE.
When I open Outlook, show Folders, I see Outlook Today - [Personal Folders],
Deleted Items, Inbox, etc.
I emptied the Deleted Items folder.
Then, View, Goto, News, show Folders, I see Outlook Newsreader, Local
Folders, then most of the same folders that I see under Personal Folders in
the Outlook window, including another Deleted Items folder, and this one
Where did I go wrong?
The Outlook Newsreader is actually Outlook Express which maintains its own
folder...MS Money small business for Canada #2
I would like to purchase MS Money small business to handle my company
accountings. I am located in Canada and was wondering how flexible this
product is to be customized for Canadian Tax system and payroll rules.
In microsoft.public.money, Alex wrote:
>I would like to purchase MS Money small business to handle my company
>accountings. I am located in Canada and was wondering how flexible this
>product is to be customized for Canadian Tax system and payroll rules.
The last such product was Money 2000.
Today only Standard is available for Canada.
Th...get number of monday, tuesday,... between 2 dates
Hi, how can I get number of monday, tuesday,... between 2 dates?
Racsus (Racsus@discussions.microsoft.com) writes:
> Hi, how can I get number of monday, tuesday,... between 2 dates?
DECLARE @offset int,
SELECT @day = 'Tuesday'
SELECT @offset = CASE @day
WHEN 'Monday' THEN 1
WHEN 'Tuesday' THEN 2
WHEN 'Mittwoch' THEN 3
WHEN 'Thursday' THEN 4
WHEN 'Friday' THEN 5
...Excel 2002 Create Workbook (merge/reformat)?
I have 12 seperate spreadsheets I want to combine into 1 workbook (12 tabs).
Any other alternative ways to do this other than copy and paste? Need to
reformat "most" of the worksheets, I assume this can be done if all 12 tabs
are selected. I may have to do this several times otherwise I would just
copy and paste. Each spreadsheet has an average of 3k-4k transactions.
You can open the workbook, ctrl-click on the worksheet tab and drag that
worksheet into another workbook.
(Then close that "sending" workbook and open the next...)
> I have 1...MSPOS 2.0
To change the behavior of the screen's min/max buttons one must enable it
through the POS View. Need to be able to set this in Manager View also for
non-POS machines without having to hack the database.
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.m...Auto Format #2
Can't find Auto Format, did excel 2007 decide not to have this function, is
there a similiar function to be used instead of autoformat?
If you want to select a formatting for your table select Format as Table in
the Home Tab of the Ribbon. I believe that is the replacement for the Auto
Format command in the previous versions of Microsoft Excel.
Hope this Helps!
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel
> Can't find Auto F...Excel file takes a long time to save
I have a 1,000 x 15 straight worksheet with no formulas - about 100K.
I went to auto-format a pattern, but didn't select the area and
if formatted the entire spreadsheet. It's since gone from 5 seconds
to 60 seconds per save and I can't reverse this, even by changing
the auto-format setting to "none."
I'm backed-up, but the current version is about three hours ahead and it
will take longer to retrace the work by hand.
Try resetting the last used cell.
Debra Dalgleish has some techniques at:
http://www.contextures.com/xlfaqApp.html#Un...Excel 97-remove link but keep data
I have a pre-existing excel 97 s/s which has links to other s/s's. I would
like to keep the data only (like paste-special, values) and remove the linked
reference from showing in the current s/s. Any ideas how to do this instead
of me changing each linked reference?
Thanks in advance!
search for .xls or [ or ] to see if you can find the formulas that contain links
to other workbooks.
> Hi guys,
> I have a pre-existing excel 97 s/s which has links to other s/s's. I would
> like to keep the data only (like paste-special, values) and rem...why wont an excel doc open with new msn office
i have just got a new comp with the new microsoft woeks on it, word doc if
differant, and a few other things but an excel doc was sent to me an it will
not open it ????????
MS Works is a 'light' version of Office, containing a 'light' version of
Excel and a 'light' version of Word. You cannot open Excel or Word files
with Works. You'll have to get the files saved as .csv or .txt or a Works
file to be able to open them with Works.
"peterk4" <firstname.lastname@example.org> wrote in message
news:53597904-F529-4E67-BC56-D957C375779...Excel design questions
I'm a new to excel. I'm assigned task to perform creating charts
based on the following data. I explored little bit from web about the
capabilities of excel, but few areas I'm not still quite sure about how
to get it working.
- Is it possible to have advanced filter to automatically refresh if
the data is changed on which the filter is acting on?? Do I need to
write maro for this??
- If i have a column with data (different types of tree names, ex:
Apple, Apple, Maple, Grape,Grape..etc - name is repeatable). Can I
uniquely get the name of all the different tree names automati...excel pivot table with sql query and visual basic macros
I have a pivot table that runs off a sql query, it has macros and parameters
built into the report. It worked until the client updated their server and
When debugging this, on the module under the closedb it stops here:
'IF CONNECTION IS OPEN IT NEEDS TO BE CLOSED SO AN ERROR IS NOT THROWN
If rsData.State = 1 Then
Set rsData = Nothing
Set cnData = Nothing
Set Cmd = Nothing
...Using Excel 2000 as Data source for Word 2000 document
Problem using Mail Merge using Word 2000 & Excel 2000.
After numerous problems - Word failed to connect to Data Souce file then it
would & then it wouldn't and so on - reasons which are unknown!
The 106 records in 19 fields from the Excel Data Source are only
transferring the information for the first 104 records.
I am looking to add further records but obviously need to overcome this
Obvious, perhaps, but are you certain that the records are in consecutive
rows & no vacant columns separating the fields of data? Does the data range
contain any Merge...Unable to send emails #2
My mail server is not sending out emails. When I perform an NSLookup on the
server's IP address I get an UNKNOWN for the server name.
Any ideas would be appreciated.
"TPSchaefer" <TPSchaefer@hotmail.com> wrote:
>My mail server is not sending out emails. When I perform an NSLookup on the
>server's IP address I get an UNKNOWN for the server name.
>Any ideas would be appreciated.
Fix your DNS or your network connection to your DNS.
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
I have...XML ASP.NET 2.o Issue
I have the following code and I'm using News.xsl to read the XML file -
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
THIS PAST (myXml.Document) IS NOT WORKING IN ASP.NET 2.0
myXml.Document = getXML(nSource.SelectedItem.Value)
Function getXML(ByVal sourceFile As String)
Dim myRequest As System.Net.WebRequest =
System.Net.WebRequest....ms pos 1.2 weird word jumble
Store Operations Manager was not working, so I did a repair install.
After the repair, the wrong phrases were in the wrong spot. For example,
instead of cancel it says "category code" and instead of file it says
"Filter:" Does anyone has an idea how to fix this?
I took a screenshot of the home screen so you can see the weirdness for
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Account...Excel 2000 #9
Is there a way to change the date format in footers and headers.?.these two
items do not seem to pick up the formatting specified for the individual
Excel in any version uses the Short Date format from Windows Regional settings
You can make some minor changes in Regional settings but not too much.
How about a macro to add the date in any format you choose?
.PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy")
Gord Dibben MS Excel MVP
On Tue, 5 Feb 2008...Excel Crash
I use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
...Multi-User Excel File on a Network Drive
How can I make an Excel file accessible to multiple users concurrently?
With all able to make and save changes to the same file.
> How can I make an Excel file accessible to multiple
> users concurrently? With all able to make and save
> changes to the same file.
Tools / Share Workbook
...Inserting Rows in Excel
I have a spreadsheet with a unique identifier for each
customer, Customer Information File (CIF). Whenever this
number changes, I want to automatically insert a blank
row. This will merely making the the spreadsheet more
pleasing to the eye to read. Keep in mind, there may not
be a break in CIF for 1 to 15 lines, but whenever this
CIF number changes, I want a new blank row.
Any help would be greatly appreciated!!
Macro solution OK?
Dim i As Long
.Calculation = xlManual
.ScreenUpdating = False
...Xml validation against xsd #2
I have a xml documnet to be validated against an xsd. The xsd is specified in
the doc as
<title>XML By Example</title>
the xsd is:
<?xml version="1.0" encoding="UTF-8" ?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema&...Missing Recipients #2
We are running Exchange Server 2003 on Windows Server 2003 with all of the
service packs for both. Recently we noticed that when users sent email
sometimes the recipients would appar blank. The recipients were present
when the email was sent and they also received the message, however when we
look in sent items or the recipient pulls up the message in their inbox it
will just display a blank field in the To field. I am certain that they
are not using the BCC field and it happens to multiple users so it's not
specific to somebody's computer.
What is causing this issue?
...Multiplication error #2
I noticed that Excel 2003 calculates:
7.5*1.2=8.7 when the correct answer is 9.0. It did this as part of a
formula where the 1.2 answer came from calculating another set of numbers.
When I asked Excel to calculate this answer by simply inputting those two
numbers the correct answer of 9.0 came out. Does anyone have an answer as to
why it does that?!
Hmmm.... 8.7. Well, 7.5+1.2=8.7. Are you sure there's not a plus sign in
"DeeJay" <DeeJay@discussions.microsoft.com> wrote in message
news:72EA8922-F5BA-486...Auto Assigning Categories #2
Hello does any one know if this is possible: Can I bulk assign categories to
transactions that have already been imported into money from my bank. Is
there a way to assign one transaction then have Money update all similar
transactions with my the new category assignment.
Also will money remember the new category assignment and auto assign all
similar future transactions?
In microsoft.public.money, Joe Robison wrote:
>Hello does any one know if this is possible: Can I bulk assign categories to
>transactions that have already been imported into money from my bank. I...