Hopefully this is an easy fix....this VBA worked prior to the transition to Office 365 but now I am getting an error. The issue is with Set fso = CreateObject("Scripting.FileSystemObject"). The error is ActiveX Component Can't Create Object. I've read some possible fixes perhaps with the registry but could really use some clarity. Thanks in advance for the help!
Please Login or Register to view this content.
Last edited by Leith Ross; 09-26-2017 at 12:36 PM. Reason: Added Code Tags
I think all MS office-365 have a 32 bit version of excel (I could be wrong). ActiveX Component is NOT supported in 64 bits version. Is your version of office 365 a 64 bit?
Yes, it is the 64 bit version of Office 365. Is there any work around to this issue? Thanks for your reply!
I had spent over 6 months trying to figure why I was getting the error.
I doubt, but I really do not know.
I have no issue running that code on 64-bit office 365 with 64-bit windows 10
Are you 100% sure it's that line? What ActiveX controls do you have on the worksheet?
Hello mrivera864,
You can create the folder using VBA with no need to use the File System Object...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Is the version of Office the only thing that has changed? Is it possible that your IT department have disabled scripting libraries?
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks