Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    15
    ReputationRep:
    I want to know if this is possible, please let me know what major obstacles I would face. So here's the scenario....

    Using Excel 2010, pretend I have two coloums: 'Icecreams' and 'totalorder'. And the icecreams column has 100 different flavours using there own unique code e.g. VNLA12 or MNT9345. And the total orders is just number of icecreams sold, e.g 1000 or 300

    Now pretend I have a PDF document that has the icecream codes and each of these codes also has with loads of information like calories, competitor price and the totalorder next to it. However sometimes the same icecream code such as MNT9345 is recorded twice, so there's two totalorders. These need to be added together when placing them in Excel for the final totalorder..

    So my question is, is it quite easy to create a macro that would let excel automatically retrienve the totalorders from PDF whilst adding them up and putting them with the right icecream.

    I really hope I made sense lol
    Offline

    0
    ReputationRep:
    Highly confusing!

    Yeah, it's possible. Yes, it's hard.

    You need to crack on and post on specialist forums when you come across a problem.


    Posted from TSR Mobile
    • Study Helper
    Offline

    16
    ReputationRep:
    (Original post by Luxray)
    I want to know if this is possible, please let me know what major obstacles I would face. So here's the scenario....

    Using Excel 2010, pretend I have two coloums: 'Icecreams' and 'totalorder'. And the icecreams column has 100 different flavours using there own unique code e.g. VNLA12 or MNT9345. And the total orders is just number of icecreams sold, e.g 1000 or 300

    Now pretend I have a PDF document that has the icecream codes and each of these codes also has with loads of information like calories, competitor price and the totalorder next to it. However sometimes the same icecream code such as MNT9345 is recorded twice, so there's two totalorders. These need to be added together when placing them in Excel for the final totalorder..

    So my question is, is it quite easy to create a macro that would let excel automatically retrienve the totalorders from PDF whilst adding them up and putting them with the right icecream.

    I really hope I made sense lol
    In principle, Excel can read and summarize data from a variety of file formats. However, I'm not sure that it can read and interpret data from a PDF file directly!

    Will Excel even let you open the PDF file through its File menu?

    Is there any way you can get the data supplied in an alternative format - CSV file, text file, HTML/XML, database format, or even as a spreadsheet?
    • Thread Starter
    Offline

    15
    ReputationRep:
    (Original post by davros)
    In principle, Excel can read and summarize data from a variety of file formats. However, I'm not sure that it can read and interpret data from a PDF file directly!

    Will Excel even let you open the PDF file through its File menu?

    Is there any way you can get the data supplied in an alternative format - CSV file, text file, HTML/XML, database format, or even as a spreadsheet?
    I don't know man,I work at a financial services company and realised that one of the task which takes a while could be reduced if we were able to run a macro using the information, I'll check next time to see if we can open the PDF on excel. I doubt it.

    I've ran (not created) a macro on their computers which takes account numbers from an excel document, then somehow inputs those account numbers on a financial services programme. This programme then generates account balances. Then those balances are placed onto the excel document. So somehow excel was able to interact with the financial services programme. This all happens within like 60 seconds whereas manually it would have took probably 40 minutes.

    So I thought maybe excel could run a macro that interacted with a PDF and would be able to find the relevant information from the PDF and would then paste that information into its excel sheet.
    Offline

    15
    ReputationRep:
    I'd suggest writing or finding some kind of batch file or similar capable of turning the PDF into some kind of format that Excel can deal with (unless Excel can deal with PDFs, I moved over to OpenOffice years ago), then automatically executes a macro that does what you want with the data in that format.
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    What newspaper do you read/prefer?
    Useful resources
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.