32 Bit vs 64 Bit VBA

[ercedwards]

I have an Excel application written in Excel 2010 64 Bit.

Everything has run fine for months but I needed to add a Chdir command and ran into a problem.

I added in a

Private Declare PtrSafe Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long

to my code and everything is back to running fine again on the 64 Bit version. For users with 32 Bit I have a version of the Workbook without the Ptrsafe.

Do I really need two versions of this workbook, one for 32 Bit and one for 64 Bit or is there a way to alter the declare if I can find which version of VBA the user is running?

Thanks

 

[Jaafar Tribak]

You shouldn't need two versions of the workbook.

Use Conditional Compilation directives .. Something like this :

#If VBA7 Then
    Private Declare PtrSafe Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long
[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=Else"]#Else[/URL] 
    Private Declare Function SetCurrentDirectoryA Lib "kernel32" (ByVal lpPathName As String) As Long
[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=End"]#End[/URL]  If

 

[Norie]

Why do you need Windows API to use ChDir?

 

[ercedwards]

Perfect.

Thanks much

 

[ercedwards]

Because the directories are on a network drive.