Groups and Subgroups and VBA
I have a routine (PPT 2007) that goes through all the shapes on a slide, and
if they are of a certain type, adds 3D effects to them. The routine knows
that groups of shapes exist and can look at each item in a group separately.
However, I have some cases where part of the grouping is another set of items
that have been grouped previously - a subgrouping within a group.
My issue is this - when I list all the items in the group by enumerating the
"Groupitems" list, there is no item that is named "Group XXX". Instead, all
of the items in the subgroup are list...manipulated a data file in excel
Is there any way to have a button in excel where when I click on it, i
will let me choose a data file (by pointing and clicking) that's comm
delimited and I can simply sum up an array of numbers and import tha
sum into a cell? I don't want to put the text file into th
spreadsheet, but rather just sum of the numers I want into a specifi
skinnydude's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1627
View this thread: http://www.excelforum.com/showthread.php...Mail Messages HTML Viewing
I am using win XP and Office 2002. When I receive
messages with html format i can only see the url's and
not the pictures. I have checked all the settings, I
have the box in options/mail format/internet
settings/html format checked to receive pictures and
still just the url. I runn norton and zone alarm but
can't see any settings in these that would restrict the
downloading of pictures. Any thoughts?
What are your IE settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual...how do i print from excel to envelopes
mailing address and return address print directly to envelopes or labels from
There is not an easy method to do it in Excel without trial and error
Use Word's mailmerge...........labels and envelopes.
Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.
Gord Dibben MS Excel MVP
On Mon, 29 Mar 2010 08:41:01 -0700, gus <gus@...the webpage you are viewing is trying to close the window
We have an internal web interface for our helpdesk system. When we finish
working with a "call" it attempts to unlock the call and we get the message
as above. More often than not, we need to say YES to the message. Any ideas
how to get it to not appear?
Which security zone does the page/popup load into?
Hint: Is IE configured to automatically detect sites in the Intranet zone?
What 'call' software are you using? Have you attempted to contact the
"Keithmeister" <Keithmeister@discussions.microsoft.co...MS excell 2007 Data verification list
I am attempting to use the list function within data verification for drop
down menus. I need a list that is conditional upon the information in
Example: The first cell offers a drop down menu with specific Make of
equipment. From what appears in that cell I seek to offer only the Models
for that Make of equipment on a list in another cell. I considered using a
series of IF statements to run macros however I don’t know how to invoke a
macro from within a formula. Any suggestions?
See Debra D...excel 2000 convert to excel 2003
I would like to move current excell 2000 spread sheets and open them in 2003
excel. Please help in any way. I have copied my excell 2000 data onto a
floppy however it will not open in Excel 2003
XL2000 and XL2003 share exactly the same file format and so should open
just fine in either. However, you should never open XL files on floppies
- XL uses temporary files, which may exceed the capacity of the floppy.
Instead, copy the file from the floppy to your HD before opening.
In article <72864281-728A-4B27-8317-A760E6440BB2@microsoft.com>,
cityof <firstname.lastname@example.org...Using custom document peroperties to creat views in Public Folders
How do I use custom document properties to create views in public folders? I
came across an article for Outlook 2000. I tried doing this for Outlook 2007
but I am unable to. Please assist.
The article I came across was
http://office.microsoft.com/en-us/publisher/HA010549541033.aspx However this
only appears to work for 2000 not 2007. Hopefully someone can help.
> How do I use custom document properties to create views in public folders? I
> came across an article for Outlook 2000. I tried doing this for Outlook 2007
> but I am unable t...Excel table is not correctly pasted into PPT and LN
Hi, i would like to haves ome info about this problem:
One user cannot paste correctly an excel table (Edit Copy
> Paste Special/Image - Paste) from excel 2000 to
powerpoint 2000 or lotus notes vs. 4.6
This problem does not exist in word or in onother excel
Coloured cells are right, coloured text is pasted in black.
Have you got some ideas to resolve the problem?
Thank in advance, Sara (Italy)
...Excel simple stock control
I am a service engineer, and i'm looking to use excel to manage my stock better
I have tried a few things and it's all manually input/edited
I would like to know if it's possibale to use VB, to auto manage these levels
IE, 1 box asks for the part number
2nd asks you how many
3rd/4th boxes are "+", "-"
When + or - is pressed the part number will automatically add's/subtracts
that part level.
Say.. I had 10x abcde's I enter 2 in "How Many", then press "-" it will then
adjust the level from 10 to 8
My excel sheet would have parts...Making counters in excel
Is there a way to get a box to behave as a counter, so that each time
you click on it the numerical value will increase by one. I am trying
to create a survey response sheet and this would be a big help.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
ToolsMacro>Record New Macro>name it AddOne. Stop the macro recorder before
doing anything else; nothing should be recorded.
Tools>Macros>*Select the AddOne macro and click Edit.
Paste this on a line between t...Charts in Excel
Anyone have a way to create a combined Clustered Column and Stacked Column
chart in Excel? I can easily select one or the other, but I would like to
have a combination. I'm using Office version 2002
Have a look at http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm
Bernard V Liengme
remove caps from email
"JR1" <JR1@discussions.microsoft.com> wrote in message
> Anyone have a way to create a combined Clustered Column and Stacked Column
> chart in Excel? I can easily...m_pDocument Doc/View unique id for each view
I'm using the standard mfc mainform with a doc/view. While I'm in the
view portion I need to track the actions taken individually and
separately for each view. So when when I click on view one I track
that in a separate place than view two.
I there a unique id or index for each view? Something like
<email@example.com> wrote in message
> I'm using the standard mfc mainform with a doc/view. While I'm in the
> view portion I need to track the actions taken...Set discount reason code via COM
I have a function that is adding an item to the end of a transaction and
setting the price to 0 (it's a free item), however I can't tender the
transaction as the line needs a reason code.
Can't find the right function/sub to set the reason code for a line.
Any assistance is appreciated.
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
microsoft.public.pos - 37326 messages and counting!
##-----...Recommendations for VBA Book, manuel
This is a multi-part message in MIME format.
I need a book to assist me in learning simple VBA code to use mostly =
in Excel. I have a little programming experience with C++ from college, =
but not a lot. My need is mostly to create forms in Excel and maybe =
other Office applications in the future. I would like to teach myself =
the basics of format and typical thought process in Visual Basic. I have =
a solid understanding of Exce...Importing a web page to excell
Is there any way, other than copy & paste, to copy a web page into
excell using a program?
Browser: File => Save
Excel: File => Open
"Gordon" <firstname.lastname@example.org> wrote in message
> Is there any way, other than copy & paste, to copy a web page into
> excell using a program?
> Thank yoy,
try placing your cursor in the table on the web site you want>right
click>import to microsoft excel.
dguillett1@a...HTML code fragment options not available in Publisher 2000
Neither the tool on the left toolbar for inserting html code fragment, or the
function in the Insert Menu are available. They are both grayed out. How do
I create html code fragment in Publisher 2000?
You will need a web page built to do it. Start Publisher, create part or
all of a web page, then do a File, Save as a web page. Now select Insert,
Html code fragment, select an area on your web page (anywhere you can move
it later) with the mouse pointer with a left click. A window will open
allowing you to write the code for the fragment.
"smsbear1" &l...View Webpage
How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images
That webpage is on our intranet website.
Though I am not certain this is exactly what you are looking for, try the
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.
Hope...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...Excel Error #2
"Some chart types cannot be combined with other chart types. Select a
different chart type."
I receive this error whenever i click insert chart in all office
applications even within excel itself.
Tried disabling Norton Internet Security 2007, problem persists.
Tried running Diagnostics, problem persists.
Version of Excel?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"kwpang1" <email@example.com> wrote in message
news:7458A216-6...excel opens very slow
Hello to all! I have problem that I am can’t success to solve:
I Have DELL D630 laptop with XP PRO SP3, & Office2003.
The problem began when Office Files opened terribly slow (around 1 minute),
even if it’s a new or empty file.
After searches in the network, I found recommendations to add to do the next
steps (to unmark the DDE from opening excel files):
1.) Open My Computer.
2.) Go to Tools -> Folder Options, and click on File Types.
3.) Find the extension of the file in question (XLS, DOC, etc.)
4.) Highlight the extension, and click \"Advanced.\"
5.) Highlight the \&q...Forcing a view to be the active view
I have an SDI application that has a splitter window with two views. The
first view is an CFormView and the second is a CView. I want the CFormView
to always be the Active view. Even if the user selects the CView.
How do I accomplish this?
Anders Eriksson wrote:
> I have an SDI application that has a splitter window with two views. The
> first view is an CFormView and the second is a CView. I want the CFormView
> to always be the Active view. Even if the user selects the CView.
> How do I accomplish this?
> // Anders
I'd ...I need help with Excel formula
I need help with Excel formula (first one is correct but I don't know how to
add second formula)?
=IF('1'!W16="($E20>2000000,0,IF($E20>100… =""AB8",'1'!W16) or
On Sat, 26 Dec 2009 06:31:01 -0800, antoinette <firstname.lastname@example.org> wrote:
>I need help with Excel formula (first one is correct but I don't know how to
>add second formula)?
>=IF('1'!W16="($E20>2000000,0,IF($E20>100� =""AB8"...Excell #12
how do i creat a drop down list containing 6 items for a certain cell. The 6
items is not part of a formula.
Savy, one way, use Data Validation, have a look here for details on how to
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Savy" <Savy@discussions.microsoft.com> wrote in message
> how do i creat a...Bar Graph on Form (rectangle control code)
This website gives a good description of how to use a small amount of coding
to have a rectangle controlled by a field value on a report appear as a bar
graph when you print preview. I would like to do something very similar,
show a bar graph within a form based on a field's percentage (between 0 and
1). In the example they put the code into the OnFormat event property. I
would like my bar graphs to appear upon opening the form. Hope that I can
use very similar code as in the example but what would I put it in... OnLoad...