Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use C++ to populate worksheet from a Database
Hi
I would like to populate a worksheet from our College student database. I don't want to get involved with, or even know, the network paths, table names or passwords required to access the database. Would it be possible (easy?) to do this transfer with an .exe (say in C++, VB6...) which I can call in VBA with a string parameter - that being a range name on the active sheet? The range name would refer to the top row or top left hand corner of the location to "paste". Alternatively, the .exe might produce a Variant array that I could access, or write to the active worksheet. Has anyone got such a piece of code?? regards Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I POPULATE AN EXCEL TEMPLATE USING DATABASE | Excel Worksheet Functions | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
Macro to importing a text file to populate a database/table | New Users to Excel | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Populate Drop-Down from Database Using VBA | Excel Programming |