View Single Post
 
Old 12-19-2020, 03:20 PM
mb1280 mb1280 is offline Windows 10 Office 2010
Novice
 
Join Date: Dec 2020
Posts: 15
mb1280 is on a distinguished road
Default

Interesting, thx!

I have not had any need to automate anything in Word, but Excel - a lot . . . I click the button to record what I click on, to do the task, then modify what it shows me, as needed.

This is the most useful thing I've figured out - how to get one's bookmarks from Firefox into a CSV . . . Note: Firefox recently changed Ctrl+Shift+B (to see one's bookmarks) to Ctrl+Shift+O . . .

bookmarks-to-CSV.pdf . . . This is a .pdf that I have made, and uploaded to my Google Docs . . . This first page provides all you need to know, to get your Firefox Bookmarks into a .csv file using SQLite3. This won't do anything to your Bookmarks, it just extracts a copy of them . . . Then, the next few pages provide the details of what's going on . . . Having the .csv, you can then use Excel macros to clean up garbage characters in the .csv, and then append them to other Bookmarks in an .xlsm . . . Within the .xlsm, further edit them, categorize (I do this on 18 fields), and sort (concatenate(concatenate)) (22K Bookmarks) . . . Then, you can do Boolean searches, or use the Advanced Filter! . . . bookmarks-to-CSV.pdf - Google Drive
Reply With Quote