.BAT (or similar)

Author
Discussion

mondeoman

Original Poster:

11,430 posts

268 months

Thursday 23rd October 2003
quotequote all
Is there any way I can set up a .bat file (or other software) that would automatically open an application (Word, CrystalReports, Excel), open a file, update it, then print it.

I've got a bunch of different reports in each of these apps, and its a real pain doing this manually every week ....

Cheers

PetrolTed

34,441 posts

305 months

Thursday 23rd October 2003
quotequote all
Depends what you mean by 'update' it

Plotloss

67,280 posts

272 months

Thursday 23rd October 2003
quotequote all
Depends on the application.

If its one of the office applications I believe you can script just about everything inside the tool using vbScript.

mondeoman

Original Poster:

11,430 posts

268 months

Thursday 23rd October 2003
quotequote all
vbScript ... never used it.

As for updating it, take an Excel s/sheet as an example, it has links to other workbooks that may have new data in and for the report to be up-to-date, this new data has to be incorporated (usually asks if you want to update when the s/sheet is opened). CrystalReports has an "update data" button.

PetrolTed

34,441 posts

305 months

Thursday 23rd October 2003
quotequote all
Not simple then...

dontlift

9,396 posts

260 months

Thursday 23rd October 2003
quotequote all
Dave,

If you want some script writing to do this give me a shout, i assume it is business and we could probably sort it fairly cheaply for you

robertuk

591 posts

264 months

Thursday 23rd October 2003
quotequote all
Hi guys,

I'm sure this is easy to do.

Years ago I had a coverdisk program which would record/perform a set of actions when you press a hotkey.

I will search and see what comes up.

Basically as long as you perform the same set of task

File >import >filename.???
File >save >
Exit

it should be ok.

There must be an easy way !

robertuk

591 posts

264 months

Thursday 23rd October 2003
quotequote all
OK I have no experience with this company or product but I found a UK company via google

www.mjtnet.com/contact.htm

The product is called macro scheduler
and I think a trial download is available.

Looks pretty good.

Ramesh

mondeoman

Original Poster:

11,430 posts

268 months

Tuesday 28th October 2003
quotequote all
robertuk said:
OK I have no experience with this company or product but I found a UK company via google

www.mjtnet.com/contact.htm

The product is called macro scheduler
and I think a trial download is available.

Looks pretty good.

Ramesh


Trialling that now - seems to do most of what I wnat, as long as I dont move any of the file locations around, or change any icons on the desktop

Cheers all!