Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.63 seconds.
Search: Posts Made By: smiler44
Forum: Excel 05-31-2019, 10:55 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

thank you I'm trying using a media player active x to see where this gets me. I'll have to learn how to use it but time is on my side

smiler44
Forum: Excel 05-24-2019, 12:44 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

thank you very kind.
I will keep trying, I'm of the mindset, it is possible... just I dont know how :)

smiler44
Forum: Excel 05-23-2019, 10:53 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

for this project, i dont press the shuffle button, once i have manually selected the songs i press play.
i select windows explorer/documents/directory holding songs/ the songs i want to play/play
...
Forum: Excel 05-23-2019, 12:25 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

no no no :) you are thinking of an existing macro that selects a song, i need a new one and this macro will not select any songs, just work out the duration of the song being played or give me the...
Forum: Excel 05-23-2019, 12:22 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

i do as in me but the macro doesn't and cant hard code the song title as next time i may select different songs .

smiler44
Forum: Excel 05-23-2019, 12:06 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

:)
all i want help with is getting the duration of the song being played or the name of the song being played. I think once I have this info I can proceed

smiler44
Forum: Excel 05-23-2019, 11:47 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

sorry I mised that.
The songs are in a directory in My Documents and has artists name followed by song title and file extension then date file created and duration . Adele - All out of love.mp3 ...
Forum: Excel 05-23-2019, 11:13 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

I've tried Access, could not get on with it and that was when I may have needed it for a job I was applying for. Now I dont need it, there is no way I could learn it I'm not that clever

macafee2
Forum: Excel 05-23-2019, 11:04 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

Gasman, I think you may be misunderstanding or I am misunderstanding.
The code I have posted randomly selects a song from a directory and plays it.
If the duration of that song does not exceed the...
Forum: Excel 05-23-2019, 10:53 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

Thank you Gasman, I was chuffed when it worked.

would i be taking the mickey if I asked what should it be :)

smiler44
Forum: Excel 05-23-2019, 10:49 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

this is the code that my existing project uses


Sub start()
' play music for pre determined time

Sheet1.Range("A1").Value = "00:00:00"
Sheet1.Range("A2").Value = "00:00:00"...
Forum: Excel 05-23-2019, 10:29 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

I am just tabbing through the code to make sure what i provided was working, have you tried the code?

Are we getting out wires crossed? Ignoring the code i have provided can you help with using...
Forum: Excel 05-23-2019, 09:36 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

Am I right in thinking that the song title is known when the fileinfo function runs? In this new situation, I have not been able to acquire the title.
If you could help me get the title of the song...
Forum: Excel 05-23-2019, 08:48 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

Gents I must tell you I'm no expert in coding as you can see. I have never done it for a living but have used and crated macros for work. I've had no training and a lot of stuff even if I use it I...
Forum: Excel 05-23-2019, 12:28 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

i think it pauses excel for the duration of the current song being played so it finishes before excel plays the next song.
i can also see how long music has been playing for before and after the...
Forum: Excel 05-23-2019, 12:23 AM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

isladogs, may be i dont quite understand. Once I have the attributes what can I do with them? I dont know (my code does not know) what song is being played and so cannot look the attributes up for...
Forum: Excel 05-22-2019, 11:35 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

i created a marco with help from here and the internet that randomly plays songs for a pre determined time.

i hope this is all of it. it may look as if i declare part way through a module but in...
Forum: Excel 05-22-2019, 11:19 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

I dont think so. I did find code doing an internet search that did the same or similar. This code lists the attributes and unless i can work out what song is being played, i cannot go the the...
Forum: Excel 05-22-2019, 11:13 PM
Replies: 56
Views: 931
Posted By smiler44
Re: get details of song being played

i am selecting songs to play using windows explorer, opening the directory, selecting the songs and pressing play.

am i right in thinking your code requires me to know the title of the song?
This...
Forum: Excel 05-22-2019, 11:32 AM
Replies: 56
Views: 931
Posted By smiler44
get details of song being played

This is the situation.
I have selected some songs to play via windows media player, they start playing.


I want the songs to play for x number of minutes. so I start excel tell it how long to...
Forum: Excel 03-16-2019, 10:47 AM
Replies: 8
Views: 292
Posted By smiler44
Re: macro to hide rows if column

not sure i understand the question :)
count myself as an amateur that has hook or by crook created some very successful bits of automation.
Google is my friend but even then I do find I need...
Forum: Excel 03-16-2019, 10:44 AM
Replies: 8
Views: 292
Posted By smiler44
Re: macro to hide rows if column

no worries thank you fr trying

smiler44
Forum: Excel 03-16-2019, 08:44 AM
Replies: 8
Views: 292
Posted By smiler44
Re: macro to hide rows if column

I think I've just had a lightbilb moment.
this is a modified macro I found on the internet


BeginRow = 2
EndRow = 20
ChkCol = 3
For RowCnt = BeginRow To EndRow
If...
Forum: Excel 03-16-2019, 08:38 AM
Replies: 8
Views: 292
Posted By smiler44
Re: macro to hide rows if column

thank you, either I did not understand what I was looking at or what I'm after was not there

smiler44
Forum: Excel 03-16-2019, 07:41 AM
Replies: 8
Views: 292
Posted By smiler44
macro to hide rows if column

I am in need of a macro to hide rows where column C does not contain
and of these values, there will only be 1 value per cell.
book, car, plane, boat, pencil, rubber, rule, pen.

lots of macros...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:05 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World