Hello everyone
I have two opened workbooks ..
I need a macro in this workbook to enable me to save the other opened workbook as anyname.xlsm
Example: I have "Master.xlsm" workbook and "Yasser.xlsm" workbook
I need a macro in Master workbook that enables me to save the other workbook "Yasser" as "New Yasser" in the same path
Hope it will be easy
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi !
Easy with Workbooks.SaveAs method as explained in VBA help …
Example:
52 (xlOpenXMLWorkbookMacroEnabled) is the fileformat parameter
Sub test() Dim sPath As String sPath = ThisWorkbook.Path Workbooks("Yasser.xlsm").SaveAs sPath & "\" & "New Yasser.xlsm", 52 'provided this workbook is open, can be run from another Excel workbook in the same instance. otherwise, open this first End Sub
In face, it seems that my trick to save as opened workbook wouldn't work
The code is working well ...
The problem is that the target opened workbook in not xlsm extension ... It's exe extension (Yasser.exe) ..
This workbook is converted to exe by small utility called "XLToEXE" and I need to convert it to excel file again
I discovered it may be saved as xlsm but the problem is that (Yasser.exe) is protected and Save As option is disabled and VBA is password protected and the interface of the application is fully hidden ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks