Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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: 249
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
  #2  
Old 05-13-2021, 03:29 PM
Guessed's Avatar
Guessed Guessed is offline Create an index to 2700 audio files Windows 10 Create an index to 2700 audio files Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Word is not the right program for a database of 2700 entries. You should be looking towards Excel or Access instead.

Is the point of this so that you can filter the list based on tags like 'show me just the files with tag/keyword'?
Will there be only one timestamp per file or will there be a timestamp per tag?
If there is a timestamp per tag, can there be more than one timestamp per tag?

Note that when you tell me that my previously supplied solution is inelegant then you will find that I'm going to expect you to do a lot more of the pre-work. I expect you to post an Excel workbook containing sample data and a validation list of keywords (hint: learn about Data Validation in Excel). I'm not going to help with a Word solution because I can tell you that it will be far less elegant, slower and more labour intensive than can be achieved in other software.

Depending on your answers to questions 2 & 3, Excel may also not be the best solution as you should have a relational database like Access.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 05-13-2021, 07:13 PM
macropod's Avatar
macropod macropod is offline Create an index to 2700 audio files Windows 10 Create an index to 2700 audio files Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Guessed View Post
Note that when you tell me that my previously supplied solution is inelegant then you will find that I'm going to expect you to do a lot more of the pre-work.
Indeed, given the negative attitude displayed here:
https://www.msofficeforums.com/159753-post1.html
RRB seems committed to not encouraging support...

The following Excel macro will generate a plethora of attributes for every file in whatever folder you point it at.
Code:
Sub ExtractFilePropeties()
Dim objShell As Object, objFolder As Object ' Shell & Folder
Dim strFldr, strFlNms, r As Long, c As Long
strFldr = GetFolder & "\": If strFldr = "\" Then Exit Sub
r = 1
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.Namespace(strFldr)
With objFolder
  For c = 0 To 320
    Cells(r, c + 1) = .GetDetailsOf(.Items, c)
  Next
  Exit Sub
  For Each strFlNms In .Items
    r = r + 1
    For c = 0 To 320
      Cells(r, c + 1) = objFolder.GetDetailsOf(strFlNms, c)
    Next
  Next
End With
End Sub

Function GetFolder() As String
Dim oFolder As Object
GetFolder = ""
Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0)
If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.Path
Set oFolder = Nothing
End Function
I'll let RRB tailor it to just the attributes sought. Hint: Word 365 for Mac - Programatically control date fields without opening - Microsoft Community
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-13-2021, 10:25 PM
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: 249
RRB is on a distinguished road
Default

I sincerely apologize if I mistakenly said anything which appeared "negative". I truly and sincerely admire and respect the helpers here as well as appreciate their support.
-=-=-=-=-=
Regarding my question:
I realize that Word is not the right tool for doing something like this. But Access (which I have some experience developing in) seemed a little bit of an over-kill. All I need is a table with three cells. Also the PC I was supplied with doesn't have Access (or Excel) on it, only Word.

Again thank you all
Reply With Quote
  #5  
Old 05-13-2021, 10:36 PM
Guessed's Avatar
Guessed Guessed is offline Create an index to 2700 audio files Windows 10 Create an index to 2700 audio files Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I agree that Access COULD be overkill but you haven't answered the questions that would really determine if that is true. IMO Access is best if you have more than one timestamp per file as the data should be held in two relational tables.

Answer the questions I asked above and post an Excel workbook or Word document that shows what you are expecting.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #6  
Old 05-13-2021, 10:54 PM
macropod's Avatar
macropod macropod is offline Create an index to 2700 audio files Windows 10 Create an index to 2700 audio files Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by RRB View Post
All I need is a table with three cells.
More properly, a table with three columns (until you find out what other data are available ). Do be aware that Word tables are real performance hogs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 01:13 PM.


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