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 (33835 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 (33807 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 (33765 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