Excel2003 to Excel2007

[haissk]

Hi

I am working on Excel 2003 with VBA and soon will be migrating to Excel 2007 VBA. hence wanted to know some good atricle on the impact and the changes in the VBA code that we should be doing for a smooth function

Regards
Sathish

 

[Yard]

Hi Sathish,

Maybe no reply to your post in 12 hours suggests that there is an abundance of such information kicking about - when you Google and find the good ones maybe you could post them up?

It's late...

 

[stanleydgromjr]

haissk,

Hope this helps you get started in the right direction.

Do a search on Google for "Excel 2003 vba to Excel 2007".


Have a great day,
Stan

 

[haissk]

But i dont want to go for any 3rd party tools to recover my files.
I am asking is there any option in Excel 2007 to do so???

 

[Yard]

Sathish, I don't understand your question.

What do you mean, "recover my files"?

And what "option in Excel 2007" do you want to know about?

 

[haissk]

Yard,
I have opened a excel file which is created in 2003 and as some macros in office 2007
When saving that file i accidently save as .xlsx(without Macro-enabled) format.
now i want the macros from this file somehow. how can i do that

Pls Note: I dont want to save the original file again to .xlsm.

 

[Yard]

When saving that file i accidently save as .xlsx(without Macro-enabled) format.

But it did tell you that you were saving as a macro-free workbook?!

now i want the macros from this file somehow. how can i do that

Not sure you can directly, but why not just open up the .xls file, copy the code in the VB Editor, paste it into your 2007 file and then save it as .xlsm

 

[haissk]

Since these things will be happening from the users end and i cannot instruct the users to do so...
Tough Question

 

[Yard]

Well, good luck! I can't see how you could automate the creation of macros from a macro-free workbook, and I'm not sure you should ask!

Looks like you'll be spending today writing a detailed Standard Operating Procedure for copying VBA code!