I was not looking at VBA for a while, and I would really appreciate your help. Private Sub EvaluateButton_Click() Dim r As Long Dim x As Long Worksheets("tests
With some of the success of other automations, I am looking to see if it is possible to move rows of data from my excel workbook into a new one based upon the v
Im working on a excel script, that will import a CSV file, analyse the result and create a report based on the analyse. The CSV file contain up to 12 measuremen
What does the statement Selection.QueryTable.Refresh BackgroundQuery:=False do in excel macro? Does it disable background refresh for the selected table?
I have some conditional formatting together with a module, that for some reason prevents my macros from running all the way through. =NOT(TestColor(E8)) is my c
I am using the below code to: Delete the similar rows, keeping only one and combine cells values in the range "N", separated by vbLf it works ,but with big rang
I am currently working on a Word-document I want to use as a template. This template provides a "structure" including many bookmakrs. The template is filled usi
I am using code on Outlook to hide the mouse cursor on Outlook before opening the attached workbook: Private Declare Function ShowCursor Lib "USER32" (ByVal fSh
MS Access Database: I have a report that I want to open from a form with multiple filter fields. Each filter works fine when used individually. They do not wo
I use a MS Form to collect Data and use an xlsm.file where I copy the new data and then further work with the data. In order to update the data, I have to Open
Please help me with the code to insert a column in excel using vba. Here is what I am doing - Sheet1.Range("A:A").EntireColumn.insert
When running automatically via Workbook_Open, it throws a 91 error. However, running the same code manually does not. It's machine specific. No problems on a
When IE gets removed from Windows, will this impact XMLHTTP60 and my Excel VBA code? How could one confirm?
There is an xlsm file which I need to open and edit and extract data as per the macros enabled in the sheet. But I'm not able to open the file itself. I tried:
I am working on a vba macro to parse large xml files. Initially, i made use of DOM parser but due to memory leak the system hangs and that could not solve my pr
I was wondering if there is a way to add the Reply arrow to a selected mail in Outlook via VBA. The background is that we process a selected mail via VBA and cr
I am trying to copy a whole pdf document into excel using the following code. The code works perfectly except for the paste part, when it gives me the following
I am trying to insert 2 different ranges "x" amount of times based on the input from the user. The user chooses how many mounts they need "D22" and a range is c
'This code generates files that cannot be opened Sub DownloadPicturestoFile() Dim FileUrl As String Dim objXmlHttpReq As Object Dim objStream As Object Dim Nam
I have an input text file(Line size and column size varies). I want to convert it into document with the same format(same length as in text file, not to span to