Whats wrong with saving file like this?

**kjvenky** · 06-26-2012, 11:15 PM

I am trying to save the file since yesterday this way.

Please Login or Register  to view this content.

File saves well but doesnt open back. When I try to open the file It opens in vba editor but not the usual excel way.

**JBeaucaire** · 06-26-2012, 11:41 PM

In Excel 2007+ it is good to include the file extension in the nFileName. Also, there is a VBA version of the TEXT function called FORMAT, you format a NOW to do the date and time all at once:

Please Login or Register  to view this content.

**kjvenky** · 06-26-2012, 11:45 PM

All those things are working fine. The problem is that after i run my logic and save the macro using this. Its saving a file which i am not able to open with excel. But the file shows up in vba editor

**JBeaucaire** · 06-27-2012, 12:44 AM

Try this:

Please Login or Register  to view this content.

**kjvenky** · 06-27-2012, 12:59 AM

The problem is taht after I save that file like that, I cannot open the file again. I has Data (I seen from Windows Properties). I closed Excel.exe from taskmanager and then tried to open the file. I shows empty excel window but when i go the VBA editor file is shown there

**royUK** · 06-27-2012, 02:27 AM

When you save the workbook it closes. The macro stops at that point & the variables are cleared from memory. The code needs to be in an add-in or personal workbook