Search results

  1. S

    list of file properties

    oh poo yes isladogs you are quite right. I am after the properties of an mp3 file, sorry and thank you, appreciate it thank you for the link to the numbers for file attributes, very useful smiler44
  2. S

    list of file properties

    this is part of some code I found on the internet for getting the properties of a file, I just want the duration of an mp4 file. Do the numbers represent what property of the file, the code is to retrieve? It may seem obvious but the code is beyond me and so bit by bit I am trying to decipher...
  3. S

    code/marco to shut down windows media player

    another hunt on the net and I found this on Excel forum and it works Shell ("taskkill /f /im calc.exe") with this note This basically kills that task. Replace calc.exe with the file name of the medial player that you are using smiler44
  4. S

    code/marco to shut down windows media player

    yes Mr Excel is also a very good forum. i'll play a bit more but thank you for your time, i appreciate it smiler44
  5. S

    code/marco to shut down windows media player

    update, i should have assigned a macro the the emdeded icon so it becomes clickable and the cursor stops being a 4 arrowed cross smiler44
  6. S

    code/marco to shut down windows media player

    update i have embeded wmplayer as an object. when i hover over it my courser becomes a 4 arrowed cross, if i double click i get a security warning asking me if i want to run this software. this has me thinking. i select the songs i want to play by highlighting them via windows explorer then...
  7. S

    code/marco to shut down windows media player

    isladogs, it could be me but u follwd these instructions from the web page you have given In Microsoft Word, Excel, and PowerPoint®, you embed the control by selecting Object from the Insert menu, then choosing Windows Media Player from the list of available object types. The Windows Media...
  8. S

    macro to shut down laptop

    the advice and help given in shutting down the lap top is appreciated thank you as I can not shut the laptop down smiler44
  9. S

    code/marco to shut down windows media player

    I have searched the net but not found anything that works. I am in need of code or a macro to shut down windows media player. windows version is windows 7 thank you in advance smiler44
  10. S

    macro to shut down laptop

    Access is beyond me. I also use Excel as an alarm clock, it plays a song at a preset time. i have spent time searching how to close windows media player. cant find anything that works.... any ideas? smiler44
  11. S

    macro to shut down laptop

    isladogs, just tried again and excel opened as if it had been closed properly. it could have been that last time i was stepping through the code using the f8 button. got to be honest i had not seen the line Option Compare Database so had not included it what i'm looking to do. i will either...
  12. S

    macro to shut down laptop

    i used this code sorry i have forgotten the correct way to paste code into a post Private Sub shutdown() Shell "shutdown -s -t 05", vbHide Application.Quit End Sub when i rebooted and opened Excel, I think it showed that it had closed as if application.quit had not been read. should i...
  13. S

    macro to shut down laptop

    thanks for the heads up. i had not intended to bother closing any open programs, probably did not think it necessary so will do as you advise. if the shell line is read, will the application.quit be read or will the laptop have closed down before the line is read and executed or will excel...
  14. S

    macro to shut down laptop

    isladogs, thank you for the code, it has worked. I found code on the internet but the first line of code was application.quit, so excel did just that. Even when i removed that line of code the rest did not work. Thank you very much for your quick and accurate working reply. smiler44
  15. S

    macro to shut down laptop

    I have tried various macros from the internet but none have worked. can you help with vba code to shut down a windows 7 laptop and a 8 laptop? thank you in advance smiler44
  16. S

    How is return value generated

    thank you both of you really helpful. the code is probably a more professional route but all i want is simple, found or not found. you have been really helpful thank you for the quick replies smiler44
  17. S

    How is return value generated

    I found this code on the internet. It checks that URL's are still valid. Saves me clicking each one of my favourites to see they are still valid. Public PageSource As String Public httpRequest As Object Dim HL As Hyperlink Sub ValidateURLs() Dim Cell As String 'Range Dim Rng As...
  18. S

    Get list of files and sub folders

    sorry I never got notification of a reply. Thank you RX_ I will check smiler44
  19. S

    Help needed to modify the following macro

    this will find the first blank cell in column A so you could use this if there are no gaps in column A to find the next blank cell/row Sub Macro1() Dim lst As String Dim lr As String ActiveSheet.Range("a2").Select ' row to start If ActiveCell.Offset(1, 0) <> "" Then...
  20. S

    Link/Import SharePoint Excel File

    this is a few years old but I know it worked for me at work. this will download a file from sharepoint. you will need the full path of the file you want to download Option Explicit Private Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA" ( _ ByVal pCaller As Long...
Back
Top Bottom