Squat
08-01-2018 12:54:19
Bom dia pessoal,
Fiz uma macro (Excel 2007) que copia alguns dados da algumas pastas de trabalho para a pasta Matriz e efetua alguns cálculos. Entretanto, aqui no trabalho, algumas pessoas possuem o Excel 2013 instalado em seus computadores, e quando essas pessoas vão abrir o arquivo ele não copia os dados das outras pastas de trabalho.
Pesquisando aqui no fórum, vi pode ser algo relacionado aos APIs do Windows, e da versão do Excel, utilizei essas instruções (abaixo) em um módulo do arquivo Matriz mas não obtive sucesso, será que algum forista poderia me ajudar?
Option Explicit
#If VBA7 Then ' Avalia as versões do Office 2010+
#If Win64 Then ' Arquitetura 64 Bits do Office
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 LongLong
Private Declare PtrSafe Function DrawMenuBar Lib "User32" (ByVal hwnd As Long) As LongLong
#ElseIf Win32 Then ' Arquitetura 32 Bits do Office
Private Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare PtrSafe Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare PtrSafe Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare PtrSafe Function DrawMenuBar Lib "User32" (ByVal hwnd As Long) As Long
#End If
#ElseIf VBA6 Then ' Avalia as versões do Office 2007-
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
Seguem os arquivos como modelo.
Fiz uma macro (Excel 2007) que copia alguns dados da algumas pastas de trabalho para a pasta Matriz e efetua alguns cálculos. Entretanto, aqui no trabalho, algumas pessoas possuem o Excel 2013 instalado em seus computadores, e quando essas pessoas vão abrir o arquivo ele não copia os dados das outras pastas de trabalho.
Pesquisando aqui no fórum, vi pode ser algo relacionado aos APIs do Windows, e da versão do Excel, utilizei essas instruções (abaixo) em um módulo do arquivo Matriz mas não obtive sucesso, será que algum forista poderia me ajudar?
Option Explicit
#If VBA7 Then ' Avalia as versões do Office 2010+
#If Win64 Then ' Arquitetura 64 Bits do Office
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 LongLong
Private Declare PtrSafe Function DrawMenuBar Lib "User32" (ByVal hwnd As Long) As LongLong
#ElseIf Win32 Then ' Arquitetura 32 Bits do Office
Private Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare PtrSafe Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long) As Long
Private Declare PtrSafe Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Declare PtrSafe Function DrawMenuBar Lib "User32" (ByVal hwnd As Long) As Long
#End If
#ElseIf VBA6 Then ' Avalia as versões do Office 2007-
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
Seguem os arquivos como modelo.