solution

As mentioned ion Export all VBA code to text file, here's my attempt at a program which will export the VBA code modules from Excel workbooks, Access databases and Word documents. Please read the comments at the head of the code. Please feel free to report any bugs here in this thread. Code...

Hi I have asked number of experts on youtube but none of them replied I assumed they have no answer. When I apply filter to any column the Column that contains checkbox overlaps. Checkbox are in C Any solution to this issue ABCDEFGHIJ12To Do ListStatusCell Linked3Define your project...

In this photo the left is a predefined structure where all level 4's rollup to their above level 3's, and so on to level one. For example every sunflower is a flower and every flower is a plant... not a tree. Well on the right is a rollup/mapping table where we go as detailed as possible with...

Hi guys, I need print a lot of same documents from my working folder. And those excel files has only 2 pages and I need only second page from those documents. How I can do that with VBA ? Thank you !!! Files plece in C:\Users\User\Desktop\WQT CER

Hello everyone, I'd appreciate some coding help in Excel using VBA. I'm very new to this. Background: There is a new .txt file made for each machine run, which contains details about the part and the weight gain. The .txt file is created automatically in the system, and goes unedited by...

Hi all, I use a spreadsheet as a tracking doc to keep track of our process from project upload through client approval. The way the doc is set up is Column A (Name) has the name of task. Column B (OMIT) is where we log if a task has been omitted. Column D (Code) host the code I need help...

I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total. I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...

Hello, I'm using Microsoft Office 16 in windows 10 / 64bit I'm looking for a solution to have a popup date picker in my userform I'v been searching for a solution long time ago, found a lot of solutions but most of them for 32bit, and some for 64bit but none of them worked correctly Please I...

I have this age old problem in many excel files When I open excel file, numbers gets change to date. This does not happens everyday but happens sometimes on some day, in some sheets in some rows. But whenever it happens it spoils by half day. I tried lots of solution, like changing cells...

Hi Guys, Basically I have a fairly large spreadsheet which contains ID's and then values in the adjacent column with dates in the following column. For each ID I want to take the value corresponding to the latest date, bearing in mind each ID could have a different number of values and...

Hi mrexcel forum, Could you please suggest a formula to help me with this issue? Issue A: I will like to extract out the numbers immediately before and after the dot. This is the volume information. Issue B: I will like to extract the 3 characters immediately after the Volume information...

Hi, I'm looking for some help with drop down lists....or any other suggesstions are welcome! So in a table, a cell will be populated with a number value and i need the input of another cell to be restricted based on that value. The restriction will be above or below 10,000. I was thinking...

I am trying to run the code below. When I run this, I am getting the following error message: OpenSolver Could not find an optimal solution, and reported: Infeasible The Model contains a restraint 'I2:I160 >=1' for which instance 4does not depend on the decision variable and is not satisfied...

I am performing an if formula that has 2 AND criteria, fo which one is a contains wildcard. I read that countifs may be the solution but I am still off the mark Can anyone help please? Many thanks

I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...

B2 gets updated by values due RTD B3 I have kept a flag which becomes 1 for a certain time period (ONLY ONCE DURING A DAY) Solution required: B4=HIGHEST VALUE of B2 when B3=1 else 0 B5= LOWEST VALUE of B2 when B3=1 else 0 How to accomplish? Thanks in adv

Extremely large data set that will include the following information. Is there a simple method (formula) to provide the following summation (for a large data set,A1:A200, etc.)? <colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="64"...

I hope someone can help with this problem I am failing to find a solution for. I wish to count the number of times a specific text value appears in a range. The text itself will often be part of a string which will contain other information. Below is an example of the issue I am...

I have a number of linked workbooks that I need to share with one, or possibly two, other team members. We work in different locations. I have trialled sharing these workbooks with one colleague via OneDrive, which wasn’t without some problems but I wonder if there is a better/smarter solution...

Hi members I have a trouble when I add references from file path using vbProj.References.AddFromFile "C:\Windows\SysWOW64\ieframe.dll" and vbProj.References.AddFromFile "C:\Windows\SysWOW64\mshtml.tlb" I receive a message "No se puede entrar en tiempo de interrupción en este momento" Also...