attach

Images are below. Three tabs: 1) Report, 2) Store Vol, 3) Community Days. J53 on Report is where the return value will be. Currently, in that cell is a combination of a VLookup and an HLookup. The Vlookup is pointing to A53 where a 1 is located to indicate Store #1 . It then finds Store #1 in...

Hi Guys, I've spent a couple of hours trying to solve my issue with Pivottables and formulas, but am now thinking VBA may be better included. I've got a large dataset, and the columns that included that I care about are: -The date -The user number -The test result (Pass,Fail,Blank) I want to...

Hi all Is there an alternative to using multiple SUMIFS which include date ranges in the criteria? I have an example in Excel but can't see how to attach, can someone please point me in the right direction? Thanks, Craig

Here is what im trying to accomplish. I have a spreadsheet: <tbody> A B C 1 NAME TO: CC: 2 Marky Mark marky@mail.com other1@mail.com 3 John Johnson john@mail.com other2@mail.com 4 Lucky Leaf lucky@mail.com other3@mail.com </tbody> Example Steps: 1. Run Macro 2. Prompt to select...

I’m not sure it’s possible, but wanted to check, and my friend google didn’t know… I inserted hyperlinks in an Excel doc so that if the user has a query with completing the doc they can click on my name and it will email me, and when they are ready to submit the doc there is a secondary...

So here's my problem, I need to send out a file that requires iterative calc's to be enabled in order to work properly, however its going to a large number of people that may or may not have the knowledge base to adjust the settings. Is there a way to "pin" my iteration settings to the file so...

Hello Experts! I have some code I have cobbled together where I am trying to email a unique Excel file to individuals on a distribution list based on a value in an Excel column. Everything is working well except searching for the Excel file with part of the name and attaching the Excel file to...

Hi guys, I hope some of you can help with my problem: I've got a spreadsheet (using Excel 2010) of client information, name, email address, policy reference number and so on. A couple of other programs will be producing pdfs, the filenames will contain the policy reference number in the...

Gents, I'm using the below famous code to attach the currently open excel file by email. Everything works fine, but I want the macro to rename the excel file before attaching it to be "original file name_range(A1)". I did alot of search, but I need the code not to offer Save As dialog, and I...

Elsewhere in this board, I found a reference to http://www.rondebruin.nl/sendmail.htm which taught me to attach an Excel workbook to an email. And using the code below, it worked perfectly... except - Outlook creates a box before it sends asking the user to "allow" or deny permission to send...

Using Excel 2007, I am trying to use VBA to allow a user to insert (embed/attach) a file of their choosing to a spreadsheet. (It's a button-activated macro). The xlDialogInsertObject method works fine by itself, but I would like the dialog box to appear with the "From File" tab already selected...

I am having trouble with the email script in excel, if the active workbook isn't saved then it will not attach the file, many times I don't want to save the file as it is just a meaningless report (to me) that someone wants and if I need it in the future then I can retrieve it via my sent items...

Hi all, I have a named range in my file which I wish to add to the body of my email, at the same time I want to attach that range as a pdf file (under one code to automate the process). I have used online tutorials and have managed to add the range to the body of the email and have also...

I have a workbook and every time I open it a custom toolbar appears at the top when it is not supposed to. This toolbar was attached to another workbook but that workbook and toolbar are no longer used. This workbook was working fine until the other day. It seams that it has somehow attached...