how to convert xlam to xla

[oklatinguy]

Hi guys,

Could you give me a hand with this issue I am facing? I need to downgrade an excel2007 addin (xlam) to excel2003(xla). Created a excel2007 macro which works pretty well, but I have some reluctant colleagues who don't want to upgrade to excel2007 for uncertain reasons. Tried the exce2007export option, but I only got the original excel2007 script. In fact, imported all the macro into excel2003 and found that several excel2007 functions are not available in excel2003. Any suggestions? Thanks

 

[shg]

... found that several excel2007 functions are not available in excel

Which of those functions are you using?

 

[oklatinguy]

Hi, thanks for replying my post. The function in bold red text is where excel2003 stops. Implemented as many equivalent excel2007-to-excel2003 codes in my macro as possible and they worked , but this one is sneaky. In excel2003 it is required to match the source and destination range for copying/pasting. However, in excel2007 is this automatic. Basically, this code merges several worksheets into one, Sheets("Combined"). How can I fix this? Thanks again...

For i = 1 To lNum
Sheets("Bin Data (" & i & ")").Select
Range("A1:E65536").Copy
Sheets("Combined").Select
Range("F65536").End(xlUp).Offset(1, 0).Select
Sheets("Combined").Paste
Next i