Category Archives: VBA

Write to text file with Excel VBA macro

The following Excel VBA code will write the contents of column S (first 1001 lines) to a text file named after B16 in a directory labeled B15. The B15 entry will also look for “desktop” or “Desktop” and find the … Continue reading

Posted in Excel, Macros, VBA | Leave a comment