Re: Writing an XML file to sharepoint using VBA in excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On May 14, 5:31 pm, christ...@xxxxxxxxx wrote:
On 14 Maj, 16:24, jamie.greenw...@xxxxxxxxx wrote:

Hello,

As the title suggests i am trying to save an XML file that I have
generated in VBA (in excel) using the DOMDocument object to a
location
on sharepoint but the DOMDocument.Save method does not work. Does
anybody have any idea how this might be done?

Thanks,

Jamie

Posting the same q in 5 groups might offend some persons. Do you want
to rewrite this in VB6?

//CY

Sorry but I don't understand. I feel this question applies to all of
the groups that I posted in (Excel programming, Visual Basic
programming and Sharepoint) and members of one group might not be
reading the other groups so to maximise my chances of having my
question answered i posted it 5 times. Who is going to get offended
and why? I think rewriting in VB6 is a good idea. Thanks
.

Relevant Pages

  • Re: Writing an XML file to sharepoint using VBA in excel
    ... to rewrite this in VB6? ... the groups that I posted in (Excel programming, ... I think rewriting in VB6 is a good idea. ...
    (microsoft.public.vb.general.discussion)
  • Re: OLE (XLS) question ABOUT: how to display a sheet
    ... when i click on 'OLE1.Object.Sheets(2).Select' it goes to sheet2 in Excel but the sheet in VB6 OLE1 remains unchanged ... Microsoft Online Community Support ...
    (microsoft.public.vb.controls)
  • Re: Tracking Changes
    ... you just check the document out on the SharePoint site, the Track Changes ... "Nick Hodge" wrote: ... Microsoft MVP - Excel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Import from Excel and Create Date into the SharePoint Default "Created" field
    ... I'd also think it would be useful to know if he is asking about Excel 2003 or 2007 ... ... Everything you need to know about Microsoft Office SharePoint Server Event Handlers. ... We welcome your comments and suggestions about how we can improve the support we provide to you. ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sharepoint.windowsservices)
  • VB6 math problem
    ... I am attempting to write a VB6 program, part of which includes a simple calculation in respect of the answers the user selects to various questions in a form I am showing him and then analysing that value in various different ways against a predefined set of data that I already have stored in various numeric arrays. ... This part of my program is effectively trying to perform some statistical analys in a way that mimics the analysis being carried out on similar data in an example Excel spreadsheet that I have at hand. ... It is the function you get when you use the built in NORMDIST function as a formula in Excel, and I am attempting to write my own NORMDIST function using standard VB math because I really do need this program to be "stand alone" and for it not to rely on Excel or any similar application being installed on the system. ... According to the Excel help files the NORMDIST function is expressed as follows, where x and mu and sigma are numeric values and where the fourth parameter is FALSE: ...
    (microsoft.public.vb.general.discussion)