{"id":2981,"date":"2021-11-01T23:42:52","date_gmt":"2021-11-01T23:42:52","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=2981"},"modified":"2021-11-01T23:43:23","modified_gmt":"2021-11-01T23:43:23","slug":"solved-macro-button-code-saveas-pdf-w-file-name-from-cell","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/macro-button-code-saveas-pdf-w-file-name-from-cell\/18339.html","title":{"rendered":"Solved Macro Button Code, SaveAs PDF w\/ File Name From Cell"},"content":{"rendered":"<p>To whom this may concern,<\/p>\n<p>I have a work sheet that is an office form, I would like to have a button on the form that that can do 3 tasks at one time:<\/p>\n<p>1. Save Sheet as a PDF<br \/>\n2. Save the PDF with the file name from cell&#8217;s &#8220;O30&#8221; &amp; &#8220;O31&#8221; &amp; &#8220;A1&#8221; with a space of dash between the three names<br \/>\n3. Save the PDF in a folder on the desktop.<\/p>\n<p>Thanks you for you help and support in advance.<br \/>\n-E925<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":4},"question-category":[53],"question_tags":[],"class_list":["post-2981","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/2981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=2981"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=2981"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=2981"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=2981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}