excel vba 2016

Good day all, I hope this makes sense. I have a workbook that contains 2 sheets to start: One is called "Master" (Sheet1) - I have a macro that creates a copy of this sheet and renames it, so I hit the button, it creates a new sheet, I fill out the necessary cells, save it and do what I need...

Hey guys. I have a question. I have a site and I want to pull data through this website. I wrote a VBA code but it seems it always return empty even though there are data. Here is the code; Sub dataxx() Dim request As New WinHttpRequest request.Open "Get"...

Morning everyone I have got the code which perfectly working. combobox1 finds the staff number and then populates names in Combobox 1 & 5 however i would like to change this from a staff number to names find below is the code whereby it finds it using the staff number. the staff number is in...

Hello, I have some old visual basic macros I am trying to convert to excel VBA. I am not sure what to do about the CommonDialog object. Searching online, I found that it’s obsolete and replaced by something else. Couldn’t find by what. Any suggestions Thanks

I have a sheet "data-dump", which has data from row 2 (column A to D) onwards where row 2 has got headers. The first 2 columns of the sheet has Start-Date & End-Date. I need to create a macro such that it reads the data in the sheet "data-dump" and based on the column A & B i.e. Start-Date &...

Hello! Unfortunately, I have not worked with VBA arrays so far, and thus I don't know of how to transfer values in a column to an array. I hope someone can help me find a solution for it I have a variable list of URLs in column (("A1:A" & lastRow)) of worksheet "sheet1" wherêby lastRow =...

I am trying to loop through a number of cells with vba, and return each cell's value. I used the watch windows, and saw that even though the cell().value returned a number different than 0, the a point array of double was assigned a value of 0. This is the code that I got from a site and edited...

HI all, Need a hand please... I am puzzled as to why the below code takes my file from 3.5mb to 100mb after running it once. I thought it was empty rows being added, but with the code to delete empty rows, it is still happening. Where did I go wrong... All I am doing is copying data to my...

Hi Friends, Trying to extract 2 or 3 keywords from cell content through excel vba. Sheet1 ColumnA has rows with content sample file attached. I need vba to search for keywords from sheet2 ColumnA in Sheet1 and extract 2 or 3 or 4 keywords from each row content into sheet3.(Popup box would be...

Hi all, can anyone help me call this function? I found this function to check if a sheet exists but I dont know how to call it. The macro looks at a folder and opens every excel workbook in it, extracting data. I am adding the fucntion for the eventuality that the user point the folderpicker...

Hello all, Can decipher this impenetrable code sufficiently to make it ignore the first row on the sheet on which it runs? I am changing the sheet so that the control buttons take up row one. This sub is called from a larger sub that also changes the button settings so that they are...

Hi folks, I am a bit syuck on the auto-filter syntax. can anyone tell me how to change this so that I am not copying and pasting the whole row, but only copying range "A" to "L" to usdrws and pasting into range "B" to "M", (same rows as below). ws.AutoFilter.Range.Offset(1).EntireRow.Copy...

Hi, I wonder if anyone knows how to do this? I would really appreciate some help. I did find something i think is the answer but it is very old and i have no idea how to use it. I have a macro that runs through an excel sheet, reads an address of otehr workbooks from hyperlinks in column A...

I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...

Hi, i could really use some help with this. i have this code that checks a column for an illegal character (for sheet name) and replaces it with "_". I want it to check for the fill list of characters that are not allowable sheet names .Pattern = "[\<\>\*\\\/\?|]" Sub...

Can anyone figure out why this fails? I have done everything i can think of to make sure there is nothing to bother it. I have run it with the header cleared, I have deleted all rows with any illegal characters. Ii have added a little sub to do this too. I am using a script i that creates...

Hi, i have some code that a) filters data from the table in one sheet into a group of new sheets named by the filter value b) creates a new workbook from these sheets The script does the above. The additional code has no effect that i can see. It doesnt stop it working, it just doesnt do...

I have expenses sheets where various columns of figures need to be totalled according to the filter criteria in the costs centre column. I had been trying the subtotal 9/109 function expecting that to work, but it seems you can only subtotal if the column is filtered on its own values. The...

Hello, if anyone knows how to do this, I would appreciate a pointer. There are a few threads on it but i havent found one that actually answers the question of how to do it as one PDF with different orientations per page. This is where i am at so far... Sub ExportPDF2() Dim sFile As String...

Good day all, Please, I have a slight problem. I created a userform with 40 textboxes that submits its contents to sheet1. The userform generates a time stamp in a label (label2) using Format(Now(), "H:MM"). When I click the submit button upon filling the form, each filled textbox is...