Macros? Microsoft VBScript Editor?

Discuss it here

Macros? Microsoft VBScript Editor?

Postby DEatHISland » Fri Mar 28, 2008 10:00 pm

Ok, this is an area in which i dont have a clue about...
In Microsoft Office applications, when you go in tools and then macro, it comes up with Microsoft VBScript editor or something..

It seems to write and compile Visual Basic scripts..
Does anyone have any interesting scripts to try?
DEatHISland
 
Posts: 50
Joined: Sun Mar 11, 2007 5:06 pm
Location: UK

Advertisement

Re: Macros? Microsoft VBScript Editor?

Postby audiofish » Fri Apr 04, 2008 11:05 pm

What you have there is VBA - visual basic for applications. If it's disabled in Office, as it is in my school, try Corel draw.

A fair bit of code is available and lots can be ported directly from VB6.

A little app I've written in VBA, which comes in useful now and then:
http://brendangillatt.co.uk/code/shatter-vba/
audiofish
 
Posts: 2
Joined: Fri Apr 04, 2008 10:32 pm

Re: Macros? Microsoft VBScript Editor?

Postby jd2kuk » Fri Apr 04, 2008 11:38 pm

I don't know if this'll work in VBA, but it definitely works if you put it into notepad, and save it with a .vbs extension:
Wrote it a while ago lol, it's the annoying message box that doesn't go away:

Code: Select all
call cj
Sub CJ
   msgbox ("Yo!")
   call cj
End sub


The script calls the function CJ (Which creates a msgbox), which calls itself. Change the "Yo!" to whatever you want your message box to say.

;)
jd2kuk
 
Posts: 1541
Joined: Thu Mar 15, 2007 11:19 pm
Location: UK


Return to RM Community Connect

Who is online

Users browsing this forum: No registered users and 4 guests


  • Advertisement