| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i open a second workbook using a vba code
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i open a second workbook using a vba code
dim wkbk2 as workbook
set wkbk2 = workbooks.open(filename:="c:\somefilename.xls") uk wrote: -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i open a second workbook using a vba code
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 . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i open a second workbook using a vba code
this is a code from MACROS MADE EASY
Sub Workbook_Open() Workbooks.Open("data.xls") End Sub "Gord Dibben" wrote: 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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
| Need VBA Code to Open a Workbook in read only | Excel Discussion (Misc queries) | |||
Hybrid Mode
