PDF-printer problem

[Crüe]

Hello, I have a problem like this;

I've recorded macro that selects PDF-printer, converts wanted range into PDF, then opens email application and user can send range to wanted address. Problem is that every time I record macro, it works fine, just like i want it to work.. but when I close workbook, then open it again and run macro, it does not do anything I recorded :P It does select pdf-printer (sometimes) but it wants me to save file (didn't record anything like that), and sometimes it just prints range into paper :P

Is this macro ruined somehow or doesn't it just work ??

Point is that user selects "Send PDF", macro then selects PDF-printer, then opens email application where user can write address. All this is working but when I close workbook and then open it, won't work :P

Here's the code

Please Login or Register  to view this content.

[Mordred]

Hello Crüe, I've removed the lines of code that are only imitations of what you were doing, like scrolling your sheet and selecting A26 after your printout and this is what is left

Please Login or Register  to view this content.

Your code does not select a pdf printer, it uses whatever printer is default. Also, your code does not open an email. It just selects a Range called RANGE and then prints it to the default printer.
Another note worth mentioning is your name usage for a range. Range is a reserved word in VBA and it is not typically good practice to use the same names as reserved names. Perhaps something like Rng1 would be better as it is countable and not reserved.
We can help you with a procedure that will do what you want but I personally won't be back on for another 6 or 7 hours as it is 1:14 am where I am and I need to get some sleep .

[gjlindn]

I think you need to always specify the active printer.

Please Login or Register  to view this content.

EDIT: I also agree with Mordred...I would refrain from using RANGE as a named range.

[Crüe]

I recorded a new one, is this any better ? Yeah I would greatly approciate if I get this done. OK I'll take another shot changing line

Please Login or Register  to view this content.

[gjlindn]

In order to have it send email, too, we'd need to know what the email application you're using is (my guess is MS Outlook). Also, is the intent to send the same information via workbook attachment, data pasted into the body of the email (if so what format), or attached PDF file that the user saves. And like Mordred, it's 1:30am here so I'll be offline until tomorrow and busy with work until 6pm. I'm sure there are members here who can get you on track before then, though. Thanks!

[royUK]

You've not paid any attention to the help given previously. The new coe still has the scrolling code which is unnecessary.

Also, if you change printers you need to change them back again.

Please Login or Register  to view this content.

For full pdf code & emailing options see Ron de Bruin's site

[Crüe]

I'm using Windows Live Mail. What I want is to send this "myRANGE (etc.)" via email as an email attachment. Macro I posted before works like this, after it has converted wanted range to PDF, it opens this Teamware mailing application with this range as an attachment. Then I just need to select right email address and send it.

I'm trying to pay attention, my english is just little bit rusty so I need to do this very simple and easy.

[gjlindn]

@royUK: Excellent point on switching things back (printer in this case)...users absolutely HATE their settings changed

[Crüe]

It would be so easy to copy Ron's code which creates pdf-files and then emails them. But I got an error 'cuz I'm not using Outlook :P

Set OutApp = CreateObject("Outlook.Application")

[royUK]

You could look at Ron's code for sending with CDO

[Crüe]

Could you paste where I can find that?

[royUK]

It's on his site

http://www.rondebruin.nl/cdo.htm

Also,Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
I've moved it

[Crüe]

It's not working, I'm done with this :P I'm losing my nerves...

[royUK]

We can't help if you don't say what's not working.

[Crüe]

Never mind, this goes beyond my vba-abilities :P I found a code from Ron's site, it simply just emails wanted range, but there's only one problem, it doesn't send no pictures. Thing is that User A has range where he writes some data, and pictures. He then emails this range with all data and pics to User B, and User B opens this sheet, so that he can read and see all the data and pics User A has send.... at this point, User B can only see text but no pics 'cuz code won't include them. Could you help with this?

code

Please Login or Register  to view this content.