listi.net

Use Excel to load data to a Website

I have books in pdf form on my computer and wanted to import them to my book list.

The steps are:
1. Windows Key + R
2. cmd
3. cd c:\Books
4. dir *.pdf > C:\temp\out.txt
5. Open file and copy to clipboard
6. Paste to Excel
7. Use Data - Text to Columns
8. Use delimited
9. File name is in Column E
10. Find end of string without .pdf
10.1 E1 =FIND(".pdf",D1)
11. Create a function that does a VBA Replace

Function repl(s, f, t)
repl = Replace(s, f, t)
End Function

12. F1 =repl(repl(MID(D1,1,E1-1),"_"," "),"-"," ")
13. G1 ="<a href=""file:///c:/Books/"&D1&""">"&F1&" - LPDF</a>"
14. Copy or fill down
15. Copy data to clipboard
16. Via t2do.com I go to Import
17. Paste the data from the clipboard
18. Press Add