ok.sh | Bourne shell GitHub API client library | Command Line Interface library

I export a schedule from MS Teams to Excel for data manipulation.

I made a macro that changes the dates field to a date format for the EU and sorts by it by date.
Then it goes to the next worksheet and checks the names of employees and creates a worksheet for each of the names.
Then it jumps back to the first worksheet, sorts by "name" criteria and copies the data for every single one to its own respective worksheet.

This is what I got so far that is OK:

I am working on Userforms in VBA for the first time. I have a calendar userform from which I select a date which is displayed on a textbox. By default the textbox shows the current day. At the bottom I have a listbox. I want to filter the data in the listbox based on the current date/date selected by the user.

I am doing this but it does produce any result in the listbox. Do I need to convert the date into some other type?

Hello i have macro where download all attachments from multiple emails, this code works fine, but I need change code to change every file name where was downloaded in folder, files name like "I10001258", "I10003256", "I10004758"... I wanna delete first five letters "I10001258", for all downloading files. Thanks!

I need to work on the workbook in Excel that contains hundreds of specific worksheets. I created this simple code to get the list of names of all these worksheets in the one called "Spis faktur". The code runs well but is horribly slow. It seems like it executed the one name of specific worksheet in 0,3 second so it takes ages before it finishes to executed the of all names of worksheets.

I know there are already numerous posts on how to copy things from excel to ppt with VBA on this page (and many of those already helped me out) but I have a rather strange problem I haven't seen addressed:

The task is fairly standard: loop through an excel workbook with multiple sheets and copy all the charts contained in the workbook into a ppt presentation, one chart per slide and always the same layout. Below the code I use for this

I'm trying, when the workbook is open, to store two sheets to two variables.

Then, when a value is changed in master, set the changed worksheets to two new variables and then call the compare sheets function.

The compare sheets function will compare the original Worksheet variable to the temp Worksheet variable and highlight the differences in olive green.

Managed to get this sending using Excel with SMTP.

When sending one e-mail at a time, the first one has the signature displayed where it should be.
Second e-mail sent has the signature but adds the signature as an attachment.
Third e-mail sent has the signature but adds the signature as an attachment twice, and it will repeat the the cycle adding more signature images as attachments.

TLDR:

• 1 e-mail sent = 0 attachment
• 2 e-mails sent = 1 attachment
• 3 e-mails sent = 2 attachments

I don't want any attached files.

I wrote a docker-compose.yml like this:

I am trying to get a form to populate data from a sheet using cell Z as the lookup reference.

The dropdown on the form showing my list of issue references works. When I select an item from said list to populate the form I get the mismatch error.

Also, my range in Z column is a mix of letters and numbers. I did change I to variant but no luck

The application.match is returning an error. Any ideas?

Run Time error '13': Type Mismatch