If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel and "reflection for unix and digital"
Helloooo,
sorry for my poor english : is it possible to start a macro in XL or "reflection for Unix and windows" , copy a cell from excel et paste into a screen in reflection : i would like to copy a range of cells from xl, (A1:A50) and paste into reflection but if the paste is possible, "manually" , i write a code to paste with visual basic, make 22 "tab" in the screen and after that, the problem is : how to return in xl and continue A2, A3 etc... the swith is possible by the ALT TAB "manually" but how in automatic please ? My first step is to open xl from Reflection but after that ... ps: Reflection have an visual basic editor too ! Thanks to you Patrick |
#2
|
|||
|
|||
excel and "reflection for unix and digital"
...Patrick wrote:
My first step is to open xl from Reflection but after that ... ps: Reflection have an visual basic editor too ! I don't know anything about Reflection, but I would try using automation. Create a Reference from your Reflection's VBproject to Microsoft Excel N Object Library. Dim oXL As Excel.Application Dim V Dim I As Integer Set oXL = New Excel.Application oXL.Workbooks.Open "C:\Mybook.xls" For I=1 To 50 V = oXL.Sheets("Sheet1").Cells(I, 1).Value ' do what you will with that value V in Reflection Next oXL.ActiveWorkbook.Close False oXL.Quit Set oXL = Nothing If you can deal with the data being in an array you could replace the For loop with V = oXL.Sheets("Sheet1").Range("A1:A50").Value Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|