Sleeper: Save the workbook without Macro

[murugavelmsc]

Hi,

I develop an VBA Application using Excel.

I am using the database as MY Sql. My problem is generate the output based on the criteria
and save the workbook (generated o/p) as different name without macro coding.
How i can do that.

Please help me.

Thanks,
Murugavel S

[GTO]

That button thing is Cool!

Unfortunately, I think you have it pointed at an Edit. Also, whilst if no help is coming and one must cross-post, I hope you advised members at the other site as well.

I would suggest you post the code/attachment here as well.

[Kenneth Hobs]

When forums have lots of people asking questions, you can reply to your own post by putting the word bump in your reply. Only do this though after a day or so to give those that look for 0 replies a chance to respond to your request for help.

The old forum naming convention made finding posts with the thread number easier. Here is your link to ExcelForum.com that your Edit button should have pointed to.

To answer your question, save the file and then save it again as an XLSX file.