PDA

View Full Version : Save the workbook without Macro



murugavelmsc
08-10-2011, 09:16 PM
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 http://www.excelforum.com/images/styles/Skylight/misc/progress.gif http://www.excelforum.com/images/styles/Skylight/buttons/edit.gif (http://www.excelforum.com/editpost.php?do=editpost&p=2578677)

GTO
08-11-2011, 01:21 AM
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
08-11-2011, 02:24 AM
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 (http://www.excelforum.com/excel-programming/787813-save-the-workbook-without-macro.html) 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.