Ensure the file is truly plain text. In Word 2016, when saving, select Plain Text (*.txt) and uncheck “Allow character substitution.” In Excel, use Save As > Text (Tab delimited) . 2. Office 2016 Adds Hidden Characters Problem: Bitly sees https://example.com as https://example.com (with a non-ASCII character).
Close FileNum End Sub
Open the .txt file in Notepad (not Word) and re-save as UTF-8 without BOM . Or use Excel’s CLEAN() function on your URLs before exporting. 3. API Rate Limiting Issue: Shortening 1,000 URLs via VBA fails after 100. Bitly Microsoft Office 2016.txt