Reply To: copy data from Flexpro to Excel via VBA ?

[MAZOYER Thomas]

Hello,

i would like to copy a data from Flexpro to a specific cell on Excel 2007. How can I do ?

I try this code:

ActiveDatabase.TaskWindows(fpTaskWindowObjectList).Activate
ActiveDatabase.Selection.SelectObject “Data”
ActiveDatabase.Selection.Copy

but there is nothing in the clipbord and I have the error :
“Run-time error 1004”.

I create an object Excel and open it:

Set oAppExcel = CreateObject(“Excel.Application”)
sFichier = InputBox(“Sélectionner le fichier Excel à renseigner”, File, “H:\macro\toto.xlsx”)
oAppExcel.Workbooks.Open (sFichier)

but it doesn’t work.

could someone help me ?

Thanks,
ToM