Programming Questions? Ask a Programmer for Answers ASAP
Im look at the file but do not see any empty rows. What are you referring to?
are you referring to whole empty rows? or empty cells? what number number your referring to?
I am. Whats going on?
On the 2005 file, i can see the empty rows, there is no need for a macro to delete the rows, since it can be done once.
If you click details can you send me the data?
The information doesnt give me much, but normally issues like this are best taken to http://www.mathworks.com/support/contact_us/
Dim xPath As String
xPath = Application.ActiveWorkbook.Path
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each xWs In ThisWorkbook.Sheets
Application.ActiveWorkbook.SaveAs Filename:=xPath & "\" & xWs.Name & ".xls"
Application.DisplayAlerts = True
Application.ScreenUpdating = True
That code will split the workbook into multiple files and save them within the same folder.
You should be able to.
let me know
That didnt work either?
is newPath = MkDir(xPath & "\" ThisWorkbook.Name)Application.ActiveWorkbook.SaveAs Filename:=newPath & "\" & xWs.Name & ".xls" giving a syntax error?
Im just the tech, I dont have any control over pricing.
i just got confused. Let me reread that
Everything im trying is giving me an error. Let me keep trying.
The initial one worked for me. Did it work for you.
is that on one of the big files or the individuals?
let me look over it
On MAtlab whats on the line?
When the line 247 error comes up send me a screenshot
and the more info
can you try saving the file as excel 98 and then retry, i want to see if it makes the difference.
Let me know, i have asked a couple of friends too and can't get something to do exactly what we need. Let me know. I will continue looking.