Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.scripting.vbscript > #11266

Re: The object invoked has disconnected from its clients. 80010108 null

Path csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From GS <gs@v.invalid>
Newsgroups microsoft.public.scripting.vbscript
Subject Re: The object invoked has disconnected from its clients. 80010108 null
Date Wed, 23 Mar 2016 12:54:44 -0400
Organization A noiseless patient Spider
Lines 20
Message-ID <ncuhis$j2c$1@dont-email.me> (permalink)
References <e077ccea-cb83-43d7-9de4-39ad543bab6b@googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding 8bit
Injection-Date Wed, 23 Mar 2016 16:51:41 -0000 (UTC)
Injection-Info mx02.eternal-september.org; posting-host="385a93d8bbdd6c7b95ff6e6963d18654"; logging-data="19532"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+AUy4N2ltyeg0PE6FCrsu9"
X-Newsreader MesNews/1.08.06.00-gb
X-Face G"ln~:.wBqHZznO'(lJjjprxGYAjIF7#^u)lx,@"H'F#uXm%j`T6kxat5rq092aW;K*#<!y <6K)wt3HjA)V"XV`W3}Qts*D['Jm:qqpgttEl^wk@9{HJglN-Q'.91Af~ySM>m4jZ(2aW$34N&B&E@ j~tjGV-aC18j1y>zi.\[ZGXsd
Cancel-Lock sha1:6W40fNbmnfXkR8PHFxSC1jWl2q0=
X-ICQ 543516788
Xref csiph.com microsoft.public.scripting.vbscript:11266

Show key headers only | View raw


FWIW
You could simplify this entire process by orders of magnitude if you 
just use 1 Excel file with separate sheets for your data/reports. This 
file can also contain your macro. You could use ADODB to pull data from 
Access.

This approach will eliminate any need to open/delete any other Excel 
files, and your links to other data will be internal refs to other 
sheets within the same workbook. Also, your presentation would be all 
contained in a single file.

Also, ADODB does not require any files be opened to access/update data.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.scripting.vbscript | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

The object invoked has disconnected from its clients. 80010108 null ceejmo@gmail.com - 2016-03-22 15:05 -0700
  Re: The object invoked has disconnected from its clients. 80010108 null "R.Wieser" <address@not.available> - 2016-03-23 09:26 +0100
    Re: The object invoked has disconnected from its clients. 80010108 null "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2016-03-23 10:16 +0100
  Re: The object invoked has disconnected from its clients. 80010108 null GS <gs@v.invalid> - 2016-03-23 12:54 -0400
  Re: The object invoked has disconnected from its clients. 80010108 null ceejmo@gmail.com - 2016-04-05 07:56 -0700

csiph-web