lib

Okay here is the issue. Where I work we updating Oracle SmartView to 64bit but before we do that we have to uninstall MS Office 32 bit and install office 64 bit. I did that and now when he opens the spreadsheet he gets the following message "though Compile error: The code in this project...

My hard drive crashed and now my macros will not work. I believe I need to go to Tools and References but what do I need to add for this line? Public Declare Function apiShowWindow Lib "user32" Alias "ShowWindow" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long I am running Windows 10 64...

When it crashes the error is highlighted on this line: Me.Caption = VBA.UCase$(Format$(VBA.Date, "yyyy - mmmm ")) & VBA.Day(VBA.Date) _ & " (" & VBA.Date & ")" I changed the declaration from this: Private Declare Function GetKeyState Lib "user32" (ByVal...

Hi all, Not sure if this is the right section of the forum to ask this question but I am trying to get the accessibility names of the workbook scrollbars and tabs .. The AccName function returns a string that is language dependent so when I run the code on my machine, I get the AccName in...

Hello everyone I have searched a lot and tried a lot of codes for clearing the clipboard and this is one of them Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long Public Declare Function EmptyClipboard Lib "user32" () As Long Public Declare Function CloseClipboard...

Hi, i have the code below in outlook 2013 and getting error the code in this project must be updated to 64 bit, how do i do that, thanks. Option Explicit Private Declare Function ShellExecute Lib "shell32.dll" Alias _ "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _...

I want to find a conversion for the Sleep API. Should it be: #If VBA7 Then ' Excel 2010 or later Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal Milliseconds As LongPtr) #Else ' Excel 2007 or earlier Public Declare Sub Sleep Lib "kernel32" (ByVal Milliseconds As Long)...

I have created 1000s of labels at runtime and I want to add a hover effect to them. The labels are originally designed as a white background and when you hover should go light grey and when clicked go dark grey. If you are not hovered over it anymore it should go back to its original color...

Hi, I have copied this code from the internet and it fades in my UserForm1 when called. Form Fader: Option Explicit#If VBA7 Then Private Declare PtrSafe Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _ (ByVal hWnd As LongPtr, ByVal lngWinIdx As Long, ByVal dwNewLong...

I think I'm doing something dumb since the solutions I've researched online don't work but I'm trying to sort a dynamic range of cells by their first column. Dim LastRow As Integer Dim LIB As String LIB = "Library" Sheets(LIB).Range("A65536").End(xlUp).Select LastRow = ActiveCell.Row...

Good Day All the Code Below works with 32 Bit what code For Excel 64 Bit ? Private Declare Function mciExecute Lib "winmm.dll" (ByVal lpstrCommand As String) As Long thanks

I found this code here in this forum which maximizes the userform to cover the whole screen. It worked for me but I have a multi page form and the multi page did not expand. So I wanna know if it can also expand as well. Then what happens to the controls on it. Will they too expand? Option...

Dear: everyone! I want to retrieve data as the data string length in the Formula Bar (the formula bar, rather from its Edit Box) I have used the following 1. Declare Private Declare Function FindWindow Lib "user32" Alias ​​"FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As...