Prev: need to sort 2 column "" as a dictionary ""
Next: import Excel worksheet to SQL Server table
From: Copacetic on 1 May 2010 10:42
I open or "add" a new workbook.

It records fine, but the call to "book7" is hard coded, and in the
future, the code will not be seeing "book7", so how do I call the newly
created workbook by other than its creation name? (I suppose I could
simply name it).
From: JLGWhiz on 1 May 2010 11:17
Or use:

ActiveWorkbook

But that only works so long at the new workbook is active. The best thing
is to name the workbook as soon as it is created.

myPath = ThisWorkbook.Path '<<<Change as applicable

Set newBk = Workbooks.Add
'Rename and save the file simultaneously.
newBk.SaveAs = myPath & "\Somename.xls" 'Or xlsx or xlsm, etc.

Workbooks("Somename.xls").Close

"Copacetic" <Copacetic(a)iseverythingalright.org> wrote in message
news:kafot592fothppo48jkdjvqgbjj0iot6mg(a)4ax.com...
>I open or "add" a new workbook.
>
> It records fine, but the call to "book7" is hard coded, and in the
> future, the code will not be seeing "book7", so how do I call the newly
> created workbook by other than its creation name? (I suppose I could
> simply name it).


From: Dave Peterson on 1 May 2010 12:26
I'd use a variable to represent that newly added workbook.

Dim NewWkbk as workbook
set newwkbk = workbooks.add

Then I could use refer to that workbook whenever I wanted.

newwkbk.worksheets(1).range("a1").value = "hi"

newwkbk.close savechanges:=false



Copacetic wrote:
>
> I open or "add" a new workbook.
>
> It records fine, but the call to "book7" is hard coded, and in the
> future, the code will not be seeing "book7", so how do I call the newly
> created workbook by other than its creation name? (I suppose I could
> simply name it).

--

Dave Peterson
From: Copacetic on 1 May 2010 13:25

Hmmmm... Colonel Clinc say "Vedy interesting..."

I should be able to use this replacement form in a few other
circumstances too. I need to become familiar with this little ghostly
fellow.

Thanks.


On Sat, 01 May 2010 11:26:23 -0500, Dave Peterson
<petersod(a)verizonXSPAM.net> wrote:

>I'd use a variable to represent that newly added workbook.
>
>Dim NewWkbk as workbook
>set newwkbk = workbooks.add
>
>Then I could use refer to that workbook whenever I wanted.
>
>newwkbk.worksheets(1).range("a1").value = "hi"
>
>newwkbk.close savechanges:=false
>
>
>
>Copacetic wrote:
>>
>> I open or "add" a new workbook.
>>
>> It records fine, but the call to "book7" is hard coded, and in the
>> future, the code will not be seeing "book7", so how do I call the newly
>> created workbook by other than its creation name? (I suppose I could
>> simply name it).
 | 
Pages: 1
Prev: need to sort 2 column "" as a dictionary ""
Next: import Excel worksheet to SQL Server table