Writing XLM Macro in Excel

Asked By andrei 10 points N/A Posted 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.

• Status: Open
• Question Views: 1410
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By lee hung 75 points N/A #93843

Writing XLM Macro in Excel

Hi Andrei,

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.

__

Regards
Lee Hung

 

About lee hung

Questions
3

Answers
1451

Best Answers
463

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Excel