Jump to content

Question with a few Excel techniques

Recommended Posts

Hello, I am still exploring autoit and learning daily.

However even after browsing and searching through the forums.

There are still a couple of questions that I have no clue on how to solve.

Can someone help me please or maybe give some suggestion how I should go about solving it.

I have 4 questions.

1. How could I open an xml file in xml data form? If I just simly use the excel UDF, it opens as a regular spreadsheets and I can't edit it.

2. And after Opening it how can I save it back to xml data form? I know it can be achieved through macroed saves. But is there a function that can auto save it?

3. If the above question is impossible to do. What other methods is best used for editing XML data? Any leads in this topic would be awesome.

4. How do I copy a cell, and paste it with the effect of "value only", meaning that it skips over the formula and paste the result of the formulated cell?

Any helps, sample codes, or ideas would be greatly appreciated. Thank you all in advance.

Link to comment
Share on other sites


It is not possible with my excelCom; but I don't know about @Locodarwin's; or @BigDaddy might know.

In general, I can help if you post the code you use to do something using a recorded macro in excel vba; then i can usually convert it.

best, randall

Link to comment
Share on other sites

To directly manipulate an XML document, you may wish to review the XML DOM. There are a variety of techniques using the MS XML parser engine, which is COM-aware. Search for XMLDOM. Also, review the enumerated excel constants.

Review the Open and SaveAs methods for the various options that are supported to open / save / convert file formats within excel.

Const $xlTextMSDOS = 21
Const $xlXMLSpreadsheet = 46

Reading the help file before you post... Not only will it make you look smarter, it will make you smarter.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...