Forum

Hi Zeek, I doubt that this can be achieved with formulas, you will have to use a customized visual basic application. The rotation frequency is ...

Sure, why not, here it is. The code is emailing data tables, not pivot tables.

You can't attach a file to an email without creating that file in that location, right? Creating the pdf then attaching an xlsx (by simply changing...

Hi Kemal, You can attach any file you want to an email, that code works the same, just put the path to your xlsx instead of the pdf. You cannot ...

Is there a reason why you need vb code for this? The problems you indicate come from poor data structure, instead of those 12+sheets and forms to add ...

I would like to get the nearest later (or sometimes earlier?) date. Depending on what? You have to be more precise than that, we can't imagine th...

That date is not a valid date. Excel date system starts from 1/1/1900, this is Day 1. Today's date (april 11 2022) is represented by a number: 44662, ...

Hi Barry, 2 things you need to change: Set rng = Sheet1.Columns("B:B").Find(What:=dDate, _ LookIn:=xlFormulas, LookAt:=xlWhole, SearchOrder:=xlB...

Hi Justin, For a search form, you can find multiple versions on our site: Adding new data with a form (using a vba code) is not difficult, b...

Hi Ron, When you do a query from web, Power Query is using Web.Page function that converts the text into html, the source step looks like this: ...

Please upload the excel file with your queries. Thank you

To extract the row index from column 4 of the results list, you have to store it first there, when you search and populate the results list. Th...

Hi Ron, Checked your model, but looks like it does not have the codes you uploaded in the first post. It's hard to rebuild your entire logic, can y...

I think you want to know how to use the document selected to populate another form, not how to create a form, you seem to know how to create one. B...

This workaround has the disadvantage of only working while a single user is playing the game due to not having a different signal file name for each p...