[AccessD] comdlg32.dll

You can still use comdlg32.dll. It's available in both 32 and 64 bit Windows.

But you need to compile with the PtrSafe keyword.  Try this:

Declare PtrSafe Function GetOpenFileName Lib "comdlg32.dll" _    
               Alias "GetOpenFileNameA" (OFN As tagOPENFILENAME) As Boolean

If you code is likely to run in different versions of Windows/Office (32 and 64 bit), you  need to 
wrap the declarations in  compiler conditionals.

#If VBA7 Then
Declare PtrSafe Function GetOpenFileName Lib "comdlg32.dll" _    
               Alias "GetOpenFileNameA" (OFN As tagOPENFILENAME) As Boolean
#Else
Declare Function GetOpenFileName Lib "comdlg32.dll" _    
               Alias "GetOpenFileNameA" (OFN As tagOPENFILENAME) As Boolean
#End if

See http://msdn.microsoft.com/en-us/library/ee691831%28office.14%29.aspx for all the gory 
details.

-- 
Stuart
On 28 Sep 2012 at 10:29, Kostas Konstantinidis wrote:

> Hi all,
> I use the comdlg32.dll on a Dev Ashish and Terry Kreft 1999 code
> but now while we have upgraded to win 7 64-bit and office 64
> it need an update for all that...
> Is really there a "comdlg32.dll" available for office 64-bit?
> 
> thank's a lot
> 
> /kostas
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>