Change macro to send as excel file not pdf.

.
http://www.vbaexpress.com/forum/show...able-using-VBA

This solution filters the data page for the company data and creates a workbook based on that filter. It does not use the pivot.

Please Login or Register  to view this content.

Hi Maniacb, thanks for answering and apologies for delay in replying, been a bit under the weather.

My live sheet pulls the data from a much bigger data set, hence the pivot would the above edit to suit the rows and columns I need?

Andy180y, can you restate your question? For clarity sake, I am attaching the file with the code embedded and you'll see that the resultant workbook has the same information as the pivot. Give it a try

Thanks Maniacb, nearly there, I need to change the columns the macro is picking up data from, is that possible?

Thanks Maniacb, I would need to knock up an anonymous sheet.
Basically it would filter on the info (company name in column A with info from O,C,N,AC,BC) is that something that would work?

it would be a lot straight forward if the info you want shared is in consecutive columns(C,N,O,AC,BC). But yes, it's possible. the code would look like something this:

Please Login or Register  to view this content.

Thanks maniacb, I tried changing some of the columns but no matter what I do I get the original output
from your code above. Can you tell me what I am doing wrong?

I think I have made progress, I have linked a new sheet to the columns in my data sheet and now all the columns I need
are next to one another and in order A to F now.

can you share what changes you tried?

Please Login or Register  to view this content.

Here is the updated code section

Please Login or Register  to view this content.

Maniacb thanks so much. Is it possible that a differing version of Excel could be an issue as still not getting the right output?

It shouldn't. Here is the working file

Thanks Maniacb, all looked good on the working file above but when I run the macro I get this error. Attachment 707261
and it debugs to this line.

Please Login or Register  to view this content.

Updated that line to this

Please Login or Register  to view this content.

And added line to clear memory.

Please Login or Register  to view this content.

All working perfect. I've been trying to save this to somewhere other than my flash drive F:\
Is it possible to save the temp file to my documents on C:\?

All you need to do is to replace "F:\" with say "C:\Users\George\Desktop\docs\"

Thanks Maniacb, one last query I changed .display to .send thinking it would send the emails without displaying and having to click them
but it said something about not being defined. Any ideas on that one. Thanks again for help so far. :-)

Here is updated code to include a picture instead of an attachment.

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon (Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.