XProfan

English

Stephan
Sonneborn

Hello zusammmen,

there a Possibility, on the VBA-code in a Excel-scheduler access and this macro to start?

background:
an relatively unformatierte Excelliste should in a Formatted Excel-list überführt go (Stückliste of/ one techn. drawing). the stature the Zielliste requires it, that apiece Stücklisten-row altogether 4 Excel-Lines eingefügt go. the Done in the Normalbetrieb one macro, the To foot called and is simply four Lines copies, The then with new Values überschreiben go.

I have now to, with XPROFAN both Excel-tables to open and Zellenweise The values the Quelltabelle into Zieltabelle To copy:

-scheduler 1 open
-scheduler 2 open
-row 1 from scheduler 2 Zellenweise in scheduler 1 copy
-In scheduler 1 a new Stücklistenzeile (=4 Excel-Lines by macro insert)
-next Line scheduler 2 Zellenweise in scheduler 1 copy.

has someone ne idea?

Schöne Grüße aus Wittgenstein
von Stephan

Programmierumgebung:| XProfan X4 | WIN10 | AMD FX6100 3,3 GHz

09/23/10 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

myself have there no idea, imho one but with installed Excel on The tables by Datenbankbefehle grab can - someone having here soetwas already Schonmal successful umgesetzt.

i'd to hardship look How I The data export get as csv or sql and then process and zurückkonvertieren.

09/23/10 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Thomas
Freier

helps since the "ocxPackage2-demonstration: Excel 1, Excel2" moreover?

Gruß Thomas
Windows XP SP2, XProfan X2

09/25/10 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Sub-Topic: SQL-ask [...]

created.

09/26/10 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Stephan
Sonneborn

Hello Thomas,

unfortunately not, because with the OCX somehow not works. there come by me always Fehlermeldungen. (see my question at Thread "Exceldaten over ocx kopieren" )

Schöne Grüße aus Wittgenstein
von Stephan

Programmierumgebung:| XProfan X4 | WIN10 | AMD FX6100 3,3 GHz

10/01/10 ▲

Vollständiges Quote

Absatzweise Quote Zeilenweise Quote

Christof
Neuß

Hello Stephan,
have Du's in the meantime hinbekommen?
I make the so...

Compile Mark Separation

cell$="B2:M4"
Range1&=ocxGet(Sheet1&,"Range",cell$)
Range2&=ocxGet(Sheet2&,"Range","AE1")
ocxMethod(Sheet1&,"Activate")
ocxMethod(brat1&,"Copy")
ocxMethod(Sheet2&,"Activate")
ocxMethod(brat2&,"PasteSpecial",)