I am trying to make kws grouping using excel, but my formula is becoming gigantic. I was wondering if there is an easier way to do what I am trying to accomplis
How can I convert/save excel file to pdf? I'm using java play framework to generate some excel files and now the requirement changes to pdf. I don't want to rec
I'm trying to teach myself VBA during the short holiday break. For my first module, I want to create a module that does the following: Displays dialog box. Pro
I need to calculate a sheet of interest in excel using python. There is a method to calculate the entire workbook using the following code. import xlwings as xw
In Windows Explorer, if I right-click a file and choose Properties to get the file's Properties window, and then select the Details tab, there is a property lis
I have an image in my worksheet I want to fade out. I am tying to set different stages of transparency for the image: Set myPicture = ActiveSheet.Pictures.Inser
I have a data sheet "orders" which has data in the format order no Customer Sales Executive Order Status Order Date 211 nokia john cancelled 2
I have several script that have a part that is copying Charts and Pasting it in an area as Picture. Those scripts are working without any error when I look at t
Background:I have a large 40MB XLSX file that contains client data which is Grouped over multiple levels, like so: Expanded - Not Expanded (sorry about the ter
Some Excel native functions like VSTACK permit of infinite number of arguments, and they have an intellisense as follows: I would like to know how to define su
I've been successfully using the Yahoo Finance API cookie/crumb technique to get historical stock quotes for many years. On April 28th, 2022, it broke, and exc
I have an excel spreadsheet that has drop down comboboxes on sheet 1. I am trying to find out how to autofill the 5 boxes to the left of the combobox with conte
I am trying to select a worksheet every time when i open up a workbook using an inputbox in VBA. here is my code for opening a workbook but after i open up my w
I need to place a userform next to a selected cell. Here's my code. Excel 2013. In the userform module: Private rangePosition As Range 'Property passed to for
I have created Excel addin project using Visual Studio to insert a data into database. The problem is I'm unable to open a File upload box in this. I am getting
Good morning, I need to set cells background colors using PHPExcel, but I don't know how to do it. This is for my header and It's working: $styleArray = arr
I have a VBA project where I need to create a userform on which there should be an attachment button to select multiple images and save them in a folder with a
I want to look through my Excel worksheets and find a sheet with a certain name and delete that sheet if it is found. Afterwards I want to create a sheet after
I have an array of 30 columns and 800 rows (Sheet 1), each cell has either text or is blank. I want to check if ANY values in this array (specificially row by r
The goal is to iterate through rows of the character table and replace each character with it's substitute. The character table in this example is ={"&","&a