Recent content by bvanscoy678

Hello, I created a simple measure (PowerPivot) to determine if a unit met a time goal of 200 seconds. =if(apparatus[Min Incident Time] <200,TRUE,FALSE) What I want to do next it to create another measure to figure out the percentages of true and false in the column. I attempted the below...

Hello, I'm setting up my data model for a power pivot project and it looks like my look up tables are being used as the main table. The Incident Table is my main table. The incident Key is my primary key between the EMS Scene, Apparatus and EMS advance, but the arrows and relationships seem to...

Since I only work on a few projects like these and they are small, I post all my completed projects into Microsoft OneNote with comments and some thread postings to help me reuse the code in other projects. Thank you for the comments and help. It is greatly appreciated. Brent

Thank you and I will keep that in mind. I am still very new using VBA, so every project is a big step for me! Thanks, Brent

My apologizes for the miss post. I thought, since I eliminated the need for the email, I should start a new thread. I did go back to look at the code, but I found I was able to email from a previous project after I created all of the workbooks with your code. As you can see, I did reference the...

Hi, I am very close to finishing this whole project, but I need one last tweek. I recieved help last week for the below code. The only trouble is I want to keep the values and formatting of the original worksheet. I tried: owb.Worksheets(1).Range("A1").PasteSpecial 12 But that must be...

I will take a look at this tomorrow. I have outlook on my home machine. I'll run a few test and see how it goes. Thanks for the patience and time. Talk to you on Monday. Thanks, Brent

Another round at it. I tried a different approach, but it did not work. I ran your code to create the workbooks, then I adapted code I used to email every workbook in a folder, but I struck out on 2 things. First of all I got an error message on this line: .Attachments.Add...

Hi, I have played with this a bit off and on all day, but can't work Ron's code into it. I ran a test and it works perfect to create the workbook (I changed to the C:drive/folder), but each time I changed a few things in Ron's code, I don't have my variables correct. I'll keep at it. Thanks...

Good morning, I fixed all the merge cells in my worksheet. This is the code I have used recently to email a bunch of workbooks. '''''Ron de Bruin Excel Automation Sub CDO_Mail_Small_Text_2(wb As Workbook) Dim iMsg As Object Dim iConf As Object Dim strbody As String Dim...

Yeah, I went a bit crazy with name ranges. Truth is I started the project and ended up adding and adding until it got a bit our of control. I knew how to do it with formulas, but not VBA. I get the main sheet cleaned up first thing in the morning. I am trying to finish up my main project for my...

Yeah, I merged cells when I shouldn't have. I created it last year and since then I did a few other smaller projects and found out what pain the rear merge cells are. I can change all the merged cell into center across selection if that will help? thanks

Hi, I have a few ideas about this, but looking for a push in the right direction. My workbook (redacted) contains a list of 10 people (hundreds in working copy) that I want to send their fitness results to. My main data worksheet is worksheet (1) and it list all of their results. Worksheet...

The code worked perfectly! Thank you for the link. Brent

Perfect. I will take a look. Thanks!