Share via

Removing Extra Quotes in Notepad++

Anonymous
2019-11-11T22:14:20+00:00

Is it possible to automate the process of sending an Excel file to Notepad++ to remove extra characters and then save the Notepad++ file?  I have automated the process of removing the quotes, but cannot get Notepad to then save the corrected file automatically.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-11-12T00:18:49+00:00

    Hi Thomas

    My name is Jegan, would like to assist you in your Excel query.

    is the code you are looking for?

    ActiveWorkbook.SaveAs Filename:= "[drive letter]:[directory][filename].txt", FileFormat:= xlCurrentPlatformText , CreateBackup:=False

    Replace "[drive letter]" with the letter of the drive to which you want to write the file. Replace "[directory]" with the target directory, and replace "[filename]" with the desired name of the text file.

    Was this answer helpful?

    0 comments