StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
942384
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-06-02T23:14:20.970
FavoriteCount
0
LastActivityDate
2009-06-03T00:27:59.233
LastEditDate
2009-06-03T00:27:59.233
LastEditorUserId
100754
OwnerUserId
100754
ParentId
941456
PostTypeId
2
Score
6
ViewCount
0
LastEditorDisplayName
text
Body
Is there a key binding for the toolbar button? If there is, you could use the SendKeys method to send that key to Excel: <a href="http://msdn.microsoft.com/en-us/library/aa202943(office.10).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa202943(office.10).aspx</a> Alternatively, the CommandBars collection might be useful. See <a href="http://msdn.microsoft.com/en-us/library/aa171356(office.11).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/aa171356(office.11).aspx</a> for reference. The sample code below lists the visible command bars and the controls in the 'Standard' toolbar. When it finds a control with the caption Open, it invokes the control. This should display the "File -> Open" dialog: <pre><code>#!/usr/bin/perl use strict; use warnings; use Win32::OLE qw(in with); $Win32::OLE::Warn = 3; my $app = get_excel(); $app->{Visible} = 1; my $book = $app->Workbooks->Add; for my $bar (in $app->CommandBars) { if ( $bar->{Visible} ) { print $bar->{Name}, "\n"; } } print "Controls in the 'Standard' toolbar:\n"; my $bar = $app->CommandBars->{Standard}; for my $control (in $bar->{Controls}) { print "\t", $control->{Caption}, "\n"; if ( $control->{Caption} =~ /^Open/ ) { print "opening ...\n"; $control->Execute; } } sub get_excel { my $excel; eval { $excel = Win32::OLE->GetActiveObject('Excel.Application'); }; die "$@\n" if $@; unless(defined $excel) { $excel = Win32::OLE->new('Excel.Application', sub { $_[0]->Quit }) or die "Oops, cannot start Excel: ", Win32::OLE->LastError, "\n"; } return $excel; } __END__ </code></pre> HTH
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow can I activate an Excel add-in from Perl or the command line?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSinan Ünür
UserOwnerUserId
1. USSinan Ünür
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow can I activate an Excel add-in from Perl or the command line?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COGenius - thank you, thank you!
 singulars
 PostPostId
 PO
 UserUserId
 USRini
2. COYou are welcome. I learned a lot while researching this question.
 singulars
 PostPostId
 PO
 UserUserId
 USSinan Ünür

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.