N/APosted on - 10/25/2011
I need help on using Excel. I will distribute a workbook to someone who still uses Excel 4. I want to know if there is a way to that I can write my XLM Macro to Excel 97 or Excel 2000. Please send me instructions on how to do it properly. Thank you.
Writing XLM Macro in Excel
Since you write the excel macro from excel 4 to ms excel 2007, you will use the procedure for importing xml as external data, whereby you will use the xml data import command.
The following is the procedure that will help you go about this:
On the ms excel data tab, go to the external data group, and when there click on 'from other services' option. Next click on from 'xml data import'
Hoping that your operating system is windows 7 or vista, go to the address bar and click the folder, internet location or whichever destination where xml data file is stored-is should be having the .xml extension.
Choose the option whether to import the xml table in an existing worksheet or a new one.
The contents of the file will be successfully embedded in the excel table.