THANX ALL...
It appears to be working now, by adding extra references to General MSOFfice and MSGraph 8.0
My god is it slow though, so I'm thinking your advice is porobabkly correct and I have gone about this in a rather ad hoc fashion by writing as an .exe.
Cheers, this has been my first...
Thanx Tony,
your questions makes me wonder if my problem is a setup one...
Answer : I don't know!!
The macro was written within Excel, as I was teaching myself VBA(I guess).
As an exercise I decided to try and produce an .exe from my macro code using VB6
So I've basically got a blank form...
Got a question ladies and gents.
Been writing a macro for a colleague to extract BUS data and display onto an excel template...
Eventuallly got there and now decided to make an executable out of it..
YEs i have included the Excel references and everything works, though painfully slow compared to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.