WiredWX Hobby Weather ToolsLog in

 


descriptionA very simple app... I hope. EmptyA very simple app... I hope.

more_horiz
First of all let's just start by saying I am not a programmer. I'm fairly good with T-SQL and know a little VFP. I understand basic concepts of programming logic, what I have done I enjoy and would like to do more of. I would like to write what I think would be a very simple program. I have an excel spreadsheet that has two columns, a date column and a system code column. One of the applications that I use on a regular basis requires a system code, it changes each day. I want to write an app, batch file, etc., anything that upon launching will get the system code for the day(either by manually passing the value through some sort of GUI, or based off of the date on the computer) and return it to me in a text file that I can copy and paste.

Any recommendations on a language that would make this task very easy?

descriptionA very simple app... I hope. EmptyRe: A very simple app... I hope.

more_horiz
Also, I have sql express 2008 loaded on my laptop, so I could copy the excel spreadsheet to a db table and setup an odbc.

descriptionA very simple app... I hope. EmptyRe: A very simple app... I hope.

more_horiz
I think VBA would suit you best.

descriptionA very simple app... I hope. EmptyRe: A very simple app... I hope.

more_horiz
Is VBA used for coding within an excel workbook? Can an exe be created that can be launched from the desktop and open a text file?

descriptionA very simple app... I hope. EmptyRe: A very simple app... I hope.

more_horiz
You can do something like this

Code:

select SYSTEM_CODE, DATE_FIELD
where DATE_FIELD >= convert(datetime, '2008-12-1 12:00', 120)
and DATE_FIELD < convert(datetime, '2008-12-2 12:00', 120)


You can run this SQL select, it's a matter of what you are familiar with to get it to a text file, you can do it with DTS/SSIS, C#, or whichever else you may prefer.


VBA cann be used to control one application from another using OLE Automation. For example, it is used to automatically create a Word report from Excel data, in turn automatically collected by Excel from polled observation sensors.

VBA is functionally rich and extremely flexible but it does have some important limitations, including limited support for function pointers which are used as callback functions in the Windows API. It has the ability to use (but not create) (ActiveX/COM) DLLs, and later versions add support for class modules.


You can read more about VBA here:

http://en.wikipedia.org/wiki/Visual_Basic_for_Applications

descriptionA very simple app... I hope. EmptyRe: A very simple app... I hope.

more_horiz
privacy_tip Permissions in this forum:
You cannot reply to topics in this forum