dageci
New Member
- Joined
- Mar 10, 2016
- Messages
- 16
Hello (to be short),
I'm creating a custom (Usercontrol (ocx)) Userforms for excel, the name is Virtual forms.
(Not to bother with the details, you can read about it in the Lounge v.2.0 here in MrExcel forums
http://www.mrexcel.com/forum/lounge-v-2-0/927276-new-excel-userform-control-beta-testers-needed.html )
What I'm doing now:
The control is storing data that is needed for it to work in external file that is created in the same folder where the workbook is.
What I would like to achieve:
I would like to embed this file into excel (maybe in an OLEObject? or is there some other solution?) so that when this control needs to access this data, to get it, do some procesing and then again embed this file (with changes) into this workbook.
So that we can skip unnecessary dependence on the external file.
I'm creating a custom (Usercontrol (ocx)) Userforms for excel, the name is Virtual forms.
(Not to bother with the details, you can read about it in the Lounge v.2.0 here in MrExcel forums
http://www.mrexcel.com/forum/lounge-v-2-0/927276-new-excel-userform-control-beta-testers-needed.html )
What I'm doing now:
The control is storing data that is needed for it to work in external file that is created in the same folder where the workbook is.
What I would like to achieve:
I would like to embed this file into excel (maybe in an OLEObject? or is there some other solution?) so that when this control needs to access this data, to get it, do some procesing and then again embed this file (with changes) into this workbook.
So that we can skip unnecessary dependence on the external file.
