Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel File from the Internet
I have a web server that allows a user to download excel files, these
files have a autorun macros that format the sheet on load. The problem comes when the excel macro is creating a pivot table the message "Run-time error '1004': Cannot open PivotTable source file c:\Users\RobW\AppData\Local\Microsoft\Windows\Temp orary Internet Files \Low\Content.IE5\Q4PYYXA\[Final%20League%20Position%20Bo" and then the message box runs out of space. If I save the file to the local disk before openeing it, I don't get this message and the macro's run fine. Why might this be happening and what can I do to fix it? Thanks for any help. Rob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening Excel File from the Internet
I looks like the string lenght is exceeding the allowable length is excel..
The string posted is 126 character which exceed the msgbox limits of 128. Is it possible to modify the macro and copy the temporary file to a path with a shorter name such as "C:\Documents and Settings\RWhite\My RecentDocuments" "Rob White" wrote: I have a web server that allows a user to download excel files, these files have a autorun macros that format the sheet on load. The problem comes when the excel macro is creating a pivot table the message "Run-time error '1004': Cannot open PivotTable source file c:\Users\RobW\AppData\Local\Microsoft\Windows\Temp orary Internet Files \Low\Content.IE5\Q4PYYXA\[Final%20League%20Position%20Bo" and then the message box runs out of space. If I save the file to the local disk before openeing it, I don't get this message and the macro's run fine. Why might this be happening and what can I do to fix it? Thanks for any help. Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Internet Explorer Windows opening up uncontrollably | Excel Discussion (Misc queries) | |||
Excel 2002 - Internet Explorer Windows opening up uncontrollably | Excel Worksheet Functions | |||
EXCEL FILE IN INTERNET | Excel Discussion (Misc queries) | |||
Internet explorer is very slow in opening Excel Pivot Table lists | Excel Discussion (Misc queries) | |||
how do I share an excel file using the internet? | Excel Discussion (Misc queries) |