[AccessD] Syntax for seeing named range in excel

Hi John

I think it is only the update/append feature the patent covers. 
Though I'm not sure ... I've managed not to install the latest servicepacks and have no intention to do so.

But did you check this class module out:

Can't write to an Excel spreadsheet
http://databaseadvisors.com/mailman/htdig/accessd/2006-January/040857.html 

I haven't tested it as I have no current Excel projects.

/gustav

>>> jwcolby at ColbyConsulting.com 21-01-2006 13:48:20 >>>
I guess my confusion now is how does this whole process work in practice.  

I thought that the "patent" issue was one of "linking to spreadsheets was
illegal", but manipulating them programmatically was OK.  Thus I could not
create a link, it just wouldn't even let me do it, but I could write a
program to open a spreadsheet and do whatever I wanted to it in code.  If
that is true then I can open / update / close / open / update / close a
spreadsheet all I wanted to IN CODE.  If that is NOT true then the first
time I close it I am screwed and have to start all over.

What is the truth here?

John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Saturday, January 21, 2006 7:04 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Syntax for seeing named range in excel

Hi John

>>> jwcolby at ColbyConsulting.com 20-01-2006 21:08:20 >>>
> Now I need to figure out how to CREATE named ranges when I build a
spreadsheet in VBA.

Eh? Isn't this VBA:

-----Original Message-----
Sent: Friday, January 20, 2006 10:31 AM
Subject: Re: [AccessD] Syntax for seeing named range in excel

A Named Range can be created like this:

  ActiveWorkbook.Names.Add "John", "=$C1:$D4" 

or more specific:

  ActiveWorkbook.Names.Add "John", "=NameOfWorksheet!$C1:$D4" 

If that Named Range exists, it will be adjusted to the new range settings.

---

Or have you something else in mind?

/gustav