Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: ungrouping the Textboxes in excell sheets.

by Nkuvu (Priest)
on Mar 19, 2009 at 16:08 UTC ( #751773=note: print w/ replies, xml ) Need Help??


in reply to ungrouping the Textboxes in excell sheets.

More context, please. Is $ws a worksheet? If so, I'm wondering how this works -- I don't see a TextBoxes object in the Worksheet or Worksheets object (in the Object Browser).

If you can get a handle to a Range object, though, there is an Unmerge function available to break up grouped cells. You can see this yourself by looking at the Object Browser -- press Alt-F11 in Excel to bring up the VB editor, then F2 to get the Object Browser. Then I usually restrict the search to Excel only (change where it says "all libraries" to "Excel").

Edit to add: Note that it's very possible that the TextBoxes item is just not part of the version of Excel I have available to me at work (Excel 2000).


Comment on Re: ungrouping the Textboxes in excell sheets.
Download Code
Replies are listed 'Best First'.
Re^2: ungrouping the Textboxes in excell sheets.
by scratchHead (Initiate) on Mar 20, 2009 at 04:25 UTC
    hello Nkuvu, yeah $ws is the worksheet im refering,,, this works,. I just did what u adviced, but even i coudn't see the TextBoxes as u said(excel 2003 in using) (sorry i dont know much abt VB too). anyways thanks for the reply you have given,as im new to the idea given by i ll explore a lot on it.

      You might be able to just use the Ungroup function I referred to. For example, get the address of the cell you want, and do $ws->Range("A1")->Ungroup();

      Note that the range is a normal Perl string, so you can easily iterate over a number of cells:

      # Pardon the C-ish loop, it's late. for (my $row = 1; $row <= 10; $row++) { $ws->Range("A$row")->Ungroup(); } # or an alternate if you have an area: # (cell addresses off the top of my head) $ws->Range("A1:D46")->Ungroup();

      Note that I haven't had to use this function myself, so I'm not 100% positive it's the function you need. But you should be able to do some quick tests -- and look at the help for the function to see what can unmerge cells.

        hey Nkuvu, that worked, (actually the first 1 syntax error,u need to give in range..). thats a great help from from you bro, thanks a lot....
        hey Nkuvu, that worked, (actually the first 1 syntax error,u need to give in range..). thats a great help from from you bro, thanks a lot....

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://751773]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2015-07-30 03:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls