Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
about OLE automation
I have an excel spreadsheet thats linked to an access
table. I am using this table to create a form. I am using the code below to open an access this form (from excel) where there's a code for form_open event to print report of the form. after i close everything excel keeps running in the background. so the next time i open the same excel file i see two VBA project (of the same file) open. am i missing here something? i hope i am making myself clear. thanks for any help. ' Initialize string to database path. Const strConPathToSamples = "C:\Documents and Settings\vku\My Documents\" strDB = strConPathToSamples & "Stock Cards.mdb" ' Create new instance of Microsoft Access. Set appAccess = CreateObject("Access.Application") ' Open database in Microsoft Access window. appAccess.OpenCurrentDatabase strDB appAccess.visible = True appAccess.WindowState = ppWindowMaximized ' Open Orders form. appAccess.DoCmd.OpenForm "Stock Cards" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation | Excel Worksheet Functions | |||
Automation?? | Excel Discussion (Misc queries) | |||
Automation | Excel Programming | |||
Automation | Excel Programming | |||
OLE Automation | Excel Programming |