PeteWright
Active Member
- Joined
- Dec 20, 2020
- Messages
- 492
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi there,
I am currently working on an Excel VBA code that uses the Microsoft Scripting Runtime or FileSystemObject (FSO), but I stopped coding for now, because I'm not sure if the File will work on other computers.
To be able to run my VBA code the user needs to press a button on the main sheet which then initiates a lot of other procedures like opening a text file and filling in a sheet with data.
If I am not wrong then:
For this to work (without throwing an error) the corresponding Reference (in this case the Microsoft Scripting Runtime) has to be loaded into the Excel file (via VBA Editor menu Tools > References).
My Excel file will only be used in our company by a few colleagues, so the worst case would be to enable the Runtime on all computers that will run the file.
What I am asking myself now:
How is the runtime implemented?
So my question now is:
What should I do that every user will be able to run my code?
Many thanks in advance.
I am currently working on an Excel VBA code that uses the Microsoft Scripting Runtime or FileSystemObject (FSO), but I stopped coding for now, because I'm not sure if the File will work on other computers.
To be able to run my VBA code the user needs to press a button on the main sheet which then initiates a lot of other procedures like opening a text file and filling in a sheet with data.
If I am not wrong then:
For this to work (without throwing an error) the corresponding Reference (in this case the Microsoft Scripting Runtime) has to be loaded into the Excel file (via VBA Editor menu Tools > References).
My Excel file will only be used in our company by a few colleagues, so the worst case would be to enable the Runtime on all computers that will run the file.
What I am asking myself now:
How is the runtime implemented?
So my question now is:
What should I do that every user will be able to run my code?
Many thanks in advance.