By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,246 Members | 1,221 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,246 IT Pros & Developers. It's quick & easy.

how to run a excel macro on perl ???

P: 5
good day

I have a problem, actually a big problem, I need to a plain xls file give it format, by format is adding an image, adding headers, adding rows at top of the file like 15 rows free, and I need to add text for titles of the report and stuff like that, so I thought I can do it with a macro, but I created a macro and where to save the macro?

I was reading the help on excel it said something about saving the macro on C:\Documents and Settings\USER\Application Data\Microsoft\Excel\XLSTART

Can any one help me?
Thanks
Jan 14 '08 #1
Share this Question
Share on Google+
1 Reply


P: 36
Hello When you will create object of the excel that time only all the functions and macros of that excel wil be attacted to that objcts.

just call that macro with that object.
of obj is object then
obj-> macroname();

or copy that object and convert it as a function and put it into one separate module. then directly you can call that function.

shafi

good day

I have a problem, actually a big problem, I need to a plain xls file give it format, by format is adding an image, adding headers, adding rows at top of the file like 15 rows free, and I need to add text for titles of the report and stuff like that, so I thought I can do it with a macro, but I created a macro and where to save the macro?

I was reading the help on excel it said something about saving the macro on C:\Documents and Settings\USER\Application Data\Microsoft\Excel\XLSTART

Can any one help me?
Thanks
Jan 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.