Create button to Save specific page ranges from each worksheet in the workbook

Sorry, I din't know that wee have to link back even from other sites! And thanx for intimating me.
I have added the link back in my description.

Originally Posted by HaHoBe

Hi, projectatpel,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).


http://www.mrexcel.com/forum/excel-q...-workbook.html

Ciao,
Holger

I have worked out a code, to add to a command button, but it seems to have some syntax error. If anyone can help

Please Login or Register  to view this content.

Dear xladept,

Yes, they are merged cells, and I have tried designating only the first cell, but that doesn't seem to work either!
If you could actually try it out, to check the error, it would be great.

These are the errors that I am getting

When the button is clicked , to run it:
Run time Error.jpg

While debugging, this is the error showing up!
Run time Error 2.jpg

Originally Posted by xladept

Hi projectatpel,

I believe your problem to be in the multiple range designation because multiple ranges have multiple values (normally) - are they merged ranges? If so, then you need only designate the first cell??

Doesn't work yet! the same run time error still shows up!

Originally Posted by xladept

Hi projectatpel,

Try:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This was the original code i found online. I edited the format to match as PDF and it did work when i tried on a sample excel sheet

But when i do the same on my project, it gives errors!

This is the latest code I've tried, but there seems to be some problem with the syntax in referring to file name. Thus the resulting file name is erroneous.

Please Login or Register  to view this content.

Aah finally, after hours of tweaking and sleepless nights, here it occurs. Its so simple, that I feel embarrassed of not cracking it earlier

Please Login or Register  to view this content.

Report and Graphs are sheet names

The final file in PDF format is save in folder D:\Test
Consider the value in cell D5 of sheet Report be 1234423, then
File is named as "Calculation ID= 1234423 on [Current Date] at [Current Time] AM/PM.pdf"