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
I used xlwings to open excel workbook. It worked fine up to last month. But today, when I run the same code, it opened my worksheet but convert my worksheet nam
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
I need to filter a collection that have "HoldingSubholding" column, that can have lot of different value. I need All the rows with the values except the rows th
When IE gets removed from Windows, will this impact XMLHTTP60 and my Excel VBA code? How could one confirm?
Sorting I need help in the below formula that I am using to number the above table in the "Sorted Numbering" column. The formula that I am using basis which th
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 have a spreadsheet of identification numbers, and various results for each. I used a couple formula to see if the subject passed or failed any of a set of cri
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
In my vba code right now the goal is to add a plus and minus button every time the add button is pressed. As you can see in the gif when the user presses add a
I have a workbook in which I get data from a program and I was trying to automate some of the tasks, Basically there is data for a game every 4 rows and it goes
I have a VBA script that copies and paste data from one workbook to another, but I would like to get my script so when I click run, windows explorer window open
I have a Excel file containing data for simulations. Each row is a simulation and contains data that i want to copy and paste into another software at a specifi
I am trying to create a database from SEC filings. The filings come in .tsv files and are structured in folders by year and quarter. Ever folder contains about
I am very new to programming and working on a web project. I used node-xlsx make a button that export excel data. But I got an error "Cannot read properties of
I currently have this code : Sub FilterRows() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets Sheets(ws).Range("A1").AutoFilter