Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm trying to launch .doc from within .xls using FollowHyperlink method (as i need it to go via dde and simple open method doesn't work). The .xls contains invoicing data wile the .doc is MailMerge (to create the invoice) based on that same .xls (i'm launching the .doc from) via dde. As a result it stalls (says that can't access) because: - the dde connection in the .doc MM is trying to connect to the .xls that stores the invoicing data - since i'm launching the .doc from the same .xls where the invoicing data are stored - the code 'locks' the .xls (since the code is still kind of running as it waits till the .doc opens) but the .doc can't open since it can't reach the locked .xls file - a vicious cycle... Any ideas how to have the .xls 'unlock' for the time while the .doc MM is opening? Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening a Word Doc | Excel Programming | |||
Opening Word in Excel | Excel Programming | |||
Opening csv in Word | Excel Programming | |||
Excel-Opening Word | Excel Programming | |||
Opening a Word doc and more | Excel Programming |