Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jimbo2112

    Any cyclists here? Strava based question around using power data from a ride in video overlays

    Hi All, It's been many years since I have been here! So, when I ride my bike I want to be able to extract power data from the ride and overlay this data on videos I record on my GoPro. Here are the issues: * The ride data includes power data from my power meter * When exporting data, it is a...
  2. Jimbo2112

    "Save As" dialogue is missing "favorites" option

    Hi All, Maybe I am going daft here, but, before IT rebuilt my PC I was sure I could pull up my list of `Favorites` in the left hand part of the dialogue when saving files in apps. like Excel and Word. This option has disappeared now and I can't see how to reinstate it. All I get now is: My...
  3. Jimbo2112

    Output full result string from xpath query

    Excellent! Top result! Thanks I just need to enrole on a XSLT course ... Jimbo
  4. Jimbo2112

    Output full result string from xpath query

    Hi All, I am using XML Spy on PC and I have a manipulation issue. I have a requirement to output more than I currently get from the xpath query below: //illustration/image[@src=""] from this XML: <illustration id="CHOWIN104STYPRO_002"> <image src=""/> <caption> <head>Stainless steel...
  5. Jimbo2112

    How to rename a batch of files using spreadsheet`

    PH, Great Tip! Cheers Jimbo
  6. Jimbo2112

    How to rename a batch of files using spreadsheet`

    PH, A question; What significance does the Dir() have when checking the file's existence? I am checking for a file and not a directory. Cheers Jimbo
  7. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hi, The `And` conditional extension will be used from now on! Thanks Jimbo
  8. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hi Chaps, I have amended the script to make it ignore empty cells now. I think this could be a useful (fairly) generic bit of code. Is there any merit in posting the code as a `Tip`? Sub renamefiles() strDname = Application.InputBox("Enter the path for filenames to be changed ") Dim thePath...
  9. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hi Chaps, I have cracked it! Thanks a bundle for your help. I will use this as a platform to learn more me thinks! I slightly tweaked the code: Sub renamefiles() strDname = Application.InputBox("enter the path") Dim thePath As String, lRow As Long thePath = strDname lRow =...
  10. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hi Geoff, I have had a pop at writing the code based on your solution, but I did not get far. Maybe I could write out what I need to happen and we could take it from there? Define the path where the files to be renamed reside using strDname = Application.InputBox("enter the path") Define the...
  11. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hi Chaps, I have started to write the VBA fix for this. I used the code from Bong (many thanks) and chose the user input method to get the path. The code is as below: Sub renamefiles() With (strDname = Application.InputBox("enter the path")) For Each r In Sheets(1).UsedRange.Rows...
  12. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hey Guys, Great responses! I am off home on the train now myself, but will catch up with the ideas and fashion a solution tomorrow. Thanks a bunch! Jimbo
  13. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Harley, Thanks for the quick response. I think you are on the right track. But my VBA skills are non existent! What code would I want for this? My current ability only extends to editing macros I have created! Cheers Jimbo
  14. Jimbo2112

    How to rename a batch of files using spreadsheet`

    Hi All, I have the need to take a list of files named in an Excel spreadsheet and rename them. Column A has the file names as they stand. All files are in a single directory. Column B has the corresponding names that I want to convert the files to. I.E. A1=oldname.jpg A2=newname.png. What...
  15. Jimbo2112

    Unlink project does not work

    Something else to add is that even if you do delete the entire linked job in the master project that conatins all the linked projects, you are still left with the record that links to a non existent project. If there is some functionality to overcome this, it's not as intuitive as the other...
  16. Jimbo2112

    Unlink project does not work

    Hi All, When I try and unlink a project from a `master project file` that holds many links to other projects it does not work. The method is: Right click on project, select task information, click on advanced tab and untick the `Link to Project` box When I close the dialogue and re-open it...
  17. Jimbo2112

    Is it possible to search for unresolved image links?

    Chaps, I am using the Xenu software and it is marvelous! Thanks for the link and the advice. Cheers Jimbo
  18. Jimbo2112

    Is it possible to search for unresolved image links?

    Hi All, I would like to be able to run a search on a HTML file to show a list of unresolved links to images within. The images will be held locally (but in a different directory). Any help will be much appreciated! Jimbo
  19. Jimbo2112

    Using validation rule to control input strings in form

    Thanks for the help guys ... Jimbo
  20. Jimbo2112

    Using validation rule to control input strings in form

    Remou, Can I put this code into the Validation Text field via the expression builder? I tried this and it did not like the returns in the code. Or should I be putting the code in a different place? Jimbo

Part and Inventory Search

Back
Top