I need a macro which will save the selected area in 1 page by asking if vertical or horizantal.
(It would be great if it also asks where to save and if it saves it with the name of the page with the time.
Thanks in advance..
I need a macro which will save the selected area in 1 page by asking if vertical or horizantal.
(It would be great if it also asks where to save and if it saves it with the name of the page with the time.
Thanks in advance..
Can anyone help?
Hi, First change red line (Folder name) then try it...
Dont forget to select selected area before running macro...
Please Login or Register to view this content.
Last edited by HerryMarkowitz; 04-20-2015 at 11:11 AM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Hi HerryMarkowitz, thank you for your response.
There is a problem I faced up; I select the area but it detects half of it and save it as PDF in half.
On the other hand, I am writing C:\Users\Win8\Desktop\ but it can be different if I use it in different computer and I need to change the macro every time. Can it show the list and asks me to select where to save?
( Teşekkürler )
Last edited by akinkaraman; 04-20-2015 at 11:17 PM.
Change this line;
With this;Please Login or Register to view this content.
Please Login or Register to view this content.
I dont understand about that;
Hi akinkaraman
Here are 2 solutions for you. Print As PDF-1 will prompt you for a name to save the pdf file as, then prompt
again for the page orientation you want to use & save the activesheet selection on your desktop as a PDF.
Print As PDF-2 will prompt for the page orientation & open the save dialogue for you to choose your own destination
folder & filename, then save it as a PDF.
You can put buttons on any worksheet to call the macros
Please Login or Register to view this content.
Hello HerryMarkowitz, the first file I attached is with your codes which is half view, Second one is with Philb1's codes.
Mr. Philb1's code is not giving the file name with workbook name with date and time. I entered manually and it doesn't open the pdf automaicly after creating.
Mr. HerryMarkowitz's code is exactly like what I wanted after I modified the file name but it gives the view in half.
(Not: HerryMarkowitz selam dostum. Oluşturulan pdf sectiğim alanın yarısını gösteriyor. 1. dosyaya bir bakar mısın, sizin kodu kullandım. 2. dosya diğer arkadaşın kodlarıyla ama manuel adlandırdım. Görüşmek üzere.. Akın)
Try.............
Please Login or Register to view this content.
Last edited by HerryMarkowitz; 04-21-2015 at 09:31 AM.
Mükemmel
Is it solved or not?
Solved.. Thank you..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks