[AccessD] Syntax for seeing named range in excel

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com