Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

run excel and foxpro marco

2 views
Skip to first unread message

ims

unread,
May 18, 2002, 7:34:58 AM5/18/02
to
Dear all,

My question may be off the newsgroup topic, but I don't know which newsgroup
is most appropriate for it.
I want my PC can do the followings for me at midnight.

1. open an excel spreadsheet at 3 am
2. run a macro
3. save the spreadsheet in dbf format
4. open the dbf file with foxfro
5. run a foxpro program
6. end

I know how to write a simple marco for excel spreadsheet,
but have no idea about how to tell the PC to do the above procedures by
itself.

Any idea?
thanks!

Jason


Orlando Magalhães Filho

unread,
May 19, 2002, 12:59:51 AM5/19/02
to
Hi ims,

To launch Excel with your macro at 3 am, if you're using WIN98, WINme or
WINxp, try to use Windows Task Scheduler. Go Start Menu > Programs >
Accessories > Tools System > Task Scheduler

HTH

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)

"ims" <kft...@myrealbox.com> escreveu na mensagem
news:uxdSMAm$BHA.1660@tkmsftngp02...

ims

unread,
May 19, 2002, 2:15:56 AM5/19/02
to
HTH

i have successfully started running my excel worksheet automatically, but
don't know how it can run the excel marco during start up, any idea?

ims


"Orlando Magalh綣s Filho" <orla...@hotmail.com> 撰寫於郵件新聞
:#d7TaIv$BHA.864@tkmsftngp04...

jaf

unread,
May 19, 2002, 8:47:37 AM5/19/02
to
Auto_Open()


John

"ims" <kft...@myrealbox.com> wrote in message
news:#iBDjyv$BHA.1176@tkmsftngp02...

ims

unread,
May 19, 2002, 11:00:20 AM5/19/02
to
Auto_Open() ??
How and Where shoud I put this auto open command?

Thanks
ims


"jaf" <joh...@kohotmail.com> 撰寫於郵件新聞:OdeFZNz$BHA.1696@tkmsftngp04...

Orlando Magalhães Filho

unread,
May 19, 2002, 10:48:58 PM5/19/02
to
Hi ims,

If your macro has a name Auto_Open, Excel start up running it, but you can
use open event too. Do this:

- Open your workbook
- Press Alt+F11
- Click on ThisWorkbook object
- Insert the below code, save and reopen your workbook.

Private Sub Workbook_Open()
MsgBox "Hello! You can call your macro here."
End Sub

HTH

(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)


"ims" <kft...@myrealbox.com> escreveu na mensagem

news:#iBDjyv$BHA.1176@tkmsftngp02...

ims

unread,
May 20, 2002, 12:02:58 AM5/20/02
to
Dear HTH
I can't catch what the second method you mentioned cus I'm a green in Excel,
however rename the marco name to Auto_open already done my job, thanks for
your valuable information!

ims


"Orlando Magalh綣s Filho" <orla...@hotmail.com> 撰寫於郵件新聞

:uQ$J9j6$BHA.2200@tkmsftngp02...

Orlando Magalhães Filho

unread,
May 20, 2002, 11:49:28 PM5/20/02
to
Glad it worked, but the second method is cool and newer. If you can do it,
you will learn about events, important new Excel feature.

"ims" <kft...@myrealbox.com> escreveu na mensagem

news:uCvY2M7$BHA.2344@tkmsftngp02...

0 new messages