Save xlsm file to zip file

[HerryMarkowitz]

Greetings,

There are two excel files abc.xlsm and xyz.xlsm enclosed.
Please download these two excel files to your desktop.
Then open abc.xlsm and run following code.

Please Login or Register  to view this content.

After running code above you will see that you have a new file in your desktop named xyz.rar.
Everyhing is okey until now.


Now, delete abc.xlsm, xyz.xlsm, xyz.rar from your desktop.
Then download enclosed file named klm.xlsm to your desktop.
Then open klm.xlsm and run following code.

Please Login or Register  to view this content.

After running code above why there is no klm.rar file in your desktop?
Is it not possible to create a zip file running code includes same workbook?
I mean why I cant zip excel file, from same excel file?

[JBeaucaire]

No, as far as I know you cannot do that due to file locking. However, you should be able to do a SaveCopyAs to create a copy of the current open file, then zip THAT file, then delete the copy, if you wish.

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx