Hi Guys,

I have written a macro, when i try to save it is asking me to save it in different format (my excel file is in xlsx format).
Is there any way i can save my excel file in xls or xlsx along with macro..

in xlsm format macro is supported....

Yes, but you have to "downsave" it. When you go to save, use "Save As..." and select "Excel 97-2003 Workbook". That should do the trick.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.