ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   automation macro (https://www.excelbanter.com/excel-programming/281459-automation-macro.html)

Nigel[_5_]

automation macro
 
Personally not used our fully investigated but have a look at this method
for the application object

Application.RecordMacro


"J.S" wrote in message
...
Hello,

I'm new in excel programming and I need some help,

I'm using office 2K

I open an excel file and I've my excel object now I want to record in a
macro all the user action in a program without using menu
Tools-macro-Record
I want to did it automaticly


Thanks for help






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

J.S

automation macro
 
Hello,

I'm new in excel programming and I need some help,

I'm using office 2K

I open an excel file and I've my excel object now I want to record in a
macro all the user action in a program without using menu
Tools-macro-Record
I want to did it automaticly


Thanks for help



J.S

automation macro
 
Thanks for your help,

I try your solution but I need some help for using the method
Application.RecordMacro I didn't understand in the msdn help and I try like
that:

1. string s;
MyApplicationObject.RecordMacro(s,null);
I don't receive an error but nothing is returned in s.

2 . How can I stop the recording???

Thanks.



"Nigel" wrote in message
...
Personally not used our fully investigated but have a look at this method
for the application object

Application.RecordMacro


"J.S" wrote in message
...
Hello,

I'm new in excel programming and I need some help,

I'm using office 2K

I open an excel file and I've my excel object now I want to record in a
macro all the user action in a program without using menu
Tools-macro-Record
I want to did it automaticly


Thanks for help






----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet

News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000

Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption

=---




All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com