var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access Transform/Inport Problem
Trying to construct a book database at home using information extracted from Amazon's web service. Finally got most everything to work (transformxml, importxml) when I save the Amazon xml file to my computer, i.e.
transformxml "d:\bookdata.xml", "d:\bookdata.xsl", "d:\bookdata_mod.xml", true
BUT problems occurs when I try to transformxml the webpage directly, i.e.
transformxml "http://webservice.amazon.....", "d:\bookdata.xsl", "d:\bookdata_mod.xml", true
According to Microsoft, transformxml should work with "http://", but everytime I run it I keep getting "Run-time error '31527': Path not found:http://webservices...."
Incidentally, ImportXML works with the URL.
For those interested, I couldn't find a way around it so had to resort to loading and saving the xml file from a domdocument.
Dim bookdata As DOMDocument40
Set bookdata = New DOMDocument40
bookdata.async = False