Hale, Jim
Jim.Hale at FleetPride.com
Mon Jan 23 12:47:24 CST 2006
You can do pretty much anything in code that you can do manually to a spreadsheet. Jim Hale -----Original Message----- From: John Colby [mailto:jwcolby at colbyconsulting.com] Sent: Saturday, January 21, 2006 6:48 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************** The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. As a recipient of this email, you are responsible for screening its contents and the contents of any attachments for the presence of viruses. No liability is accepted for any damages caused by any virus transmitted by this email.