Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with excel web queries
Hi there,
I got some problems with web queries in Excel (meanwhile Excel 2007). I read several lists from a website and write them into my tables. Now I get following error message telling me that the file could not be accessed: :: Laufzeitfehler '1004': Auf die Datei konnte nicht zugegriffen werden. Versuchen Sie die folgenden Lösungsvorschläge: o Überprüfen Sie, ob der angegebene Ordner vorhanden ist. o Stellen Sie sicher, dass der Ordner, in dem sich die Datei befindet, nicht schreibgeschützt ist. o Vergewissern Sie sich, dass der Dateiname keines der folgenden Zeichen enthält: < ? [ ] : | oder * o Der Dateiname darf nicht länger als 218 Zeichen sein. :: The proposed solutions don't make any sense imho. The first item suggests to verify the existance of the folder being accessed. The next one tells to assure the folder is not write protected. The following tells me that specific character shall not be used within the filename (at least the question mark could be used in dynamic websites afaik) and the last one says the filename should not be longer than 218 characters. I have no problem using the created URL in a browser or even in the internal browser for data queries in Excel. But as soon as the query is being executed, I receive above message. I use this code since several years, but now it doesn't work anymore. Can anyone help? Anyone an idea? Regards, Yasin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with excel web queries
I think I've seen a similar problem before and the cause was found out to be
that the webserver uses HTTP Compression and the client computer's IE setting had "Do not save encrypted pages to disk" selected. You might want to give this a try. In Internet Explorer, select Tools-Internet Options. In the Advanced tab, look for the option "Do not save encrypted pages to disk" and make sure it's not checked. " wrote: Hi there, I got some problems with web queries in Excel (meanwhile Excel 2007). I read several lists from a website and write them into my tables. Now I get following error message telling me that the file could not be accessed: :: Laufzeitfehler '1004': Auf die Datei konnte nicht zugegriffen werden. Versuchen Sie die folgenden Lösungsvorschläge: o Überprüfen Sie, ob der angegebene Ordner vorhanden ist. o Stellen Sie sicher, dass der Ordner, in dem sich die Datei befindet, nicht schreibgeschützt ist. o Vergewissern Sie sich, dass der Dateiname keines der folgenden Zeichen enthält: < ? [ ] : | oder * o Der Dateiname darf nicht länger als 218 Zeichen sein. :: The proposed solutions don't make any sense imho. The first item suggests to verify the existance of the folder being accessed. The next one tells to assure the folder is not write protected. The following tells me that specific character shall not be used within the filename (at least the question mark could be used in dynamic websites afaik) and the last one says the filename should not be longer than 218 characters. I have no problem using the created URL in a browser or even in the internal browser for data queries in Excel. But as soon as the query is being executed, I receive above message. I use this code since several years, but now it doesn't work anymore. Can anyone help? Anyone an idea? Regards, Yasin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
problems with excel web queries
Thanks for your hint, but that feature is disabled.
On 3 Mrz., 00:31, Vergel Adriano wrote: I think I've seen a similar problem before and the cause was found out to be that the webserver uses HTTP Compression and the client computer's IE setting had "Do not save encrypted pages to disk" selected. You might want to give this a try. In Internet Explorer, select Tools-Internet Options. In the Advanced tab, look for the option "Do not save encrypted pages to disk" and make sure it's not checked. " wrote: Hi there, I got some problems with web queries in Excel (meanwhile Excel 2007). I read several lists from a website and write them into my tables. Now I get following error message telling me that the file could not be accessed: :: Laufzeitfehler '1004': Auf die Datei konnte nicht zugegriffen werden. Versuchen Sie die folgenden Lösungsvorschläge: o Überprüfen Sie, ob der angegebene Ordner vorhanden ist. o Stellen Sie sicher, dass der Ordner, in dem sich die Datei befindet, nicht schreibgeschützt ist. o Vergewissern Sie sich, dass der Dateiname keines der folgenden Zeichen enthält: < ? [ ] : | oder * o Der Dateiname darf nicht länger als 218 Zeichen sein. :: The proposed solutions don't make any sense imho. The first item suggests to verify the existance of the folder being accessed. The next one tells to assure the folder is not write protected. The following tells me that specific character shall not be used within the filename (at least the question mark could be used in dynamic websites afaik) and the last one says the filename should not be longer than 218 characters. I have no problem using the created URL in a browser or even in the internal browser for data queries in Excel. But as soon as the query is being executed, I receive above message. I use this code since several years, but now it doesn't work anymore. Can anyone help? Anyone an idea? Regards, Yasin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel queries | Excel Programming | |||
Excel Queries | Links and Linking in Excel | |||
Problems refreshing internal queries in excel | Excel Discussion (Misc queries) | |||
Excel Queries | Excel Programming | |||
Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) |