Passing a parameter to Excel
 

Tom,

your question is a bit unprecise..

what do you want to achieve?

passing it from where to where?
from vba to excel or from a userform to excel or
from another application (via vba) to excel?

or do you mean ole or DDE?



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Walker" wrote:

Hi,

How do I pass a parameter to excel? a string?

Thanks,
Tom

Passing a parameter to Excel
 

Hi,

Thanks for the reply.

I would be opening an excel spreadsheet from a
powerbuilder application.

Something like this:

excel myexcelsheet.xls thisistheparam

where thisistheparam is my parameter. How would I access
the string "thisistheparam" in workbook_open event?

Thanks,
Tom


-----Original Message-----
Tom,

your question is a bit unprecise..

what do you want to achieve?

passing it from where to where?
from vba to excel or from a userform to excel or
from another application (via vba) to excel?

or do you mean ole or DDE?



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Walker" wrote:

Hi,

How do I pass a parameter to excel? a string?

Thanks,
Tom


.

Passing a parameter to Excel
 

Is there any other way I can do this? I thought this
would be simple one to handle after handling some pivot
table programming, doesnt look like so :-)

Tom


-----Original Message-----

don't think it can be done that way, the only thing that
came to mind is
application.caller.. tested that but it gives an error.
checked help,
cant be used.


But:....

Either you'll have to pass them via ole AFTER Excel has
started.

see www.sybase.com/home
search for powerbuilder OLE

#44559: OLE Automation for Clients and Servers
#44643: Using OLE with Powerbuilder and MS Office 97
(Word 8)

Or write them to a small textfile in a known location...
and read that file in Workbook_open

Or copy them on the clipboard and have workbook_open
paste it somewhere...

just improvising here... sorry :)




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Walker" wrote:

Hi,

Thanks for the reply.

I would be opening an excel spreadsheet from a
powerbuilder application.

Something like this:

excel myexcelsheet.xls thisistheparam

where thisistheparam is my parameter. How would I
access
the string "thisistheparam" in workbook_open event?

Thanks,
Tom


-----Original Message-----
Tom,

your question is a bit unprecise..

what do you want to achieve?

passing it from where to where?
from vba to excel or from a userform to excel or
from another application (via vba) to excel?

or do you mean ole or DDE?



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Walker" wrote:

Hi,

How do I pass a parameter to excel? a string?

Thanks,
Tom


.



.

Passing a parameter to Excel
 

Sorry Tom,

depends on what/why you need to pass a parameter?

you can either have excel read from the database via odbc.. (staying
within excel vba)

or maybe check if you can set a reference in excel to an object library
from sybase?

or maybe you can control it from powerbuilder (make a reference to excel
object library in sybase?.. and run most code there.

Sorry for ruining this thread with my useless comments..

You'd better start a fresh thread tomorrow... time it carefully though..
if you post it too early the gurus will miss it, as there will be ten or
hundred more recent posts. If late like now.. they're all gone :(

Also be specific in your header and your question.

Powerbuilder.. starting excel and passing variables. How?

then in the post explain exactly what your trying to do.





keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Tom Walker" wrote:

Is there any other way I can do this? I thought this
would be simple one to handle after handling some pivot
table programming, doesnt look like so :-)

Tom


-----Original Message-----