HAVE I CORRUPTED MY WORKSHEET? - 7Days of work!!

[Melimob]

Hi all

I'm losing the will here.. I've just spent a week working on a VBA project.
My last step was to copy and save as a new file.. tried the below code which didn't work but now it won't let me open my file?

It states:

Excel cannot open the file because the file format or file extension is not valid.
Verify the file has not been corrupted and that the file extension matches the format of the file.

I notice in the code it had .xls but because I had a debug error anyhow I didn't think it worked AND I wanted it to save a copy as a new file anyhow.

I'm close to tears thinking that all my work could be lost? Please any advice gratefully received.

 

[sandy666]

post a link to the corrupted file

 

[Melimob]

post a link to the corrupted file

Hi Sandy

I can't post on here.. have PM'd you.

thanks for responding.

 

[Melimob]

Hi Sandy

I can't post on here.. have PM'd you.

thanks for responding.

I can't THANK SANDY666 ENOUGH!! S/he managed to recover my doc. I can't believe it - was feeling sick thinking I'd have to start from scratch.
This taught me to always save a copy - well noted and I will be sure to in future.

Again - THANK YOU A ZILLION for your help. I don't know what I'd do without you and all of you here offering your time to help others. It is truly truly appreciated.

thanks again!
Mel

 

[sandy666]

Oh my... now I will disappear for month... too much (zillion) for me

anyway, all's well that ends well