English
Forum

Access to Excel-File possible?

 

Christof
Neuß
Hi,
i want on a bestehende Excel-File grab. Individual boxes should read and ggfs. again with Values occupied go.

goes still sure too with XProfan, or?

to hardship over ActiveX?!

thanks and Greeting
 
Win10 16 GB RAM
04/25/08  
 



helps the  [...]  ?
 
04/25/08  
 




Christof
Neuß
unfortunately not.

The Excel-scheduler has no Tabellenstruktur and several tab what about me must defined raussuchen. boxes reading and again describe.
 
Win10 16 GB RAM
04/25/08  
 



Perhaps knows there Marc More.
 
04/25/08  
 




Christof
Neuß
would be me Real help on.

nevertheless thanks.
 
Win10 16 GB RAM
04/25/08  
 




Uwe
''Pascal''
Niemeier
Hello Christof!


goes still sure too with XProfan, or?
to hardship over ActiveX?!




[web]https://XProfan.com/thread.core?t=4363[/web]
SeeYou
Pascal
 
04/26/08  
 




Christof
Neuß
Hello Pascal,

super, so GEHTS sure. The Examples Excel1 and Excel2 functions by me correct. unfortunately have I it not yet geschafft, a available Excel-File to open. In Excel1.prf have I The row
CompileMarkSeparation
var NewBook&=ocxMethod(WorkBooks&,Add)
>

through
CompileMarkSeparation
supplant. functions but not. Irgendwas is correct with the/whom Parameters (Dateiname) not. The File there but in this directory. have already all sorts of things ausprobiert. know You what?

Thank you!
 
Win10 16 GB RAM
04/28/08  
 




Christof
Neuß
Hi Pascal,

I bins again.

be in XProfan not yet so bewandert. can it his, that here something missing?
CompileMarkSeparation
proc ocxPutParams-------------------------------ocxPutParams----------------------------

    declare Pos%,v$,v&,v%
    dim Param#,(Count%-1)*16--Parameter-Array
    clear Param#

    whileloop Count%,3,-1--bestücken in umgekehrter Reihenfolge!

        v$=$(&loop)
        v&=&(&loop)
        v%=~VT_I4

        if left$(v$,1)=*------Parameter ist String

            v%=~VT_BSTR
            v$[&loop]=MultiToWideEx(del$(v$,1,1))
            v&=addr(v$[&loop])

        elseif left$(v$,1)=#--Parameter ist Objekt

            v%=~VT_DISPATCH
            v&=val(del$(v$,1,1))

        endif

        word Param#,Pos%=v%--Typ
        Pos%=Pos%+8
        long Param#,Pos%=v&--Wert
        Pos%=Pos%+8

    endwhile

    endproc-------------------------------------------------------------------------------pan>-

supra go Count% and Param# addressed, The but not transfer or declariert go. As I said, I verstehs not yet so correctly..

Merci!
 
Win10 16 GB RAM
04/28/08  
 



Both in übergeordneter procedure/function or quite global?
 
04/28/08  
 




Christof
Neuß
SORRY!

Hello Pascal,

it functions!!!! I had only one * on the Anfag the Dateinamens forget.
BTW: Why must the there there?

Merci!
 
Win10 16 GB RAM
04/28/08  
 




Christof
Neuß
Hi iF,

jo, now Have ICHs too finally understands. declared variables are so here too for untergeordneten Procs visible.

thanks for Info!
 
Win10 16 GB RAM
04/28/08  
 




Christof
Neuß
Hello Pascal,

at Compile with XPSE I get always The Error Message, that with 2 Lines the Stringende missing. I have then in the OCX2.PH on following Lines one second appended. now GEHTS!
CompileMarkSeparation
can You so what begin?
 
Win10 16 GB RAM
04/28/08  
 




Answer


Topictitle, max. 100 characters.
 

Systemprofile:

no Systemprofil laid out. [anlegen]

XProfan:

 Posting  Font  Smilies  ▼ 

Please register circa a Posting To verfassen.
 

Topic-Options

1.935 Views

Untitledvor 0 min.
H.Brill11/15/23
Christof Neuß06/08/21
kustg05/14/19
Sebald Grandjean02/16/18
More...

Themeninformationen



Admins  |  AGB  |  Applications  |  Authors  |  Chat  |  Privacy Policy  |  Download  |  Entrance  |  Help  |  Merchantportal  |  Imprint  |  Mart  |  Interfaces  |  SDK  |  Services  |  Games  |  Search  |  Support

One proposition all XProfan, The there's!


My XProfan
Private Messages
Own Storage Forum
Topics-Remember-List
Own Posts
Own Topics
Clipboard
Log off
 Deutsch English Français Español Italia
Translations

Privacy Policy


we use Cookies only as Session-Cookies because of the technical necessity and with us there no Cookies of Drittanbietern.

If you here on our Website click or navigate, stimmst You ours registration of Information in our Cookies on XProfan.Net To.

further Information To our Cookies and moreover, How You The control above keep, find You in ours nachfolgenden Datenschutzerklärung.


all rightDatenschutzerklärung
i want none Cookie