Mr.Dandy wrote:My question is: what is your exact version?
For me, this code don't work with AOO 4.1.0
For the moment, all answers have been done with 4.1.1 or old 3.x.
Unfortunately we are not living in an ideal world and it seems that noone here in this forum uses the exact same version as you do. You can either wait until someone with the exact same version drops by into this thread or you can start working with what you have now.
The starting point is: The
SimpleFileAccess works for all others, but it doesn't work for you. Now your assumption is that this is related with the specific version of OpenOffice that you are using. But there are several other potential culprits (protocol, proxy, local configuration, firewalls, etc.).
We have never checked that the network configuration that we and you are using are the same. It doesn't make sense to suspect an OpenOffice version problem if these other potential problem areas haven't been investigated.
The http protocol is human readable. Instead of speculation the next step should be to fire up a network sniffer like tcpdump or wireshark and check on the ethernet interface what OpenOffice is doing with the
SimpleFileAccess and remote locations. Granted this gets more difficult if the traffic is SSL encrypted for a https URL, but you should still see, if there is only one packet as response or a sequence of response packets.
And if the problem is related with your version of OpenOffice you will have to provide multiple samples for https and http for a meaningful bug report. So your effort won't be lost if you start investigating this now.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.