Dear Experts
I have N Number of files saved in path ,All files In xls i want saveas as xlsb file format ActiveWorkbook.SaveAs "ofall.xlsb", fileformat:=50 after completion i want delete xls file
Please Login or Register to view this content.
Dear Experts
I have N Number of files saved in path ,All files In xls i want saveas as xlsb file format ActiveWorkbook.SaveAs "ofall.xlsb", fileformat:=50 after completion i want delete xls file
Please Login or Register to view this content.
Last edited by johnmacpro; 06-10-2016 at 06:21 AM. Reason: attchmentchange
Try This
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hi sir can u check the code it doesnt work
i set path like
"C:\Users\maninata\Desktop\Report_26\DUMP\"
I think you have a \ too much. Ste the path to "C:\Users\maninata\Desktop\Report_26\DUMP" NO \ at the end !!!.
See the code and you'll understand
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi sir if the file is xlsx what need to change on code. I have all xlsx files need to change as xlsb.
Did you consider reading the code you have?
Please Login or Register to view this content.
Sir It got save along with xlsxb. once remove x it got save as xlsb. how can save directly as xlsb.
FileFormat:=50 IS XLSB !!!
What is the problem?
I never said remove x
I am guessing your VBA knowldge is not yet enough
Try this code:
Please Login or Register to view this content.
Hi sir
It getting error @ rename(xlFile.Name, ".xlsx", ".xlsb") please look at
My mistake, I am sorry the code should be:
Please Login or Register to view this content.
Last edited by Keebellah; 06-21-2016 at 05:16 AM. Reason: Information inclomplete
Its working amazing Sir Solved!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks