Delete VBA code in all files

[Indi_Ra]

Hi,

I need your help to solve the following problem. In a folder I have several files and each file type .xlsm is password protected VBA code. How could I do to delete VBA code in each file. The password is the same for all VBA code is "secret" without the quotes. The files are not protected.
Thank You.

[JBeaucaire]

You don't need the password, you could just open each file and save it again as xlsx format. This format does not include VBA elements so they would be excluded, and you'd still have your originals.

[Indi_Ra]

How can I do that? Can you help me with VBA code? I do not mean manually, because there are too many files .

[JBeaucaire]

Maybe something like this... edit the fPATH first.

Please Login or Register  to view this content.

[Indi_Ra]

JBeaucaire,

I changed the path to the folder with files.
The code creates a folder XLSX, but here not even a file copy.

[HaHoBe]

Hi, Indi_Ra,

please have a look in the directory for all files as Jerry spoecified a folder for saving but for some reason missed to add that in the code line

Please Login or Register  to view this content.

which should save in the same directory/folder as the original files.

Ciao,
Holger

[Indi_Ra]

HaHoBe,

I did not understand. VBA Code has not created any .xlsx files in the original folder or folder XLSX.

I modified this line in code and now it works.

Please Login or Register  to view this content.

Thanks

[JBeaucaire]

OOps... my bad! I'll edit the original code above so the solution is posted and accurate. My apologies.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.