View Single Post
 
Old 09-18-2012, 03:50 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,225
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

The code works fine in my testing. The Excel workbook will only be created if something has been found. As mentioned in the other thread, the searches are case-sensitive.
Quote:
You said that it's easier if I already have an Excel doc open.
I think you have misunderstood what I said. If the workbook is supposed to exist already, a lot more coding is required, including code to test whether the workbook is already opened.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote