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
