Please HELP !!! Converting .XLA to .XLS

[James]

Hi

I have recently lost bunch of my XLS files with VBA code
on it to HD crash. I do have .XLA vesrion of these files
sitting on my server. I do have the passwords & can see
the codes/forms etc in the .XLA. My question is is their a
way to copy the project out of .XLA to a brand new .XLS.
There may be some commersial stuff but is there a freeware
etc to help this poor guy

Thanks in advance
James

 

[Harald Staff]

Hi James

Choose their ThisWorkbook object in the VB editor and set the IsAddnin
property to false. Then good ol' SaveAs workbook in Excel.

HTH. Best wishes Harald

 

[James]

Wow!!!!
It worked, thanks a lot Harald, you saved me from a huge
mess

 

[Harald Staff]

Glad to hear that, James. Thanks for the feedback.

Best wishes Harald