WorkBook Naming

Feb 20th, 2002, 05:16 PM

Jack in the UK · Feb 20th, 2002, 05:36 PM

Hi

Thats blank that one.. please try again

Rdgs
==========
Jack

brettvba · Feb 20th, 2002, 05:39 PM

OK what I ment was is it faster to use a
Publicconst workbook as string _ = "workbookname.xls
or is there another way???
This is to reference a workbookname through all procedures!

Ivan F Moala · Feb 20th, 2002, 07:00 PM

Quote:

On 2002-02-20 16:39, brettvba wrote:
OK what I ment was is it faster to use a
Publicconst workbook as string _ = "workbookname.xls
or is there another way???
This is to reference a workbookname through all procedures!

I don't think speed is the issue with this declaration....it is just more efficient
and better programing if you work with this
particular workbook name over a large project
to declare it once and use it many times....

Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 05:36 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Thats blank that one.. please try again Rdgs ========== Jack

Feb 20th, 2002, 05:39 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	OK what I ment was is it faster to use a Publicconst workbook as string _ = "workbookname.xls or is there another way??? This is to reference a workbookname through all procedures!