VBA

[system]

Hi All,

How can we read data from XL sheet and pass these multi values to report prompt using VBA in DeskI.
if you any code please do post it.

Thanks in advance.
Ak

---

akraju (BOB member since 2006-04-18)

[system]

you can create an odbc connexion to your excel sheet then make a select on it using SQL inside VBA but it should be better to use dedicated real database (sql server, sybase, oracle). Have a look on the SDK subforum where you can find a lot of usefull sample codes.

nota : maybe you can rename your message title because “VBA” is not very clear to enlight your need/trouble

---

bernard timbal (BOB member since 2003-05-26)

[system]

@akraju

How can we read data from XL sheet and pass these multi values to report prompt using VBA in DeskI.
if you any code please do post it.

Take a look at the discussion and utilityhere.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)