Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please HELP !!! Converting .XLA to .XLS
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please HELP !!! Converting .XLA to .XLS
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" skrev i melding ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please HELP !!! Converting .XLA to .XLS
Wow!!!!
It worked, thanks a lot Harald, you saved me from a huge mess -----Original Message----- 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" skrev i melding ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please HELP !!! Converting .XLA to .XLS
Glad to hear that, James. Thanks for the feedback.
Best wishes Harald "James" skrev i melding ... Wow!!!! It worked, thanks a lot Harald, you saved me from a huge mess |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting ASC to csv | Excel Discussion (Misc queries) | |||
Converting :mm:ss to ss | Excel Worksheet Functions | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
converting | Excel Discussion (Misc queries) | |||
converting | Excel Discussion (Misc queries) |