byval

Hello, This is the first time am trying out web scraping using VBA. with the help of WiseOwl blog i was able to write the below and am successful till macro clicks to download the file. I would required help for two things: Mainly for downloading the XLS file where i presume we need to use...

I am trying to print a PDF (saved in a known path) to a new location (another known path). The reason I want to "re-print" the PDF file is to lock any comments that are in the original PDF file. I found the following solution to print a PDF file using the default printer; however it prompts the...

Hi guys, I am new to VBA and I need some help please. I created a calendar in vba using different sources that I found online. It I supposed to pop up in two cells on my Excel spreadsheet when I Click on those cells, and it does. The problem is that when I click on any date, it will not...

Hello boys, This is my code placed in a Workbook module. But the events do not fire. Can anyone know what is going on ? Private WithEvents dbConnection As ADODB.Connection Private WithEvents dbrecordset As ADODB.Recordset Private Sub dbConnection_ConnectComplete(ByVal pError As ADODB.Error...

maybe someone could help me to understand, what I'm doing wrong, as I'm stuck.. In general, I have a process, where I have an .vbs file, that triggers macro file, which makes connection to Hyperion and refreshes sheets. For some reason, when I'm triggering that macro, it always asks me to enter...

maybe someone could help me to understand, what I'm doing wrong, as I'm stuck.. In general, I have a process, where I have an .vbs file, that triggers macro file, which makes connection to Hyperion and refreshes sheets. For some reason, when I'm triggering that macro, it always asks me to enter...

hey guys, I have a scrollable UserForm with Frames and Listboxes. Everyime I clicked either of them the scrollbar jumped to the top of the clicked / focused control. I managed to solve this with a small piece of code in UserForm_Scroll sub but it only works for Frames and not Listboxes, they...

Looking at this: https://www.mrexcel.com/forum/excel-questions/573357-prevent-vba-editor-being-opened.html in particular this code: CBTProc = CallNextHookEx _ (lCBTHook, idHook, ByVal wParam, ByVal lParam) What is the significance of adding ByVal? My understanding...

Good day all, This is probably a really easy solution and i am just not competent enough in VBA I downloaded this userform calendar selector and am having issues with figuring out how to set a cell for it to point to as I am a novice in VBA Would someone mind explaining how I set a cell to...

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 trigger some codes via middle clicking the mouse button. However, the options for that button seem missing in Excel VBA? Private Sub UserForm_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) If (Button = xlPrimaryButton) Then...

this should be pretty simple. Declare PtrSafe Function SetCursorPos Lib "user32" (ByVal x As Long, ByVal y As Long) As Long I was capturing the mouse position with GetCursorPos, and I noticed that it would always treat the y value as zero. So I put in manual coordinates, and it still does the...

Hello All, First of all i have to advise that i'm not too familiar with VBA coding however i need your help. I work for a managed service provider and one of our clients use an excel spreadsheet to input and send data via an Excel VBAproject form. The author who created the form has left the...

Hi, I received a model with some strange function declarations. Does anyone know what this type of declaration is supposed to do? Declare Function closesession Lib "vpmsdl32.dll" (ByVal Session As Integer) As IntegerDeclare Function opensession Lib "vpmsdl32.dll" () As Integer Declare...

In Excel 2016 I am trying to use the "move and click mouse" macro listed in the below link that simulates mouse click actions in Excel via VBA. Link: https://excelhelphq.com/how-to-move-and-click-the-mouse-in-vba/ However, after pasting this code in to VBA the first two lines of code are...

Hello, I'm setting up a tool that will help to forecast staffing required to handle call volumes and would like some feedback. I have shared the file through the link below. The excel sheet does contain Macros. I'll post them for review as well. Many thanks to anyone who is willing to look...

Hi, I am trying to match the string typed into a user form against the windows password, how can I do this? There are no passwords stored anywhere and the string that is typed is covered by stars so the passwords won't be visible when typed. The code below is from Expert Exchange Option...

Hi This is my first time working on API for Minimizing, Maximizing Buttons on Userform and Found the below following code at https://stackoverflow.com/questions/50853247/excel-vba-userform-minimise-button Would it be possible for a command button Click to automatically minimize the userform...

Several years ago this forum assisted me with the following code which will type an asterisk in place of the letter typed in order to hide your password from sight as you type it on screen It works fine as long as Excel is running in 32 bit mode. Some users who open up my workbooks are in 64...

Hi guys, I do hope you guys are able to help in as I would like to set printing layout for pdf before printing them. I would like my setting to print all, multiple with 2 sheets per page,page order horizontal, print on both side with flipping on long edge and lastly orientation is landscape...