Visual basic 400 & syntax error for mac 2011 excel file RRS feed

  • Question

  • i have trouble running an excel file with macro created in PC.  I either get errors including visual basic 400, compile error, internal error or syntax error. I could run the file on PC without problem but not on Mac.  One more thing, the file was created under a Chinese windows system, I am running an English Macbook Pro 11.0.

    I'd really appreciate it if someone can help.

    Sunday, November 29, 2015 4:09 PM

All replies

  • Hi Mao,

    First, please check it in other pc with English environment. If it works fine, then the issue may in the mac environment, you may post it to Excel For Mac forum.

    If not, you may check it with a simple VBA script, if it works fine, I think you need to modify your code for different language (e.g. Range.FormulaLocal).



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, November 30, 2015 8:01 AM