Selecting a folder to save xml to...

  • Thread starter Thread starter rowlo-efc
  • Start date Start date
R

rowlo-efc

I have the following code that works fine in Excel 2003 and I am
looking for something similar that will produce the same result but
for Excel 2000

can anyone help?

If xmlfolder = "" Then
MsgBox "Select folder for the XML file", vbCritical
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "SELECT FOLDER"
.AllowMultiSelect = False
' Folder selected
If .Show = -1 Then
xmlfolder = .SelectedItems.Item(1) & "\"
End If

Regards

Jamie
 
Take a look here... http://www.j-walk.com/ss/excel/tips/tip29.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"rowlo-efc"
wrote in message
I have the following code that works fine in Excel 2003 and I am
looking for something similar that will produce the same result but
for Excel 2000
can anyone help?

If xmlfolder = "" Then
MsgBox "Select folder for the XML file", vbCritical
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "SELECT FOLDER"
.AllowMultiSelect = False
' Folder selected
If .Show = -1 Then
xmlfolder = .SelectedItems.Item(1) & "\"
End If

Regards
Jamie
 
Excel 2000 does not support XML so how are you creating the *.XML file in the
first place?


Gord Dibben MS Excel MVP
 
Gord Dibben - can you send me your email address and I'll send you the
excel sheet (that i created in Excel 2000) that creates the correct
XML schema...
 
Back
Top