In Progress

VBA opening external application

i need an excel file with VBA macro working as follows:

It must have a clock updating in real time

A1: it has a live stock price updating in real time (that i will provide)

everytime the clock gets to a point i can chose (i.e. every 10mins or every round minute), the content of cell A1 is copied down in column A

columns B and columns C will perform a calculation i will enter manually

then, suppose B5 and C5 are the top point of column B and C:

if B6>C6 and now B5<C5 then

open enternal application and performs a set of actions,

otherwise do nothing

the extermal application is internet explorer or can be a stock trading program.

requirements:

1. the code must allow me to modify the condition "if B6>C6 and now B5<C5 then" etc...

2. ideally it is easy to modify the part of code that wakes up the external application, because suppose the website changes, i must be able to adapt the code for the program to put the right number in the right box.

thanks

Compétences : Excel

en voir plus : vba open application, vba open external application, vba call external program, vba opening application, excel vba open external program, vba open external program, vba run external program, vba start external program, start external program vba, opening external application vba, opening application vba, open application vba, internet explorer excel open external, vba excel external program, excel external program vba, vba run external application, call external program vba, vba call external application, call application vba, call program vba

Concernant l'employeur :
( 1 commentaire ) london, United Kingdom

Nº du projet : #327656

Décerné à:

crajeshbe

Excel VBA and Forex programmer. Ready to start the project. Regards [login to view URL] B.E

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(0 Commentaires)
0.0

13 freelance font une offre moyenne de $118 pour ce travail

schandraram

Hello Please see PMB for details of my bid. - Thank you - Chandra Ram

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(40 Commentaires)
5.9
ioanaprof

Dear Sir, Can be done without problems, in all the details. If you are interested in my offer please contact me by PMB. Thanks Ioan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)
3.5
guruplus

Hi Pls refer my PMB Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(1 Évaluation)
1.9
VLADNOVA

Will be done with Pleasure. VBA Expert :-)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
1.0
flieingzbu

I think I can do it for $100, depending on what you are looking for by changing the function.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
knvandana

Hello I am interested in working on your project. I have 4+years of experience as a Senior Programmer . I involved in the design and development of software by using Visual basic, VB.NET,ASP,SQL server 2000, MS Access, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
radus28

Hi! You are looking a vb macro module in Excel that do some task response with time and able to call external application. External application and formulas should be able to changed. Ok! my Bid may be seems little hig Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
xs2ilyas

I have read and understood your requirements and are extremely confident of providing you with the optimum solution as described. 100% quality of work and satisfaction is guaranteed. I am sure that you would have r Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
johnyarora

hi...I m a vba developer and have worked on such projects..... price is no issue.. we can talk over it.. I just want to show my abilities.. Hope to hear from u soon..

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
1.4
chery81

I have done similar project in current working company and I promise that the spread sheet I am going to develop for you will be user friendly and as you desired, you can make simple modifications on your own without a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
sumiwati

Sir, Please Let me know TQ :)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
iesd2005

I have more than 6 yrs experience having worked for multinational corporations. I can show you samples of my previous work if you want.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0