Forum Discussion
Solved
Formula is too complex to be assigned to object
Hello, I can't run neither assign a macro to the object. I've figured it's because of the long file path. However, the files are on Sharepoint and folders need have long file paths. Is there...
- I found out the solution to this.
This error can be caused by the name of the folder (or previous folder) where the xls-file is located in...
When the foldername (or name of a previous folder) contains the character "[" and/or "]", you get this error.
For example when your xls-file is located in
"C:\XLS-files\] Test\bladibla.xls" or "C:\] XLS-files\Test\bladibla.xls"),
you will get the 'Formula is too complex to be assigned to object'-error.
By the way: Other special characters in foldernames (like "+", "(" and "{") won't cause that problem.
You like to maintain your foldername?!
In that case you:
-> move the xls-file to "C:\" (e.g. "C:\bladibla.xls")
-> open bladibla.xls
-> add the macro's to the buttons
-> save & close the xls-file
-> move back the xls-file to your desired location (e.g. "C:\] XLS-files\Test\bladibla.xls")
It works for me... hope it works for you too
I found out the solution to this.
This error can be caused by the name of the folder (or previous folder) where the xls-file is located in...
When the foldername (or name of a previous folder) contains the character "[" and/or "]", you get this error.
For example when your xls-file is located in
"C:\XLS-files\] Test\bladibla.xls" or "C:\] XLS-files\Test\bladibla.xls"),
you will get the 'Formula is too complex to be assigned to object'-error.
By the way: Other special characters in foldernames (like "+", "(" and "{") won't cause that problem.
You like to maintain your foldername?!
In that case you:
-> move the xls-file to "C:\" (e.g. "C:\bladibla.xls")
-> open bladibla.xls
-> add the macro's to the buttons
-> save & close the xls-file
-> move back the xls-file to your desired location (e.g. "C:\] XLS-files\Test\bladibla.xls")
It works for me... hope it works for you too
This error can be caused by the name of the folder (or previous folder) where the xls-file is located in...
When the foldername (or name of a previous folder) contains the character "[" and/or "]", you get this error.
For example when your xls-file is located in
"C:\XLS-files\] Test\bladibla.xls" or "C:\] XLS-files\Test\bladibla.xls"),
you will get the 'Formula is too complex to be assigned to object'-error.
By the way: Other special characters in foldernames (like "+", "(" and "{") won't cause that problem.
You like to maintain your foldername?!
In that case you:
-> move the xls-file to "C:\" (e.g. "C:\bladibla.xls")
-> open bladibla.xls
-> add the macro's to the buttons
-> save & close the xls-file
-> move back the xls-file to your desired location (e.g. "C:\] XLS-files\Test\bladibla.xls")
It works for me... hope it works for you too
I was getting the message. MS BS.
I moved it to the downloads folder and now am able to connect a button to Macro.
Thanks.
Is this a file path length problem or a write permissions problem. I know you said it was a character in the path but my path does not have that special character that I can tell.