I have an Excel file that uses VBA to calculate active ranges for a few sheets to make a .csv file to be picked up by a reporting server. Every once in a while,
I have 12,00,000 records and have to generate an excel file. while generating I found the excel sheet was allow only 10,00,000+ records. while adding these reco
I have an excel file with damaged rows on the top (3 first rows) which needs to be skipped, I'm using spark-excel library to read the excel file, on their githu
I have an Excel with an embedded image. How can I send it by mail using the name of the image? I do not want to send it attached, I want to embed it in the htm
I am trying to change Marker Fore Color of series 4 and 6 to two different colors, but somehow they have the same color. Please kindly advice series1.Format.Lin
I am new to programming Python using Pycharm. I would like to access openpyxl (which I installed) but get the following error message: Traceback (most recent
Good afternoon experts have a problem and I need to read the entire excel file by column name instead of its index,example: Column1 | Column2 | Column3 data1
Problem I've been tasked to tidy up some very messy data containing a mix of text and numbers and wish to use power query to separate codes from the data. Fortu
I found this code, but it doesn't include the signature. In all the resources I've read, I couldn't come up with a solution. Public Function Email_Test() Dim
Is there any way to trigger Azure data bricks notebook from excel, if is there please help me how..? Many thanks
I have a code that sends an email too individuals on a list. I need the user's signature to appear at the bottom of the email. I cannot get it to display. B
I have VBA code in Excel that sends an email via Outlook 365. My primary email account (@outlook.com) has five aliases. These are not separate email accounts b
| A | B ------|-----|-------- 1 | x | 1 2 | y | 2 3 | z | 3 4 | a | =B1*B2+B3 Imagine the above stuff is part of an ex
I have this: .SentOnBehalfOfName = """Customer Service"" <[email protected]>" the name "Customer Service" is officially associated with the
I want to disable cell editing (direct typing into cell) but want to update that cell through code without protecting worksheet Does anyone have any idea?
I have data in Excel like follows (one row here - one cell in Excel): 07 July 2015 12:02 – 14 July 2015 17:02 12 August 2015 22:02 – 01 September 2
I create weekly files that are being saved in week specific folders and I want to create a flow that will automatically lock & password protect the file eve
Thanks for your helps, I have two arrays: A (100k row, 10 col) and B (100k row, 12 col) The following code (thanks to BSALV) loop through A and B => It takes
i am trying to add a translator in Excel, but i can't figure out where the mistake is in my Code: I am trying to add a translator in Excel via VBA. The problem
I'm very new to VBA and I'm struggling with something I can't manage to succeed. I have several columns, some of which work in pairs : the first element of