I want to create a VBA macro in Excel which will play an audio file that is
hyperlinked from the cell next to the selected cell, but it is not to start
playing from the beginning of the file. The start time is to be taken from
the active cell. I want to know if it is possible to do this, and if so, how.

Thanks

To do something that complex you would need to use Excel to automate your
audio player. You could, for example, use VBA code to create an instance of
Windows Media Player and then automate it to do what you want, but the
details would be dependent on the object model for Win Media Player, and I
have minimal experience with that. But to get you pointed in that direction,
I would suggest you head to the newsgroups for Windows Media Player - and if
you are not familiar with how to automate applications from within VBA do a
search of the MSDN site on the topic "automation".
--
- K Dales


"Natalie" wrote:

I want to create a VBA macro in Excel which will play an audio file that is
hyperlinked from the cell next to the selected cell, but it is not to start
playing from the beginning of the file. The start time is to be taken from
the active cell. I want to know if it is possible to do this, and if so, how.

Thanks

I am new to Newsgroups. Can you please tell me where the Win Media Player
newgroup hides itself. I have looked in Clip-Art and Media, but that appears
to be mainly Clip-Arty!

Movies produced by Camtasia Studio can have a Table of Contents which allows
me to jump to to marked points, so, in my innocence, I thought this might be
easy.

"K Dales" wrote:

To do something that complex you would need to use Excel to automate your
audio player. You could, for example, use VBA code to create an instance of
Windows Media Player and then automate it to do what you want, but the
details would be dependent on the object model for Win Media Player, and I
have minimal experience with that. But to get you pointed in that direction,
I would suggest you head to the newsgroups for Windows Media Player - and if
you are not familiar with how to automate applications from within VBA do a
search of the MSDN site on the topic "automation".
--
- K Dales


"Natalie" wrote:

I want to create a VBA macro in Excel which will play an audio file that is
hyperlinked from the cell next to the selected cell, but it is not to start
playing from the beginning of the file. The start time is to be taken from
the active cell. I want to know if it is possible to do this, and if so, how.

Thanks

Here is the main list of Windows Media newsgroups:
http://msdn.microsoft.com/newsgroups.../118/topic.xml

The other way to approach this, if supported by Camtasia Studio, would be to
do it by automation. Don't know how familiar you are with VBA and automating
other apps from within Excel. Not all apps support it, but you may be able
to open and run Camtasia through VBA code. If interested in pursuing this
idea suggest you search this site on topic of automation, and also search
Camtasia site.
--
- K Dales


"Natalie" wrote:

I am new to Newsgroups. Can you please tell me where the Win Media Player
newgroup hides itself. I have looked in Clip-Art and Media, but that appears
to be mainly Clip-Arty!

Movies produced by Camtasia Studio can have a Table of Contents which allows
me to jump to to marked points, so, in my innocence, I thought this might be
easy.

"K Dales" wrote:

To do something that complex you would need to use Excel to automate your
audio player. You could, for example, use VBA code to create an instance of
Windows Media Player and then automate it to do what you want, but the
details would be dependent on the object model for Win Media Player, and I
have minimal experience with that. But to get you pointed in that direction,
I would suggest you head to the newsgroups for Windows Media Player - and if
you are not familiar with how to automate applications from within VBA do a
search of the MSDN site on the topic "automation".
--
- K Dales


"Natalie" wrote:

I want to create a VBA macro in Excel which will play an audio file that is
hyperlinked from the cell next to the selected cell, but it is not to start
playing from the beginning of the file. The start time is to be taken from
the active cell. I want to know if it is possible to do this, and if so, how.

Thanks