SIXTH SENSE
Well-known Member
- Joined
- Oct 29, 2003
- Messages
- 1,883
Hi All,
I am try to pull out some data in Visio. The data are msexcel ole object. I can read the data just fine.
My problem is when the excel object was placed in visio, the macro in it are also saved. So, every time i access the object, I am ask to enable/disable the macro. This defeat my purpose
of automating hundreds of this file.
I remember that you can access data from close workbook without having to open it. Do you think I can use that technique here? The problem is once I pass the ole object to a variable it is asking me to enable / disable the macro. the macro is not use at this time.
Thank you very much
Florante
I am try to pull out some data in Visio. The data are msexcel ole object. I can read the data just fine.
My problem is when the excel object was placed in visio, the macro in it are also saved. So, every time i access the object, I am ask to enable/disable the macro. This defeat my purpose
of automating hundreds of this file.
I remember that you can access data from close workbook without having to open it. Do you think I can use that technique here? The problem is once I pass the ole object to a variable it is asking me to enable / disable the macro. the macro is not use at this time.
Thank you very much
Florante
