I have 7 criteria = TMO-1 through to TMO-7 I have two scenarios to search from. i have either got a single excel with TMO-6, TMO-201, TMO-67,... etc (some have
I don't understand some parts in the following code: For i = 2 To UBound(a, 1) txt = Join$(Array(a(i, 3), a(i, 4)), Chr(2)) If Not dic.exist
The context is that I have a boatload of data dictionaries for various data bases strewn across multiple Word document files. Those files hav
Let's say I wanted to find the average number of calls per day. Normally, I can use the formula =COUNT(A2:A15)/SUM(1/(COUNTIF(A2:A15,A2:A15))) for the table bel
I have a dataset called verts imported from Excel with a column called Date that contains dates in this format: m/d/yyyy. I'm trying to extract the year from th
The black area contains a graph, when I hide the data the graph vanishes. I can still click on the graph and check/uncheck the "Show data in hidden rows and col
I want to insert an if statement in a cell through vba which includes double quotes. Here is my code: Worksheets("Sheet1").Range("A1").Value = "=IF(Sheet1!B1=
How can I read local excel data on my C# bot using bot framework SDK. I can't find any documentation for it. Can anyone help?
I'm thinking about writing script that convert my existing CSV file to XLSX file so I been following this post https://code.adonline.id.au/csv-to-xlsx-powershel
I have two xlsx files that have multiple tabs. I need to compare values in each tab based on the tab name. (e.g. sheet1 in file1 needs to be compared with sheet
My goal is to add a icon to my toolbar in the quick access section. I wish this code could look at the file that is open, check if the file name contains or rat
I am trying to filter data in an excel worksheet, copy the filtered data only and move it to a new workbook. However, when I complete that step, I still have ac
I have a data structure (array) in Access - 6 columns and 10 rows. I'm trying to write to a range in Excel ie B3:G12. I'm getting tied up in loops, literally. F
A user is trying to open an excel file (.xlsx) (using Open in App instead of in browser) from their Sharepoint site, but system tries to open it up in MS Word i
In Microsoft Excel I am considering columns and cells to make specific sums in a calculated column, here's an image as an example where the column "G" is where
My goal is to put the current week number in the subject of outgoing mail. Below gives me this week + 1. I used to have 2016, now have 365. Problem is still her
I have a table that contains the file path, when the button is clicked the macro will display an image according to the url path. Here is my code (sourch : Link
Here it is answered how to change a single cell to text format. In a nutshell, I can do from openpyxl.styles import numbers cell.number_format = numbers.FORMAT
I'm looking for help with some VBA Excel code to do some merging of various sheets into a workbook and during the copy perform some worksheet functions (e.g.).
please, I am making my own dictionary and cant figure out how to pull translation definitions from google translate. My idea is that python will open my excel f