64 Bit system get error

[Abhijeet]

Hi
I have this macro this is not work on 64 bit system Error is getting in this Declare Function SetCurrentDirectoryA Lib "kernel32" (ByVal Path As String) As Long line.So please help me

 

[Deepak]

This might help.

#If VBA7 Then
    Private Declare PtrSafe Function SetCurrentDirectoryA Lib "kernel32" (ByVal Path As String) As Long
#Else
    Private Declare Function SetCurrentDirectoryA Lib "kernel32" (ByVal Path As String) As Long
#End If

& for so on so...

 

[Abhijeet]

From this macro how to change the pivot table as per different format data

 

[Deepak]

From this macro how to change the pivot table as per different format data

This wasn't a part of your query. Well!! have a wait as soon someone will take loop on that too.

 

[Abhijeet]

can i new post for this then or shall i continue here

 

[Deepak]

can i new post for this then or shall i continue here

I recommended new post with proper issue briefing & meaningful subject.