I do a ridiculous amount of running queries in Access, copying and pasting data into specific cell ranges in new date-named worksheets in the same workbooks every week. To add to the issues, I pull data into my Access database using ODBC-connected tables that require me to login to the server with the same login info using the Linked Table Manager everytime I load my Access. The copying and pasting to specific cell ranges in specific worksheets in one workbook. I need to automate as much of this as possible. I already know Java and know that Java could simplify a lot of the repetitive tasks, using a good API. However, I want to avoid having to go through downloading the files, programs, etc. necessary to run Java apps on my work computer, as I want other co-workers to be able to utilize the same program that I come up with on their computers without a lot of hassle. I don't know VB and am still unclear if this is something I should learn that will work similar to Java.
2007-10-12
04:04:41
·
6 answers
·
asked by
Kay Dee
1