Solved

Excel VBA

Posted on 1998-10-28
10
142 Views
Last Modified: 2012-05-04
In either Excel 95 or 97, can someone tell me of a way to run an avi within a worksheet. Thanking you for your help in advance.
0
Comment
Question by:timjc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 3

Accepted Solution

by:
fguerreiro_inix earned 70 total points
ID: 1442163
Menu
Insert-Object-MovieClip


Hope this helps
Regards
0
 
LVL 3

Expert Comment

by:fguerreiro_inix
ID: 1442164
If you alredy have the *.avi in your workshett,
run the folowing code in a macro

    ActiveSheet.Shapes("Object 1").Select
    Selection.Verb Verb:=xlPrimary
    ActiveWindow.SmallScroll Down:=-5

0
 
LVL 2

Expert Comment

by:cartti
ID: 1442165
That's all very well, but how do you operate it ? It seems to be a bitmap of the first frame of the movie.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Expert Comment

by:cartti
ID: 1442166
I've just found out. Right mouse click for pop-up menu.
0
 
LVL 3

Expert Comment

by:fguerreiro_inix
ID: 1442167
So it works?

Bye
0
 
LVL 2

Expert Comment

by:cartti
ID: 1442168
I've just found out. Right mouse click for pop-up menu.
0
 
LVL 2

Expert Comment

by:cartti
ID: 1442169
I've just found out. Right mouse click for pop-up menu.
0
 
LVL 3

Expert Comment

by:fguerreiro_inix
ID: 1442170
What about points cartti?
I' think I've put in the right way
0
 

Author Comment

by:timjc
ID: 1442171
I would have preferred it if the code was more flexible (rather than assuming the object would be named "Object1" etc.) Seems to be a recorded macro. Why is the line "ActiveWindow.SmallScroll Down:=-5 " necessary for example.
0
 
LVL 3

Expert Comment

by:fguerreiro_inix
ID: 1442172
Forget it

Bye
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question