CODEWITHSUNDEEP
vbaexcel
user206168
user206168

Reputation: 1025

Excel compiler error 64 bit

My code worked fine in excel 2010 version but I am not sure what am I need to change in 2013 version.

Option Explicit

Private Declare Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" (ByVal pCaller As Long, _
ByVal szURL As String, ByVal szFileName As String, _
ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

Dim Ret As Long

'~~> This is where the images will be saved. Change as applicable
Const FolderName As String = "C:\Temp\"

Upvotes: 1

Views: 687

Answers (1)

Demetri
Demetri

Reputation: 859

I tend to convert these types of functions to ones that are PTRSafe:

Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" _
Alias "URLDownloadToFileA" (ByVal pCaller As LongPtr, _
ByVal szURL As String, ByVal szFileName As String, _
ByVal dwReserved As LongPtr, ByVal lpfnCB As LongPtr) As LongPtr
Dim Ret As LongPtr

This consists of adding the word "PtrSafe" and changing all "Long" variables to LongPtr

Upvotes: 2

Related Questions