you can use any Excel function in vba via
Application.WorksheetFunction.
Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4)
arg= parameters required in excel functions
Application.WorksheetFunction.VLookup(range("A1").value,Range("B1:D7"),2,0)
Best Regards,
Anubhav
On Monday, May 1
I have an excel sheet with some data on sheet2 and I need to export
this to an access database secured via workgroups security. The code I
have works fine with database without security workgroup.
Sub EXPORT()
Dim cn As ADODB.Connec
I will not comment on the authentication for those softwares, but
there are a lot of passware recovery softwares which gives you all
types of password you have lost.
Just Google "Lost Passware" and try your luck, you might get some
trial/free versions.
On Jun 28, 12:55 pm, JsinSk wrote:
> You wi
