I'm not new to excel but I am new to XML as well as using VBA. What I have done is created a series of formulas that generate a formatted XML document within an excel spreadsheet; that i can then use to import to adobe forms from a spreadsheet with the data i need in the form.
Now what I would like to do so that this is user friendly, (as i won't be the only one using it) is create a button linked to a VBA macro that would essentially do this:
select from A1:A500
remove any lines at the bottom that may be blank
append B1:B25 to the bottom
export to xml and save with a user specified filename
I think I have the logic down ok, but it is the rest that I am completely unsure of, I've done some surfing around and I should be able to use the following code to save the file to xml, but I'm not sure on the whole selecting etc...
Any help would be greatly appreciated!
Now what I would like to do so that this is user friendly, (as i won't be the only one using it) is create a button linked to a VBA macro that would essentially do this:
select from A1:A500
remove any lines at the bottom that may be blank
append B1:B25 to the bottom
export to xml and save with a user specified filename
I think I have the logic down ok, but it is the rest that I am completely unsure of, I've done some surfing around and I should be able to use the following code to save the file to xml, but I'm not sure on the whole selecting etc...
Code:
ActiveSelection.SaveAs _
Filename:="$ufilename", _
FileFormat:=xlXMLSpreadsheetAny help would be greatly appreciated!
