CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX 		Search Posts SEARCH
POSTS 		Who's Online WHO'S
ONLINE 		Log in LOG
IN

Home: Perl Programming Help: Win32 Programming Help:
Win32::OLE macro code in sheet

 


mpij
New User

Aug 2, 2012, 4:32 AM

Post #1 of 3 (37363 views)
Win32::OLE macro code in sheet Can't Post
Hi,

I've problem with enter macro code into sheet1 in excel

Is there a way to add the macro to Sheet1 (because my exception
sub-routine works only from sheet1 and not from module).

Could u help me ?



mp


mpij
New User

Aug 3, 2012, 2:42 AM

Post #2 of 3 (37335 views)
Re: [mpij] Win32::OLE macro code in sheet [In reply to] Can't Post
The problem is here :



my $mod = $book->VBProject->VBComponents->Add(1)->CodeModule;

What should i write instead od CodeModule ?


mpij
New User

Aug 4, 2012, 2:54 AM

Post #3 of 3 (37293 views)
Re: [mpij] Win32::OLE macro code in sheet [In reply to] Can't Post
Problem has solved.

for someone who has the same:

my $mod = $book->VBProject->VBComponents->Item(Sheet1)->CodeModule;



Michal

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives