View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how can i open a second workbook using a vba code

Not if you did not add more to it.

Show us the code you tried that does not work.


Gord Dibben MS Excel MVP

On Thu, 26 Nov 2009 09:20:01 -0800, uk
wrote:

hi i have tried the code that you recommended but i cannot get it to work

"Dave Peterson" wrote:

dim wkbk2 as workbook
set wkbk2 = workbooks.open(filename:="c:\somefilename.xls")


uk wrote:

--

Dave Peterson
.