Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Scheduler for Excel Files

Hi All,

I want your help for the following problem:

I have developed spreadsheets which extracts prices from bloomberg. Now, there is basic problem to that. Each time I need to go to Bloomberg terminal and run those excel files to get data. I want to create a folder in Bloomberg machine which is in LAN and I want to drop my excel files in that folder. My [b]scheduler program [/b] should check that folder in every 3 mins and then run (or just open those excel files, which will run automatically then) those excel files. And when the data extracting is over it should keep the updated files into a separate folder. This thing should continue 24/7.

Can this be done?? can any1 help me in this???

Comments

  • crapmindcrapmind Member Posts: 2
    Is there any one to help me out
  • BitByBit_ThorBitByBit_Thor Member Posts: 2,444
    : Hi All,
    :
    : I want your help for the following problem:
    :
    : I have developed spreadsheets which extracts prices from bloomberg.
    : Now, there is basic problem to that. Each time I need to go to
    : Bloomberg terminal and run those excel files to get data. I want to
    : create a folder in Bloomberg machine which is in LAN and I want to
    : drop my excel files in that folder. My [b]scheduler program [/b]
    : should check that folder in every 3 mins and then run (or just open
    : those excel files, which will run automatically then) those excel
    : files. And when the data extracting is over it should keep the
    : updated files into a separate folder. This thing should continue
    : 24/7.
    :
    : Can this be done?? can any1 help me in this???
    :

    If the machine is running Windows (which is has to for VB), then make sure your program starts up at the appropriate time(s), and add a timer control to a hidden form, set it's interval to something appropriate and every time it goes off, check if 3 mins have passed and if so, check for new files in the directory.


    Best Regards,
    Richard

    The way I see it... Well, it's all pretty blurry
Sign In or Register to comment.