RE

[Alexandre]

Well for a start, the msdn library mentions functions such as CreateBitmap

To what/where do i link/reference to, in order to access these functions. do i need a library? I have office 2k3 installed. I do not have visual studio.

Thanks!

 

[Karl E. Peterson]

Hi Alexandre --

Well for a start, the msdn library mentions functions such as CreateBitmap

To what/where do i link/reference to, in order to access these functions. do
i need a library? I have office 2k3 installed. I do not have visual studio.

Those functions are part of the Windows SDK. Examples of their usage abounds on the
internet. Google is your friend:

http://www.google.com/search?as_q=vb+createbitmap&num=50&as_eq=dotnet+"vb.net"

Which, as it happens, includes a reference to a page on my site:

http://www.mvps.org/vb/apixref.htm

From there, you can find examples of 100s of API functions. They're almost all coded
directly within Classic VB, but nearly all of them will work just fine in VBA as
well. You might also spend some time checking out some of these:

http://www.google.com/search?q=vb+graphics+programming+tutorial

IOW, you're sorta diving into the deep end here. Keep calm, and you'll stay afloat.


Good luck... Karl

 

[Alexandre]

Ok thanks you provided me with a good answer.

Hi Alexandre --


Those functions are part of the Windows SDK. Examples of their usage abounds on the
internet. Google is your friend:

http://www.google.com/search?as_q=vb+createbitmap&num=50&as_eq=dotnet+"vb.net"

Which, as it happens, includes a reference to a page on my site:

http://www.mvps.org/vb/apixref.htm

From there, you can find examples of 100s of API functions. They're almost all coded
directly within Classic VB, but nearly all of them will work just fine in VBA as
well. You might also spend some time checking out some of these:

http://www.google.com/search?q=vb+graphics+programming+tutorial

IOW, you're sorta diving into the deep end here. Keep calm, and you'll stay afloat.


Good luck... Karl

 

[Alexandre]

Dammit, i *specifically* said VISUAL BASIC FOR APPLICATIONS

Is there any chances you can you help me with THE QUESTION I ASKED instead of moking me from the start.

 

[Jonathan West]

Dammit, i *specifically* said VISUAL BASIC FOR APPLICATIONS

Is there any chances you can you help me with THE QUESTION I ASKED instead

of moking me from the start.

Calm down. Karl said "They're almost all coded directly within Classic VB,
but nearly all of them will work just fine in VBA as well".

I can confirm this. Apart from the fact that VB6 uses Forms and VBA uses
UserForms which have a different and more limited set of controls, the
syntax of the two languages is almost identical. You can literally drop a
VB-authored module into a VBa project and it will simply work. I use several
of Karl's code samples on a regular basis in my own VBA projects. They are
an outstandingly useful resource.

You simply won't find API code samples on the topic you are looking for that
have been written in VBA itself. This is because this kind of graphics
handling is clearly in the area of general-purpose programming - most VBA
code samples on the web deal with areas which VBA developers specialise in,
i.e. manipulation of the Office object models. Like me, they raid websites
such as Karl's when they need general-purpose routines from outside their
own speciality.