Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 12-07-2014, 06:05 AM   #1
Beta Member
 
Join Date: Nov 2014
Location: United Kingdom
Posts: 2
Default Application that can pass values to two separate stand-alone applications

Hi,

I am using Windows 7, and I want an application that I may write in the future, to be able to pass values into various fields of a particular bespoke application that I am running, and also at the same time, to write those same values into various fields of an Excel spreadsheet.

How would this be done? I have read about 'data scraping' and also about the Windows API. Would either of these be appropriate for this task?

Any recommendations appreciated.

Jeremy Watts
__________________

jezza10181 is offline   Reply With Quote
Old 12-11-2014, 03:06 PM   #2
Fully Optimized
 
Draygoes's Avatar
 
Join Date: Nov 2014
Location: United States
Posts: 1,653
Default Re: Application that can pass values to two separate stand-alone applications

Nice to meet you.
I would like to suggest that you learn the basics before you take on such a task. I would recommend that you start with VB, although there are plenty of places to start...
__________________

__________________
Will have a youtube channel up soon. Link will be here if I remember.
Draygoes is offline   Reply With Quote
Old 12-12-2014, 08:43 AM   #3
Beta Member
 
Join Date: Nov 2014
Location: United Kingdom
Posts: 2
Default Re: Application that can pass values to two separate stand-alone applications

Thanks for the reply,

yes, I am at the moment doing a course on VB. I've heard of VBA (?) too, that allows macros to be written that can pass values to Excel etc.

Would you recommend using VB then for this sort of idea?

Thanks
jezza10181 is offline   Reply With Quote
Old 12-13-2014, 03:14 PM   #4
Fully Optimized
 
Draygoes's Avatar
 
Join Date: Nov 2014
Location: United States
Posts: 1,653
Default Re: Application that can pass values to two separate stand-alone applications

I would highly recommend VBA actually, and this website can help: Excel VBA Tutorial - Easy Excel Macros

That site deals directly with your issue. VBA stands for Visual Basic for Applications, and it works pretty well. Because you are taking classes for VB, you should be able to latch onto VBA pretty quickly.

I hope that this helps.
__________________
Will have a youtube channel up soon. Link will be here if I remember.
Draygoes is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 04:42 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0