Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default Windows API - Searching a fonction

Hi,
I am tryiing to find a function to encrypt some text or a file and the
corresponding decrypt function. In my search, i found some interesting
information but the code example is in ASP or C++ or something else but not
in VB or VBA. The information is also incomplete and practically unusable.
One of the links is:
http://msdn.microsoft.com/en-us/libr...21(VS.85).aspx
I would like to know if one can find a practical example of the declaration
in VBA along with an a simple example of call.
Actually, I would like to have access to a list of all the Windows API
fonctions and hot to use them in VB6 or VBA.
Note: I do not want a third party application that does the job.
Can someone help me, please?
Thanks
--
Jac Tremblay
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 449
Default Windows API - Searching a fonction

Hi Jac

When you know that VBA is VB6 it gets easier. Here's one million + hits for
a start:
http://www.google.com/search?hl=en&q...=vb6+enc rypt

Dunno why you want Windows to do the job, but there may well be several
Windows API solutions among them.

HTH. Best wishes Harald


"Jac Tremblay" wrote in message
...
Hi,
I am tryiing to find a function to encrypt some text or a file and the
corresponding decrypt function. In my search, i found some interesting
information but the code example is in ASP or C++ or something else but
not
in VB or VBA. The information is also incomplete and practically unusable.
One of the links is:
http://msdn.microsoft.com/en-us/libr...21(VS.85).aspx
I would like to know if one can find a practical example of the
declaration
in VBA along with an a simple example of call.
Actually, I would like to have access to a list of all the Windows API
fonctions and hot to use them in VB6 or VBA.
Note: I do not want a third party application that does the job.
Can someone help me, please?
Thanks
--
Jac Tremblay


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default Windows API - Searching a fonction

Hi Harald,
These links are super. That's exactly what I wanted. Thank you.
The reason why I want Windows to do the job is because I do not want to
program a crypting application and I cannot use a third party's application.
I need something sweet and simple. That is why I thought about Windows API.
Thanks for your quick answer and have a good day.
--
Jac Tremblay


"Harald Staff" wrote:

Hi Jac

When you know that VBA is VB6 it gets easier. Here's one million + hits for
a start:
http://www.google.com/search?hl=en&q...=vb6+enc rypt

Dunno why you want Windows to do the job, but there may well be several
Windows API solutions among them.

HTH. Best wishes Harald


"Jac Tremblay" wrote in message
...
Hi,
I am tryiing to find a function to encrypt some text or a file and the
corresponding decrypt function. In my search, i found some interesting
information but the code example is in ASP or C++ or something else but
not
in VB or VBA. The information is also incomplete and practically unusable.
One of the links is:
http://msdn.microsoft.com/en-us/libr...21(VS.85).aspx
I would like to know if one can find a practical example of the
declaration
in VBA along with an a simple example of call.
Actually, I would like to have access to a list of all the Windows API
fonctions and hot to use them in VB6 or VBA.
Note: I do not want a third party application that does the job.
Can someone help me, please?
Thanks
--
Jac Tremblay



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,549
Default Windows API - Searching a fonction

"I would like to have access to a list of all the Windows API
functions and how to use them in VB6 or VBA."

My list is 1500 pages long, contained in the "Visual Basic 5.0 -
Programmer's Guide to the Win32 API" by Dan Appleman
ISBN 1-56276-446-2
(only for the dedicated)

The "API Viewer 2004" is a free add-in with a display of all API
Subs and Functions; plus Types, Constants and Enumerations.
It allows you to copy any of them and paste directly into your code.
Properly installed you can access it from the Add-Ins menu in the VBE...
http://www.activevb.de/rubriken/apiv...g.html#anchor3
--
Jim Cone
Portland, Oregon USA


"Jac Tremblay"

wrote in message
Hi,
I am tryiing to find a function to encrypt some text or a file and the
corresponding decrypt function. In my search, i found some interesting
information but the code example is in ASP or C++ or something else but not
in VB or VBA. The information is also incomplete and practically unusable.
One of the links is:
http://msdn.microsoft.com/en-us/libr...21(VS.85).aspx
I would like to know if one can find a practical example of the declaration
in VBA along with an a simple example of call.
Actually, I would like to have access to a list of all the Windows API
fonctions and hot to use them in VB6 or VBA.
Note: I do not want a third party application that does the job.
Can someone help me, please?
Thanks
--
Jac Tremblay
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default Windows API - Searching a fonction

Hi Jim,
The API viewer 2004 is something I need. I checked it out at home last night
and it seems to do the job even though I couldn't find examples of calling
the functions (not yet at least).
I will try it again here at work and post back if I need to.
Thank you for this precious information.
Have a good day in Portland.
--
Jac Tremblay


"Jim Cone" wrote:

"I would like to have access to a list of all the Windows API
functions and how to use them in VB6 or VBA."

My list is 1500 pages long, contained in the "Visual Basic 5.0 -
Programmer's Guide to the Win32 API" by Dan Appleman
ISBN 1-56276-446-2
(only for the dedicated)

The "API Viewer 2004" is a free add-in with a display of all API
Subs and Functions; plus Types, Constants and Enumerations.
It allows you to copy any of them and paste directly into your code.
Properly installed you can access it from the Add-Ins menu in the VBE...
http://www.activevb.de/rubriken/apiv...g.html#anchor3
--
Jim Cone
Portland, Oregon USA


"Jac Tremblay"

wrote in message
Hi,
I am tryiing to find a function to encrypt some text or a file and the
corresponding decrypt function. In my search, i found some interesting
information but the code example is in ASP or C++ or something else but not
in VB or VBA. The information is also incomplete and practically unusable.
One of the links is:
http://msdn.microsoft.com/en-us/libr...21(VS.85).aspx
I would like to know if one can find a practical example of the declaration
in VBA along with an a simple example of call.
Actually, I would like to have access to a list of all the Windows API
fonctions and hot to use them in VB6 or VBA.
Note: I do not want a third party application that does the job.
Can someone help me, please?
Thanks
--
Jac Tremblay



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching Excel Properties / Data in Windows The Question guy Excel Discussion (Misc queries) 0 November 13th 08 03:05 AM
Le dialogue de fonction d'excel appel ma fonction "user defined" [email protected][_2_] Excel Programming 0 March 1st 06 02:28 AM
Help with max() fonction anyways Excel Worksheet Functions 3 February 22nd 06 04:46 PM
Using EQUIV and INDEX fonction in vba Alex St-Pierre Excel Programming 3 February 22nd 06 02:40 PM
=FONCTION(CELLULE(A1)) ? Olivier SOW Excel Programming 0 June 30th 05 09:41 AM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"