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!

  • Congratulations Mike Lewis 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. ThomaJo

    Copy directory listing to a file/spreadsheet

    Well, its saved as a text file, so I just want the text file to open automatically for review. Once its open with a text program (Wordpad, Notepad, etc.) then I can copy/paste the contents into Excel or whatever.
  2. ThomaJo

    Copy directory listing to a file/spreadsheet

    Great! One more question. How do I get it to open the file now (C:\Common Files.txt). I coud either add the code to a button or I can add the code to the Command1_Click. Either way would work. Thnks!
  3. ThomaJo

    Copy directory listing to a file/spreadsheet

    OK now, how do I link them ("FileList1" to "Dir1")? (I only dabble in this, I'm not a programmer.)
  4. ThomaJo

    Copy directory listing to a file/spreadsheet

    One more question. Can I get the Directory List box (Dir1) to "display" the actual file names? It just show the directory names. Being able to View the files in that directory would be useful. Thnx!
  5. ThomaJo

    Copy directory listing to a file/spreadsheet

    Perfect! That's exactly what I want. Thanks so much Golom!
  6. ThomaJo

    Copy directory listing to a file/spreadsheet

    Great, I do want just the list of files. But I try this and I get the error (76) "Path not found" at line "For Each fle In .GetFolder("C:\myFolder").Files" The directory location to get the files from should be coming from the "directory list box" (called Dir1). I'm not sure how to get a...
  7. ThomaJo

    Copy directory listing to a file/spreadsheet

    OK, I finally tried this again and I got the "done" message box. A file was created in C:\ ("Common Files.txt") but the file is empty. I don't see a file list. What am I missing here?
  8. ThomaJo

    Copy directory listing to a file/spreadsheet

    OK, I tried this in VB 6 and I get a Compile error "User defined type not defined" at line: Dim fso As FileSystemObject I don't know what a FileSystemObject is. Any suggestions?
  9. ThomaJo

    Copy directory listing to a file/spreadsheet

    Thanks Swi! To answer your questions, #1, No, don't need subfolders. #2 the list I am comparing it to is basically data sheets (paper forms). I thought it would be easy, but I can't figure out how to "Drop a directory list box" on my form. I can't find the command button in the tool list...
  10. ThomaJo

    Copy directory listing to a file/spreadsheet

    Hello. I would like to know if anyone can give me code to open a directory list (give a drop-down or something to allow a user to choose the directory of his choice from his computer) and then copy the "filenames" (names only, not the actual files) and paste the list of names into a text file...
  11. ThomaJo

    placing a dynamic graphic on a Report

    I'm trying to figure out if I can place a graphic on a report that will change, based on the content of the report. I've made a database that runs stats on data in the report, and I would like the report to include a graphic (red.jpg or green.jpg or yellow.jpg) based on the result (say result...

Part and Inventory Search

Back
Top