[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

Excel VBA

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
timjc
Asked:
timjc
  • 5
  • 4
1 Solution
 
fguerreiro_inixCommented:
Menu
Insert-Object-MovieClip


Hope this helps
Regards
0
 
fguerreiro_inixCommented:
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
 
carttiCommented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
carttiCommented:
I've just found out. Right mouse click for pop-up menu.
0
 
fguerreiro_inixCommented:
So it works?

Bye
0
 
carttiCommented:
I've just found out. Right mouse click for pop-up menu.
0
 
carttiCommented:
I've just found out. Right mouse click for pop-up menu.
0
 
fguerreiro_inixCommented:
What about points cartti?
I' think I've put in the right way
0
 
timjcAuthor Commented:
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
 
fguerreiro_inixCommented:
Forget it

Bye
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now