Visual Basic

Re: How to create DLL Library for VBA(Excel 2010)

25-Jun-12 5:21

Your library, if written in C# or VB.NET, must be written to be COM-exposed.

Here's[^] a pretty good starting article.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

konarex81226-Jun-12 21:02

konarex812

26-Jun-12 21:02

Hello.
I try that - Register COM interlop and Make visible COM... in Visual Studio 2010.
Don`t working.
When I add reference in VBA, I have error.

Can`t add a reference to the specified file

Re: How to create DLL Library for VBA(Excel 2010)

Dave Kreskowiak27-Jun-12 1:23

27-Jun-12 1:23

It takes a bit more than just turning on a couple of options.

You didn't really read the link I posted, did you?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Sine Wave Sound

jignesh14223-Jun-12 0:21

jignesh142

23-Jun-12 0:21

How can i generate the sine wave sound in VB?
I want to generate the sine wave sound for customized duration and customized frequency
Any help?

javadadabi23-Jun-12 2:30

javadadabi

23-Jun-12 2:30

Hello
search for fmod sound engine(fmod.dll) usage.

Nick Otten24-Jun-12 20:45

Nick Otten

24-Jun-12 20:45

Hello,

declare:

Private Declare Function MakeSound Lib "kernel32" (ByVal soundFrequency As Int32, ByVal soundDuration As Int32) As Int32

after that you can call for the MakeSound([frequency in hz],[duration in ms]) function and the computer will generate the tone trough its speakers.

jignesh14225-Jun-12 22:08

jignesh142

25-Jun-12 22:08

i want to do something like this

Option Explicit
Option Base 1
Private Sub CommandButton1_Click()
Dim Sc(3) as integer
Dim Frequency=440
Dim Duration = 1000 ' in millisecond
Sc(1)=1
Sc(2)=1.125
Sc(3)=1.2

For i = 1 to 3
' some code is required to play the sine wave sound for above frequency and duration

next i

End

Nick Otten25-Jun-12 22:28

Nick Otten

25-Jun-12 22:28

try this:

Option Explicit
Option Base 1

Public Class NameYourClass

Private Declare Function Beep Lib "kernel32" (ByVal soundFrequency As Int32, ByVal soundDuration As Int32) As Int32

Private Sub CommandButton1_Click()
Dim Sc(3) as integer
Dim Frequency as int32 = 440
Dim Duration as int32 = 1000 ' in millisecond
Sc(1)=1
Sc(2)=1.125
Sc(3)=1.2
 
For i = 1 to 3
Beep(Frequency, Duration)
next i
End sub
End Class

note: i just putted a class around it so you could see where to paste what.

modified 26-Jun-12 4:42am.

jignesh14226-Jun-12 4:46

jignesh142

26-Jun-12 4:46

hi nick
Actually i don't want to use the beep function but to generate the sine wave sound

Nick Otten26-Jun-12 11:40

Nick Otten

26-Jun-12 11:40

isnt that just a very long beep? note that the kernel32 beep isnt the .net beep (the .net beep will give you the windows error 'klunk' while the kernel32 beep will generate a tone with the given amount of hertz during the given amount of milliseconds)

but now that i think about it, not sure how it works with the 'wave' part..
did i quick google for ya and found this[^] its in vb6 a bit old...and not directly what you need. but it might be able to help you (or so i think)

javadadabi27-Jun-12 0:21

javadadabi

27-Jun-12 0:21

see www.3dstate.com about using fmod functionality for 3d games.spacially horn sample.

modified 27-Jun-12 6:29am.

edit games

Member 915884022-Jun-12 16:08

Member 9158840

22-Jun-12 16:08

how to edit a simple games using visual basic?

javadadabi23-Jun-12 2:34

javadadabi

23-Jun-12 2:34

Hello
for making a game you need to use a 3d engine.
contact www.3dstate.com
it has a wonderful game engine.
easy,user license,...
sdks for vb6,vb.net,c#,delphi
Oh,you want to edit a game? D'Oh! | :doh:

modified 23-Jun-12 21:49pm.

ZurdoDev25-Jun-12 4:12

ZurdoDev

25-Jun-12 4:12

Get the source code, make your change, compile.

There are only 10 types of people in the world, those who understand binary and those who don't.

edit games

Member 915884022-Jun-12 16:02

Member 9158840

22-Jun-12 16:02

how to edit a simple games using visual basic?

Dave Kreskowiak22-Jun-12 16:10

22-Jun-12 16:10

What do you mean by "edit"?

And don't post the same question twice.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Midnight Ahri22-Jun-12 18:31

Midnight Ahri

22-Jun-12 18:31

like opening plants vs zombies solution in visual basic? D'Oh! | :doh:

Richard MacCutchan22-Jun-12 22:35

22-Jun-12 22:35

Unless you have the source code you cannot edit it.

Richard MacCutchan23-Jun-12 2:20

23-Jun-12 2:20

You cannot do this without the source code. It does not matter how simple the game is, if you only have the executable then you need to decompile it and rebuild from the decompiled source.

Midnight Ahri24-Jun-12 16:07

Midnight Ahri

24-Jun-12 16:07

but i think decompile and edit an exe is not that easy, it's already an assembly code, am i wrong? D'Oh! | :doh:

Richard MacCutchan24-Jun-12 21:58

24-Jun-12 21:58

You are correct, it is extremely difficult, and probably not worth the effort. The chances of you being able to hack the game are quite low.

Midnight Ahri24-Jun-12 22:04

Midnight Ahri

24-Jun-12 22:04

so every game hacker are editing assembly code?
mother of code OMG | :OMG:

by the way, thank you for the information. Smile | :)

Richard MacCutchan24-Jun-12 22:17

24-Jun-12 22:17

Midnight Ahri wrote:
so every game hacker are editing assembly code?

Some are probably editing direct machine code; but there are better ways to use your talents in this world.

Cannot change text of button on a control.

Ammar_Ahmad22-Jun-12 13:16

Ammar_Ahmad

22-Jun-12 13:16

I made a control which has a button on it.
But I need to change the text of it when it is clicked.

this is what I have tried but it didn't work:

If Button1.Text = "1" then
 Button1.Text = "0"
Elseif Button1.Text = "0" then
 Button1.Text = "1"
End if

Re: Cannot change text of button on a control.

Dave Kreskowiak22-Jun-12 14:38