Incompactibilidade 32bits e 64bits

Bruno Capelli

01-09-2015 14:36:57

Pessoal baixei este código na internet e coloquei em meu sistema ele retira as bordas dos forms porém parece que há um erro de compactibilidade para win 32 e 64bits tem como ajustar para que funcione nas duas plataformas?


MODULO abaixo

#If Win64 Then

Private Declare PtrSafe Function FindWindow Lib "USER32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As LongLong
Private Declare PtrSafe Function GetWindowLong Lib "USER32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As LongLong
Private Declare PtrSafe Function SetWindowLong Lib "USER32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As LongLongLong
Private Declare PtrSafe Function DrawMenuBar Lib "USER32" (ByVal hWnd As Long) As LongLong

#Else

Private Declare Function FindWindow Lib "USER32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLong Lib "USER32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLong Lib "USER32" Alias "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare Function DrawMenuBar Lib "USER32" (ByVal hWnd As Long) As Long

#End If



Sub Remove_bordas(objForm As Object)

Dim lStyle As Long
Dim hMenu As Long
Dim mhWndForm As Long

If Val(Application.Version) < 9 Then
mhWndForm = FindWindow("ThunderXFrame", objForm.Caption) 'XL97
Else
mhWndForm = FindWindow("ThunderDFrame", objForm.Caption) 'XL2000+
End If

lStyle = GetWindowLong(mhWndForm, -16)
lStyle = lStyle And Not &HC00000
SetWindowLong mhWndForm, -16, lStyle
DrawMenuBar mhWndForm

End Sub



Userform

Private Sub UserForm_Initialize()
'chama a macro para remover as bordas
Call Remove_bordas(Me)

Reinaldo

01-09-2015 15:24:28

Uma possibilidade
ActiveCell.Offset(1, 3) = CDate(Format(DATA_CADASTRO_BOX.Text ,"dd/mm/yyyy"))
Deverá incluir na planilha o valor serial da data.

messiasmbm

01-09-2015 16:10:02

Código: Selecionar todos

Sheets("CAD_CLI").Select
Range("A5001").End(xlUp).Select
ActiveCell.Offset(1, 0) = CODIGO_BOX.Text
ActiveCell.Offset(1, 1) = CPF_CNPJ_BOX.Text
ActiveCell.Offset(1, 2) = IE_BOX.Text
ActiveCell.Offset(1, 2) = DATA_CADASTRO_BOX
ActiveCell.Offset(1, 2) = Format(ActiveCell.Offset(1, 2), "dd/mm/yyyy")
tente assim...