Search results

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!

Hi, I received this code from a previous question and it worked perfect for another project. I started a new project today and it only pulls the first value, exits the loop and then I get an error when it tries to save over the same file. It only copies one row, then exits the loop. I have...

Okay. I think I'll switch to Outlook to make it easier on myself. Thank you for the help. I'll make another run at it. Thanks

Hi, I combined my macro into one sub routine, so I could utilize MyFile (not sure if that was good) I add: wb.save (not sure I put it in the right place) .Attachments.Add ActiveWorkbook.FullName Still no luck. Would this be better using outlook? Thanks Sub Test()...

Is Fullname a variable? I'll check it out. Thanks

Hi, I'm running a macro that opens each workbook in a folder, collects the email from a cell, attaches the workbook and emails with a gmail account. I have stepped through the code and it looks like all my variables are correct, but I get an error on adding the attachment. I've looked through...

yes, that works perfect. thank you!

Hello, I am using this formula to count the number of unique values in a masterlist. Since I am also counting the heading, it returns the next number I can use as a document unique ID# when I create a new document. (There are two visible worksheet in attached workbook. The below formula is in...

I commented out my protection for now, so I could work on the form control. I attempted the below, but get an error message with me.control (I also tried activesheet.control) Sub CreateMail() Dim rngSubject As Range Dim rngTo As Range Dim rngBody As Range Dim objOutlook As Object Dim objMail...

No, I did not try hiding the controls, not sure how to do that. I merged a few pieces of code I found and "send keys" was just part of the merge. I really don't know what it means. Still pretty new to code, so learning as I go. I updated part of the code to try and protect and unprotect my...

Hi, I have a very simple piece of code that copy/paste a range into a body of an email. It works just fine with the exception of the form control. I have a combo box that overlays E3 and it populates the value in E3. I don't want to see both the value in E3 and the combo box as it is showing...