Exporting(creating) XML files using list

[Triacona]

Dear all,

Please help...I'm a bit stuck

I have the following code to go through a list and create an XML file with each coresponding item in the list as the file name.

Private Sub CreateAllDummyXmls_Click()
On Error GoTo Err_CreateAllDummyXmls_Click


Dim ExcelDoc As String
Dim oApp As Object
Dim sFullPath As String
Dim i As Integer


Set oApp = CreateObject("Excel.Application")
 
    For i = 0 To ListFileName.ListCount - 1
    
        sFullPath = txtPath & ListFileName.ItemData(i) & ".xml"
        MsgBox sFullPath
        DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, ListFileName.ItemData(i), sFullPath, True
                
    Next

Exit_CreateAllDummyXmls_Click:
    Exit Sub

Err_CreateAllDummyXmls_Click:
    MsgBox Err.Description
    Resume Exit_CreateAllDummyXmls_Click
    
End Sub

At the moment I am getting an error

Object Required

Please can someone tell me where I am going wrong.

The txtPath is a field within the form that contains the path of where I want these documents saved.

Thank you so much for your help!!
Kind regards

Triacona

 

[traingamer]

    For i = 0 To ListFileName.ListCount - 1

Where is ListFileName defined or populated?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[Triacona]

Dear All,

I have found the solution.
I incorrectly named the List.
It is now named ListFileName

I now have a new problem...

I click on the button to create the xmls in the list and it gives me an error, after giving a msgbox of the path and file name it is going to save.
The error is

Cannot update. Database or object is readonly.

Please help!!
Thank you!!

Kind regards

Triacona

 

[Triacona]

Dear Greg,

The list: ListFileName is a list in the form.

Thanks for your help

Maybe you could help with the above problem please...
Thanks

Kind regards
Triacona

 

[MaxieMax]

just a quick thought.... you haven't got the spreadsheet open while you are trying to run your process have you....

I have had a similar problem when trying to create excel spreadsheets if i have the spreadsheet open that i am trying to write to....

 

[Triacona]

Dear MaxieMax,

MS Excel/spreadsheet is not open during this process.


Thanks for your help

Any other remedies?

It still gives me the same error.

Thank you,

Kind regards

Triacona