Closed Thread
Results 1 to 12 of 12

Modification required in VBA PDF to excel conversion-

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Modification required in VBA PDF to excel conversion-

    The attached excel file converts PDF file to excel. But i need some modification with it, At address A2 path of PDF file is entered and at B2 type is selected like .xlsx. When convert button is pressed it converts PDF to excel at same location.
    Now what i want with this code to be modified is that:
    1) It should ask from user to select PDF file(by using application.open method) and by default it should convert to xlsx format.
    2) Sheet should be named as "Farmer History" to which data is copied
    3) Headings to be ignored during copy

    Due to some error, i am unable to post VBA CODE here, Kindly check the attached Convert PDF Files Into Different Format.xlsm excel file

    I have asked this question here too:https://www.mrexcel.com/board/thread...rsion.1130694/
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 04-15-2020 at 02:47 AM. Reason: Title corrected. Keep title to the essentials

  2. #2
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    1,441

    Re: Modification required in VBA PDF to excel conversion-

    Maybe use Commercial Services this time

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: Modification required in VBA PDF to excel conversion-

    Ah this was related to previous post...this was another way of achieving the result..but code from this and other was combined to resolve the issue...and it,s now closed...Thank you..I should mark this as solved now...

  4. #4
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: Modification required in VBA PDF to excel conversion-

    @torachan, can you please explain how commercial Services works?? what does 30 month $20 means? Maybe some day i will use..

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,087

    Re: Modification required in VBA PDF to excel conversion-

    Yep - that bit of advice seems to have fallen on deaf ears!

    Zahid - what you are asking is NOT just a quick tweak of the code - it's an entire new set of functionality and, I suspect, will require a substantial amount of time to resolve, especially as you have a tendency to keep shifting the goalposts. You need to seriously consider whether it is really fair to ask someone to do all of this for you completely for free.

    Don't be surprised if you don't get any offers of help this time.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  6. #6
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: Modification required in VBA PDF to excel conversion-

    what,s wrong with you, why you getting personal? why you are so harsh? people are helping, i am not forcing, i think your intentions are not good..!!! please be polite, you are forum moderator i think and look at yorr post , simply childish..or forcing someone to leave...why are you doing this? trust me your every word hurts..
    Last edited by AliGW; 04-16-2020 at 04:38 AM. Reason: Please don't quote unnecessarily!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,087

    Re: Modification required in VBA PDF to excel conversion-

    There is nothing wrong with me, Zahid, nor am I being impolite. My intentions are entirely good and considerate. Yes, people are helping you, but that's not my point. There is nothing harsh in what I said: I am merely asking you to consider whether what you are asking of people here is excessive.

    The idea of a help forum is that you work with your helpers towards a solution together: in your threads, you don't seem to do anything except keep asking for tweaks and changes to your requirements. That's not a collaboration: it's a brief.

    To be very cleear, nobody is suggesting that you should leave. Only you have mentioned this - it's in your imagination only.
    Last edited by AliGW; 04-16-2020 at 04:40 AM.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,087

    Re: Modification required in VBA PDF to excel conversion-

    Ah this was related to previous post...this was another way of achieving the result
    OK - then I am glad you have marked it as solved.

  9. #9
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: Modification required in VBA PDF to excel conversion-

    Look at your words in post number 5, they are very harsh and trust me you raised by blood pressure with it..that without reason you are commenting like this..If you have some suggestions you can suggest in a proper and polite way...i think you are breaking rules of the forum by hurting people...you must think before you speak...
    AND this is not my imagination, but you told me that don,t be surprise next time if i dont get help...i wasnt expecting these words from you, trust me...Beside helping you are just criticizing which you shouldn't. Please don,t do this, don,t hurt people feelings. Here everyone is helping by their own, if someone is supporting and helping, what,s the problem with you? why you are making fuss without any reason...i think we are wasting time by commenting and clarifications like this, beside if we have knowledge, we should help others... thank you
    Last edited by AliGW; 04-16-2020 at 04:48 AM. Reason: Please don't quote unnecessarily!

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,087

    Re: Modification required in VBA PDF to excel conversion-

    You have completely misinterpreted what I said. Nothing was harsh. If you don't understand the point I am making, then there's not a lot I can do.

  11. #11
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    195

    Re: Modification required in VBA PDF to excel conversion-


  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,087

    Re: Modification required in VBA PDF to excel conversion-

    Enough now, Zahid. All I am doing is trying to advise you - if you wish to ignore that advice, then that's fine. I am closing this thread, as it is not required.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy to blank row modification required
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2017, 11:49 AM
  2. [SOLVED] Julian Date Conversion and Formula Modification
    By fearonc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2014, 02:33 PM
  3. ***Excel to Outlook mail body—Modification Required***
    By prabhubox@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2014, 12:30 AM
  4. Modification required in attaching excel sheet in to an email
    By prabhubox@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-05-2013, 02:22 AM
  5. EXCEL: Required macro for data collation and conversion
    By gaikwad.mm@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2013, 08:04 AM
  6. [SOLVED] Modification required in vba code.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-01-2013, 07:12 AM
  7. [SOLVED] Macro modification required (very small)
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2012, 01:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1