I'm writing a program to read a large xml file and create an excel file from it. The attributes of each node will be the column headers in excel file. I created
In Workbook.Open() I have an Application.OnKey for every letter on the keyboard and all the numbers. The letters open a sub LetterPress(L as String) Example for
I'm trying to turn general data written as fractions like 3/4" or 13 7/32" into 3 place decimal numbers such as 0.750 or 13.219. I have a working table replacem
The code works when the criteria exists. I get an error when the criteria doesn't exist. ' Define constants. Const srcName As String = "wfm_rawdata" Const srcFi
I am trying to extract the email address from each individual undeliverables email body. The email body would be like: ----------------------------Email-------
I know the method as Application.Visible = False and Application.Screenupdating = False When opening the file, I want the user to see only the userform. The
Is there a way in C# to switch off macros in excel before loading an excel file. I am loading the excel file using Excel Interop. All I can see is solutions for
Does ClosedXML have any function that can be used to save an excel file as PDF? Currently i am using ClosedXML to create and populate the excel file and then u
I have an Excel document consisting of data imported into multiple tabs. The columns in each tab are stretched out and hard to read. I am trying to cycle throug
I have created a windows application in C# and I am using excel as a temporary database. I am able to read in the excel data, but I have no idea how to update
I'm trying to add 9 hours to this column and if there's a text like (off, annual, ..etc), then put the same text. but i found an error in the generated column,
I use JXLS to create my woorkbook. JXLS uses POI underneath. To create a workbook JXLS either need a File or an input stream. With file object I get my desired
I have a workbook with several comboboxes (and listboxes) and a lot of vba written around them. I've used the same code in the Workbook_Open procedure to format
I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I think some kind of exit at t
I am relatively new to python and Stackoverflow but hoping anyone can shed some light of my current problem. I have a python script that takes excel files (.xls
I am creating an activity tracker in Excel. I'd like to be able to "Select all that apply" from drop down lists in two separate columns on the same sheet. I am
I wrote a macro to check if a date is the last day of a month. If so this cell should blink every 1 second, so I'm calling a Do While loop. I want to start the
I have a program which writes to a spreadsheet using openpyxl. Upon execution of the program, the cells are filled as expected but the spreadsheet becomes damag
I'm trying to use two custom lists to order the columns in a specific reach. First I define the two custom lists (arrays) and in the .Sort statement I give the
How do I color all the series (lines) in a specific (selected/current) chart the same color? I have the following, but it does nothing: Sub Same_Color() Dim