Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-13-2021, 10:46 AM
RRB's Avatar
RRB RRB is offline Create an index to 2700 audio files Windows 8 Create an index to 2700 audio files Office 2013
Susan Flamingo
Create an index to 2700 audio files
 
Join Date: May 2014
Location: The Holy City of Jerusalem
Posts: 302
RRB is on a distinguished road
Default Create an index to 2700 audio files

I need your input if I am going in the right direction.

With the gracious help of this forum, I was able to program a macro to play my media file from a certain point (using VLC Player) - Hurray!!!!

Now what I want to do is index **2700** audio files. (yes that is roughly the number) I hope I live long enough with the Allmighty's Grace!.

I have created a table 3 cells wide

So what I would like to do is to be able to choose from a predefined list of tags expressing subject matter. I want to be able to choose as many keywords as I desire but from a predefined list.

So I choose Tag1, tag2, Tag3, tag4, tag6 etc. I want to be able to search for these tags in the future.

so cell A is now populated with a group of Keywords

After choosing the group of keywords, I must designate the file that I am referring to. I want to set the file name in an adjacent cell (cell B) from a combobox which is populated with the a list of files in a certain directory and i will start entering the file name and it will auto-complete the string.

Then in the third cell (C) i will manually enter the time stamp where it should start playing from. By clicking on the time stamp it will get the file name from the previous cell (B) (from the text in the combobox) and combine it with the time stamp and open the audio file at the given time.

BOOM!

What I need help with:



1. is how to add as many tags as I desire from a *predefined list* in cell A?
2. How do I get the value of cell B (the file name in the combo box) (the time stamp I already know how to get it thanks to you guys help, if it is the text of a macro button, but not very elligant)

I think the rest I can figure out.

Your help to SOOOOOOOOOOOOOO appreciated.

Susan
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create an index to 2700 audio files Changing Link on Audio Files on Startup mikbro1215 Word VBA 5 03-12-2020 01:45 PM
Can a I create an index in a word document where index entries control sections of the document? pfriorda Word 3 12-28-2017 08:02 PM
msw 2007 ver 12-how do i create a audio link? ss1133 Office 0 03-27-2012 09:07 AM
Cannot insert audio files unless speakers/headphones are present. HELP! brennj4 PowerPoint 0 01-04-2012 11:05 AM
Create an index to 2700 audio files PPT 2010 will only insert, not link to audio files. kevin3d PowerPoint 1 10-07-2011 09:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft