Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is my problem:
I have two lines of statement in my VBA code as follows: __________________________________________ line1: Shell("net use \\fs1\ipc$") line2: Set db = OpenDatabase("\\fs1\test\abc.mdb", False, True, "MS Access;PWD=12345") Other lines follow here.... _________________________________________ When I execute the VBA code, sometimes I get a handle to the database and sometimes I dont (I get a runtime error 3051 because there is a delay in getting the handle to the database due to slow network). When I debug this line by line, I dont get any error message. I want to make Excel complete executing LINE1 (however long it takes on a slow network) and then execute LINE2 . How do I make Excel do this? I have been researching on this for the last 3 days. If anyone here can help me on this, this would be of great help to me! Thanks in Advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need formula to return data from one column after comparing 2 othe | Excel Worksheet Functions | |||
Not enough memory to run Microsoft Office Excel. Please close othe | Excel Discussion (Misc queries) | |||
Not enough memory to run Microsoft Office Excel. Please close othe | Excel Discussion (Misc queries) | |||
how do you shade every othe row in excel 2007 | Excel Discussion (Misc queries) | |||
put on a eliptical fit for x-y points without a, b, e or the othe. | Excel Programming |