Posted to microsoft.public.excel.programming

external usenet poster

Posts: 586

Automation Error with BuiltinDocumentProperties

I am getting an error: Automation Error. Can the BuiltinDocumentProperties
only be used with ThisWorkbook? I can't get it to work with the workbook
wbkDataSource.

If wbkDataSource.BuiltinDocumentProperties("Last Save Time") + TimeSerial(0,
10, 0) < Date Then
'do something
End If

Any ideas?

--
Cheers,
Ryan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation?	[email protected]	Excel Discussion (Misc queries)	0	June 24th 08 01:29 AM
Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error	[email protected]	Excel Programming	3	May 28th 08 04:51 AM
BuiltInDocumentProperties...some no workee	CLR	Excel Programming	4	September 29th 06 04:32 PM
BuiltInDocumentProperties	CLR	Excel Programming	7	May 25th 06 09:20 PM
BuiltinDocumentProperties	Joop[_2_]	Excel Programming	2	August 17th 03 11:28 AM

All times are GMT +1. The time now is 08:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us