tag:blogger.com,1999:blog-7958828565254404797.post7963200172854687067..comments2024-03-29T00:02:14.892-07:00Comments on ListenData: Excel Macro : Convert Multiple Excel Files to PDFDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-7958828565254404797.post-9900551788842601812023-06-15T22:52:49.601-07:002023-06-15T22:52:49.601-07:00Fixed. Check again.Fixed. Check again.Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-358067529267507022023-06-15T21:27:05.723-07:002023-06-15T21:27:05.723-07:00The file is gone. Can you reupload please?The file is gone. Can you reupload please?armyjamhttps://www.blogger.com/profile/12388517048328888689noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-63291536715104751082023-01-17T20:51:14.508-08:002023-01-17T20:51:14.508-08:00amazing, solved !!!! thanks amazing, solved !!!! thanks Ari Amintashttps://www.blogger.com/profile/04268477059828531917noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-17995629604610479202022-11-01T10:17:42.283-07:002022-11-01T10:17:42.283-07:00Very useful these macros.
I need to use version 7...Very useful these macros. <br />I need to use version 7 but my excel files names contain the dot "." and the pdfs created don't have the same name as excel file as I need, eg. <br />excel file name 0103-FK-01.40-4+0-0039_523FK <br />pdf file name look like this 0103-FK-01<br />How can I solve this? <br />Thank youbratu ionelhttps://www.blogger.com/profile/13752389313019192394noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-80342905637546397312021-08-02T04:54:01.332-07:002021-08-02T04:54:01.332-07:00No. 2 worksheet is exactly what I was looking for....No. 2 worksheet is exactly what I was looking for. Thank you soo much.....<br />Ahttps://www.blogger.com/profile/00851432358167879662noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-26188896676267596702020-04-06T06:07:42.349-07:002020-04-06T06:07:42.349-07:00Thanks. It helped me a lotThanks. It helped me a lotmkMuslim85https://www.blogger.com/profile/15711593803691711389noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-25621097950574257752018-10-10T09:37:45.488-07:002018-10-10T09:37:45.488-07:00You can check this by the arranging, format, conte...You can check this by the arranging, format, content and pictures in the changed over document. <a href="https://www.altocompresspdf.com/" rel="nofollow">altocompresspdf.com</a><br />Jennethttps://www.blogger.com/profile/07639742669691521251noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-6180639989026933112018-06-15T03:42:57.307-07:002018-06-15T03:42:57.307-07:00LOL. I can expect this kind of response from '...LOL. I can expect this kind of response from 'anonymous' user only. The intend of this article is to share knowledge with others, not spreading malware/spyware. Always use anti-virus. Don't trust anyone!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-23280151291374876062018-06-14T02:53:34.651-07:002018-06-14T02:53:34.651-07:00How can anyone make sure that any (or your) downlo...How can anyone make sure that any (or your) downloadable macro doesn't contain any malware/spyware? It sure is great to learn from others while using VBA and Macros, but safety first right?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-50206780635620297332017-06-03T00:41:27.968-07:002017-06-03T00:41:27.968-07:00PDF Extractor is software that can extract text an...PDF Extractor is software that can extract text and images from a PDF File. The software is easy to use and can be operated by anyone. There are a few basic steps involved in the conversion process and all that one has to do is to follow those steps. <a href="http://adobecs.aedsoftware.info" rel="nofollow">Adobe After Effects CS5.5</a><br /><br />Steve Rhttps://www.blogger.com/profile/07645548559235454595noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-2418644488279563452017-05-11T08:03:42.693-07:002017-05-11T08:03:42.693-07:00How did you do this? How did you do this? jimbrighttps://www.blogger.com/profile/03729385887314490692noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-44634088239622864522017-05-11T08:00:07.967-07:002017-05-11T08:00:07.967-07:00Hi I need to do the procedure for converting range...Hi I need to do the procedure for converting range of sheets in a workbook for a list of many workbooks with different sheet ranges specified within those workbooks. (not all files within a directory) I am having a lot of trouble trying to alter your VBA code to get this done. I currently have a list of the files and a list of the sheet names associated with those files but can't figure out how to loop the code across each workbook and each sheet range. <br /><br />Thanksjimbrighttps://www.blogger.com/profile/03729385887314490692noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-30310193374307232002017-01-11T15:56:15.786-08:002017-01-11T15:56:15.786-08:00nevermind I figured it out hahanevermind I figured it out hahaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-76499859823084920182017-01-11T13:49:02.659-08:002017-01-11T13:49:02.659-08:00I have about 1200 excel files that need to be conv...I have about 1200 excel files that need to be converted to pdf. All of my files are in separate folders in one parent folder. can you give me some pointers on how I might edit your code to search within subfolders? thank youAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-42518481741659143742017-01-09T07:43:17.019-08:002017-01-09T07:43:17.019-08:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/08162655512881626109noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-84581987786352665932016-09-22T09:27:59.475-07:002016-09-22T09:27:59.475-07:00It's absolutely okay. I appreciated you asked ...It's absolutely okay. I appreciated you asked me for permission!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-7026985381482956092016-09-21T23:35:16.845-07:002016-09-21T23:35:16.845-07:00Great work man. Thanks very much.
I copied the co...Great work man. Thanks very much.<br /><br />I copied the code in different work book is that ok? (I will not say I wrote the code myself and will say took it from the internet)Anonymoushttps://www.blogger.com/profile/00072386699125285798noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-52725049294755534972016-07-12T07:26:16.242-07:002016-07-12T07:26:16.242-07:00Super Boss, Can you just send the code to save the...Super Boss, Can you just send the code to save them in multiple pdf's instead under sheet names instead single pdfAnonymoushttps://www.blogger.com/profile/09759348461805175644noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-38471612029560754392016-04-02T23:47:42.310-07:002016-04-02T23:47:42.310-07:00actually you only have to press Shift after clicki...actually you only have to press Shift after clicking the first sheet to the last sheet then select pdf or xps tab to convert all sheetsAnonymoushttps://www.blogger.com/profile/01319447517224398368noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-28619311013472078072015-05-14T01:41:54.516-07:002015-05-14T01:41:54.516-07:00HI thanks for the helpHI thanks for the helpSachin Bagulnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-62034214160511948092014-02-27T11:01:44.402-08:002014-02-27T11:01:44.402-08:00Thanks for stopping by. I'm glad you found it ...Thanks for stopping by. I'm glad you found it helpful!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-85662137000856135442014-02-27T10:15:00.411-08:002014-02-27T10:15:00.411-08:00Thanks, very useful and helpful! Previously painfu...Thanks, very useful and helpful! Previously painful task was done in 5.63 seconds :)Frankhttps://www.blogger.com/profile/12015667656944572932noreply@blogger.com