Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a specific problem with IE8. Our users download excel files via IE8. Those excel files contain macros which create pivot tables. In order to do that, excel 2007, needs the file to be writable or else the macro will crash with a VBA error.

This only happens when the user downloads the files in question with IE8 and presses 'Open' directly, because IE8 then downloads the files to a "Temporary Folder" which I have not found (it does not seem to be %temp% or Temporary Internet Files, but maybe I am wrong) in which the file is not writable.

When the user first presses 'Save' and then 'Open', everything works fine.

Can someone suggest a work around for that issue?

share|improve this question
    
When the user first presses 'Save' and then 'Open', everything works fine. - the best possible workaround for the case) –  Peter L. Feb 22 '13 at 17:27
    
You can use something like Process Monitor to see where the file's been temporarily saved. %TMP% / %TEMP% or a sub-dir is generally where it goes. –  Karan Feb 22 '13 at 17:59
add comment

1 Answer

Had the same issue. What I've found out:

IE8 renames files on cliking "Open" like fileName[n].extension and puts it in temp folder which is not writtable by user.

  1. In Excel file name symbols [ and ] are not allowed. See http://support.microsoft.com/kb/213983 Section "MORE INFORMATION":

    • Make sure the file name does not contain any of the following characters: < > ? [ ] : | *.
  2. Macroses can be enabled only in writable folder

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.