Re: [prog] Copier 2 cellules de differents onglets dans un nouveau tableau - Laurent Godard - org.openoffice.fr.prog

3 messages in org.openoffice.fr.progRe: [prog] Copier 2 cellules de diffe...

From	Sent On	Attachments
endive	Dec 18, 2006 7:41 am
Francois Gatto	Dec 18, 2006 6:29 pm
Laurent Godard	Dec 18, 2006 11:07 pm

	Permalink for this message Paste this link in email or IM:
	Permalink for this thread Paste this link in email or IM:
	Atom feed for this thread Paste this URL into your reader:

Subject:	Re: [prog] Copier 2 cellules de differents onglets dans un nouveau tableau	Actions...
From:	Laurent Godard (lgod...@indesko.com)
Date:	Dec 18, 2006 11:07:57 pm
List:	org.openoffice.fr.prog

bonjour

Voici une idée :

Sub CopyTab2Tab oSheet = ThisComponent.getSheets() oSheetCible = oSheet.getByIndex(0) nSheets = ThisComponent.getSheets().Count ' lecture des onglets à partir de 3 (feuille4 et suivantes) ' on admet que les feuilles sont dans l'ordre requis For i = 3 to nSheets - 1 oSheetSource = oSheet.getByIndex(i) oSheetCible.getCellRangeByName("A"&i-2).String = oSheetSource.getCellRangeByName("C12").String oSheetCible.getCellRangeByName("B"&i-2).String = oSheetSource.getCellRangeByName("I37").String Next End Sub

regarder du coté de copyRange

Laurent

	Start a set with this search
	Include this search in one of my sets
	Exclude this search from one of my sets
	Permalink to these results Paste this link in email or IM:
	Atom feed for tracking future search results Paste this URL into your reader: