Save file in macro

[djwaz69]

Hi
i want to save a file which has a macro written in it and i want to save as the file in a directory (the same place where the file is there) as in xlsx format. and no change should be done in the macro file. and after saving the excel should give a message that the file is successfully saved in "the folder where it is being saved"

please help.

[djwaz69]

i also want that the saved file (saveas in xlsx) as a readonly.

[GeneralDisarray]

This is pretty generic, but i pulled this from a workbook with a similar macro.

To answer your question more specifically you would need to provide and example.

Please Login or Register  to view this content.

Basically, you will need to use SomeworkbookVariable.save or someworkbookVariableName.saveas to accomplish this. I also had an error section to handle the situation where the expected save location didn't exist on the computer.

To add a message, use a message box.

[djwaz69]

i dont want to save macro....macro file is a template kind for me. i want the extracted data to be saved, the workbook contains diff sheet. and i suppose this code will not make the save as file( the file which is being saved in xlsx) in read-only.

[GeneralDisarray]

yes....you need to work out the tweeking yourself unfortunately (or provide an example).

If you type, thisworkbook.saveas, into a code module ... place your cursor in the .saveas portion of the text ... then press F1, you will get the help for the .saveas method!

THere are many parameters. ReadOnlyRecommended is one of them, and it may suite your needs. You can also just protect the workbook or specific worksheets with a password to prevent changes.

You may not like the choosen file format, but my previous post shows where you put the desired XLfileformat (again, you can get a list of them from the help menu. you may like the xlWorkbookDefault, xlOpenXMLWorkbook, xlWorkbookDefault... etc.