dll File

OfficeUser · Joined: 02 Feb 2008 Posts: 16

Two questions ............

1. Can VBA be used to create the procedures in a dll file?

2. Can anyone give me recommendations for free downlaodable tools for
compiling a dll file?

Thanks!!

Archived from group: microsoft>public>vb>winapi

AGP · Joined: 04 Oct 2007 Posts: 144

1. No VBA is not compiled. You can with Vb6 though.
2. Go to www.Microsoft.com and look up Vb6 and .NET.

AGP

"OfficeUser" wrote in message @corp.supernews.com...
> Two questions ............
>
> 1. Can VBA be used to create the procedures in a dll file?
>
>
> 2. Can anyone give me recommendations for free downlaodable tools for
> compiling a dll file?
>
>
> Thanks!!
>
>
>

OfficeUser · Joined: 02 Feb 2008 Posts: 16

Re: #1

Can VBA be compiled? I thought it was a subset of VB.

Thanks!

"AGP" wrote in message $EZ3.2856@nlpi070.nbdc.sbc.com...
> 1. No VBA is not compiled. You can with Vb6 though.
> 2. Go to www.Microsoft.com and look up Vb6 and .NET.
>
> AGP
>
> "OfficeUser" wrote in message
> @corp.supernews.com...
>> Two questions ............
>>
>> 1. Can VBA be used to create the procedures in a dll file?
>>
>>
>> 2. Can anyone give me recommendations for free downlaodable tools for
>> compiling a dll file?
>>
>>
>> Thanks!!
>>
>>
>>
>
>

Thorsten Albers · Joined: 04 Oct 2007 Posts: 756

OfficeUser schrieb im Beitrag
...
> Two questions ............
> 1. Can VBA be used to create the procedures in a dll file?

Yes, it can. But it can not be used to create a DLL file...

> 2. Can anyone give me recommendations for free downlaodable tools for
> compiling a dll file?

Make your choice:

[ ] I want to create a COM/ActiveX-DLL with access to public procedures via
the COM interface.

Look out for the MS Visual Basic Control Creation Edition (VBCCE). Its
AFAIK the
only free tool to create COM/ActiveX-DLLs. Don't know if you will find
it
anywhere at all.

[ ] I want to create a 'standard' DLL with access to exported procedures
via an export list.

Any free C/C++ compiler should be able to do this. In addition there
are
other languages (e.g. PowerBasic, Delphi) with which 'standard' DLLs
may
be created.

--
----------------------------------------------------------------------
THORSTEN ALBERS Universität Freiburg
albers@
uni-freiburg.de
----------------------------------------------------------------------

OfficeUser · Joined: 02 Feb 2008 Posts: 16

Thanks, Thorsten, for responding!

Please see my response to Ralph in this thread.

Thanks!

"Thorsten Albers" wrote in message $a4160500$9f01a8c0@xyz...
> OfficeUser schrieb im Beitrag
> ...
>> Two questions ............
>> 1. Can VBA be used to create the procedures in a dll file?
>
> Yes, it can. But it can not be used to create a DLL file...
>
>> 2. Can anyone give me recommendations for free downlaodable tools for
>> compiling a dll file?
>
> Make your choice:
>
> [ ] I want to create a COM/ActiveX-DLL with access to public procedures
> via
> the COM interface.
>
> Look out for the MS Visual Basic Control Creation Edition (VBCCE). Its
> AFAIK the
> only free tool to create COM/ActiveX-DLLs. Don't know if you will find
> it
> anywhere at all.
>
> [ ] I want to create a 'standard' DLL with access to exported procedures
> via an export list.
>
> Any free C/C++ compiler should be able to do this. In addition there
> are
> other languages (e.g. PowerBasic, Delphi) with which 'standard' DLLs
> may
> be created.
>
> --
> ----------------------------------------------------------------------
> THORSTEN ALBERS Universität Freiburg
> albers@
> uni-freiburg.de
> ----------------------------------------------------------------------
>

Ralph · Joined: 04 Oct 2007 Posts: 4148

"OfficeUser" wrote in message@corp.supernews.com...
> Thanks, Ralph, for responding!
>
> I am planning to create an Excel Add-In and I want to "hide" code for
> certain features (licensing, time sensitivity, number of uses, etc)
> somewhere. My idea was to "hide" the code inside a .dll file to make it
> difficult for at least the average user to get to. I was hoping to be able
> to create a .dll file using VBA because I know that language. I do no know
> VB6, C++, Delphi or any other language. Do you have any suggestions for
> where I can "hide" VBA code inside Excel?
>
> Thanks!!
>

AFAIK the only way to truly 'hide' code is to create an ActiveX or Regular
Dll. But, guess what? I am a VB/C++ programmer and thus have never had to
seek out another "hammer" for this particular "nail".

I have heard of schemes where 'macros' can be protected in enterprise
environments with a password. But I doubt any such scheme would work in the
Wild. There may be other ways to shroud VBA code. (What in programming is
impossible? )

However, while your original post asked about "VBA", we now know you are
talking about Excel. You should take a look at creating an "Excel Add-In"
(.xla).
http://msdn2.microsoft.com/en-us/library/aa140990(office.10).aspx
I know they are 'hidden' to a degree, but I don't know to what degree.

I suggest that you post to an Office Excel Developers group.
hth
-ralph

RB Smissaert · Joined: 04 Oct 2007 Posts: 865

Only 2 things are hidden in an Excel .xla file:
The worksheets.
Direct access to the procedures via the Excel interface with: Tools, Macro,
Macros.
The .xla will have to make a menu in Excel to make the code available.
All else is just as available as a normal .xls file.
You can set a password on the IDE, but this can be cracked easily.

Simplest way to hide code is to buy VB6 and move code to an ActiveX dll.
If you can code in VBA then moving your code to this ActiveX dll is simple.

RBS

"Ralph" wrote in message @TK2MSFTNGP04.phx.gbl...
>
> "OfficeUser" wrote in message
> @corp.supernews.com...
>> Thanks, Ralph, for responding!
>>
>> I am planning to create an Excel Add-In and I want to "hide" code for
>> certain features (licensing, time sensitivity, number of uses, etc)
>> somewhere. My idea was to "hide" the code inside a .dll file to make it
>> difficult for at least the average user to get to. I was hoping to be
>> able
>> to create a .dll file using VBA because I know that language. I do no
>> know
>> VB6, C++, Delphi or any other language. Do you have any suggestions for
>> where I can "hide" VBA code inside Excel?
>>
>> Thanks!!
>>
>
> AFAIK the only way to truly 'hide' code is to create an ActiveX or Regular
> Dll. But, guess what? I am a VB/C++ programmer and thus have never had to
> seek out another "hammer" for this particular "nail".
>
> I have heard of schemes where 'macros' can be protected in enterprise
> environments with a password. But I doubt any such scheme would work in
> the
> Wild. There may be other ways to shroud VBA code. (What in programming is
> impossible? )
>
> However, while your original post asked about "VBA", we now know you are
> talking about Excel. You should take a look at creating an "Excel Add-In"
> (.xla).
> http://msdn2.microsoft.com/en-us/library/aa140990(office.10).aspx
> I know they are 'hidden' to a degree, but I don't know to what degree.
>
> I suggest that you post to an Office Excel Developers group.
> hth
> -ralph
>
>

OfficeUser · Joined: 02 Feb 2008 Posts: 16

Thanks for responding, Bart!

<< If you can code in VBA then moving your code to this ActiveX dll is
simple>>

Would you please elaborate.

Thanks!

"RB Smissaert" wrote in message @TK2MSFTNGP04.phx.gbl...
> Only 2 things are hidden in an Excel .xla file:
> The worksheets.
> Direct access to the procedures via the Excel interface with: Tools,
> Macro, Macros.
> The .xla will have to make a menu in Excel to make the code available.
> All else is just as available as a normal .xls file.
> You can set a password on the IDE, but this can be cracked easily.
>
> Simplest way to hide code is to buy VB6 and move code to an ActiveX dll.
> If you can code in VBA then moving your code to this ActiveX dll is
> simple.
>
> RBS
>
>
> "Ralph" wrote in message
> @TK2MSFTNGP04.phx.gbl...
>>
>> "OfficeUser" wrote in message
>> @corp.supernews.com...
>>> Thanks, Ralph, for responding!
>>>
>>> I am planning to create an Excel Add-In and I want to "hide" code for
>>> certain features (licensing, time sensitivity, number of uses, etc)
>>> somewhere. My idea was to "hide" the code inside a .dll file to make it
>>> difficult for at least the average user to get to. I was hoping to be
>>> able
>>> to create a .dll file using VBA because I know that language. I do no
>>> know
>>> VB6, C++, Delphi or any other language. Do you have any suggestions for
>>> where I can "hide" VBA code inside Excel?
>>>
>>> Thanks!!
>>>
>>
>> AFAIK the only way to truly 'hide' code is to create an ActiveX or
>> Regular
>> Dll. But, guess what? I am a VB/C++ programmer and thus have never had to
>> seek out another "hammer" for this particular "nail".
>>
>> I have heard of schemes where 'macros' can be protected in enterprise
>> environments with a password. But I doubt any such scheme would work in
>> the
>> Wild. There may be other ways to shroud VBA code. (What in programming is
>> impossible? )
>>
>> However, while your original post asked about "VBA", we now know you are
>> talking about Excel. You should take a look at creating an "Excel Add-In"
>> (.xla).
>> http://msdn2.microsoft.com/en-us/library/aa140990(office.10).aspx
>> I know they are 'hidden' to a degree, but I don't know to what degree.
>>
>> I suggest that you post to an Office Excel Developers group.
>> hth
>> -ralph
>>
>>
>

RB Smissaert · Joined: 04 Oct 2007 Posts: 865

Coding in VB6 and in VBA is just very similar.
You will need to learn a few basics specific to VB6, but you will get the
hang of it in a few days.
Best book to get started is probably the book by Bullen et al. Professional
Excel Development.
This has some chapters that deal with moving code from Excel to VB6.

RBS

"OfficeUser" wrote in message @corp.supernews.com...
> Thanks for responding, Bart!
>
> << If you can code in VBA then moving your code to this ActiveX dll is
> simple>>
>
> Would you please elaborate.
>
> Thanks!
>
>
> "RB Smissaert" wrote in message
> @TK2MSFTNGP04.phx.gbl...
>> Only 2 things are hidden in an Excel .xla file:
>> The worksheets.
>> Direct access to the procedures via the Excel interface with: Tools,
>> Macro, Macros.
>> The .xla will have to make a menu in Excel to make the code available.
>> All else is just as available as a normal .xls file.
>> You can set a password on the IDE, but this can be cracked easily.
>>
>> Simplest way to hide code is to buy VB6 and move code to an ActiveX dll.
>> If you can code in VBA then moving your code to this ActiveX dll is
>> simple.
>>
>> RBS
>>
>>
>> "Ralph" wrote in message
>> @TK2MSFTNGP04.phx.gbl...
>>>
>>> "OfficeUser" wrote in message
>>> @corp.supernews.com...
>>>> Thanks, Ralph, for responding!
>>>>
>>>> I am planning to create an Excel Add-In and I want to "hide" code for
>>>> certain features (licensing, time sensitivity, number of uses, etc)
>>>> somewhere. My idea was to "hide" the code inside a .dll file to make it
>>>> difficult for at least the average user to get to. I was hoping to be
>>>> able
>>>> to create a .dll file using VBA because I know that language. I do no
>>>> know
>>>> VB6, C++, Delphi or any other language. Do you have any suggestions for
>>>> where I can "hide" VBA code inside Excel?
>>>>
>>>> Thanks!!
>>>>
>>>
>>> AFAIK the only way to truly 'hide' code is to create an ActiveX or
>>> Regular
>>> Dll. But, guess what? I am a VB/C++ programmer and thus have never had
>>> to
>>> seek out another "hammer" for this particular "nail".
>>>
>>> I have heard of schemes where 'macros' can be protected in enterprise
>>> environments with a password. But I doubt any such scheme would work in
>>> the
>>> Wild. There may be other ways to shroud VBA code. (What in programming
>>> is
>>> impossible? )
>>>
>>> However, while your original post asked about "VBA", we now know you are
>>> talking about Excel. You should take a look at creating an "Excel
>>> Add-In"
>>> (.xla).
>>> http://msdn2.microsoft.com/en-us/library/aa140990(office.10).aspx
>>> I know they are 'hidden' to a degree, but I don't know to what degree.
>>>
>>> I suggest that you post to an Office Excel Developers group.
>>> hth
>>> -ralph
>>>
>>>
>>
>
>

DanS · Joined: 04 Oct 2007 Posts: 212

"Thorsten Albers" wrote in$a4160500$9f01a8c0@xyz:

> Look out for the MS Visual Basic Control Creation Edition (VBCCE).
> Its
> AFAIK the
> only free tool to create COM/ActiveX-DLLs. Don't know if you will
> find
> it
> anywhere at all.

A d/l was found here: http://www.thevbzone.com/vbcce.htm

but nowhere near the MS site.

Ralph · Joined: 04 Oct 2007 Posts: 4148

"DanS" wrote in message@66.250.146.128...
> "Thorsten Albers" wrote in
> $a4160500$9f01a8c0@xyz:
>
> > Look out for the MS Visual Basic Control Creation Edition (VBCCE).
> > Its
> > AFAIK the
> > only free tool to create COM/ActiveX-DLLs. Don't know if you will
> > find
> > it
> > anywhere at all.
>
> A d/l was found here: http://www.thevbzone.com/vbcce.htm
>
> but nowhere near the MS site.

Hey!

Thanks for that info.

-ralph

OfficeUser · Joined: 02 Feb 2008 Posts: 16

Suppose I had the following functions all written in VBA, how do I get them
into a DLL file and how do I then call them from external VBA
code?

Function MyProc1()
Function MyProc2(parameterA, parameterB) As Long
Function MyProc3(parameterC, parameterD) As String

Thanks,

"Thorsten Albers" wrote in message $a4160500$9f01a8c0@xyz...
> OfficeUser schrieb im Beitrag
> ...
>> Two questions ............
>> 1. Can VBA be used to create the procedures in a dll file?
>
> Yes, it can. But it can not be used to create a DLL file...
>
>> 2. Can anyone give me recommendations for free downlaodable tools for
>> compiling a dll file?
>
> Make your choice:
>
> [ ] I want to create a COM/ActiveX-DLL with access to public procedures
> via
> the COM interface.
>
> Look out for the MS Visual Basic Control Creation Edition (VBCCE). Its
> AFAIK the
> only free tool to create COM/ActiveX-DLLs. Don't know if you will find
> it
> anywhere at all.
>
> [ ] I want to create a 'standard' DLL with access to exported procedures
> via an export list.
>
> Any free C/C++ compiler should be able to do this. In addition there
> are
> other languages (e.g. PowerBasic, Delphi) with which 'standard' DLLs
> may
> be created.
>
> --
> ----------------------------------------------------------------------
> THORSTEN ALBERS Universität Freiburg
> albers@
> uni-freiburg.de
> ----------------------------------------------------------------------
>

Ralph · Joined: 04 Oct 2007 Posts: 4148

"OfficeUser" wrote in message@corp.supernews.com...
> Suppose I had the following functions all written in VBA, how do I get
them
> into a DLL file and how do I then call them from external VBA
> code?
>
> Function MyProc1()
> Function MyProc2(parameterA, parameterB) As Long
> Function MyProc3(parameterC, parameterD) As String
>
> Thanks,
>

Did you download the tool?

How far have you got?

-ralph

Thorsten Albers · Joined: 04 Oct 2007 Posts: 756

OfficeUser schrieb im Beitrag
...
> Suppose I had the following functions all written in VBA, how do I get
them
> into a DLL file and how do I then call them from external VBA
> code?
>
> Function MyProc1()
> Function MyProc2(parameterA, parameterB) As Long
> Function MyProc3(parameterC, parameterD) As String

Presumably you missed that ironical nuance in my answer. Of course VBA can
be used to create >>the procedures<< in a DLL file as long as you have
another application which is able to read and interpete the code of the
procedures, and which can compile it to a DLL. To give you a clue: You can
e.g. put the functions in a standard or class module in the application
with the VBA support. Then you can export this module to a file (*.BAS,
*.CLS), add it to a VB project, and compile the VB project to a COM/ActiveX
DLL. Obviously this doesn't make much sense since you can write the
function's code directly in the IDE of the application which is used to
compile the code (VB or VBCCE).

--
----------------------------------------------------------------------
THORSTEN ALBERS Universität Freiburg
albers@
uni-freiburg.de
----------------------------------------------------------------------

OfficeUser · Joined: 02 Feb 2008 Posts: 16

I downloaded MS Visual Basic Control Creation Edition and when I open it I
don't know where to go from there. Can you give me a jumpstart on how to use
VBCEE to get my functions (see previous post) into a DLL file and how do I
then call them from external VBA code?

Thanks!!

"Ralph" wrote in message @TK2MSFTNGP06.phx.gbl...
>
> "OfficeUser" wrote in message
> @corp.supernews.com...
>> Suppose I had the following functions all written in VBA, how do I get
> them
>> into a DLL file and how do I then call them from external VBA
>> code?
>>
>> Function MyProc1()
>> Function MyProc2(parameterA, parameterB) As Long
>> Function MyProc3(parameterC, parameterD) As String
>>
>> Thanks,
>>
>
> Did you download the tool?
>
> How far have you got?
>
> -ralph
>
>

GetOpenFileName/Scroll deafault file in the file list into v I am using the from VB to display then "File Open" dialog box. You can also specify a default file in this dialog. Is there a way to scroll the file list in the dialog, so that this default file(name) is visible (and selected) in the fil

Closing File Handles to release locked file Hello everyone I would like to be able to close a file handle on a locked file. I have a situation where one program creates a Word document based on a template, and then passes the new document to Word for editing. However, the template is not released

How can I execute File Operations using the Windows File Tra Hi Gang, I would like to have my program use the built in Move and Copy Dialogs that are used by Windows Explorer/My Computer. Thanks in Advance, Christian Blackburn

Identify a file type and open the file Hi All, I want to write C# code to identify a file type and open the file in the associated editor. For example, text files should be identified and opened in notepad, html should be opened in internet At design time, I do not k

HOW TO find the target file name of a lnk file via an API ? Hi, I have a file "shortcut to in the startup directory How to find, via an windows API, the name of the target file ? (here "MyFile.exe")