View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] wagee@btinternet.com is offline
external usenet poster
 
Posts: 16
Default opening a workbook with VBA

On 8 Apr, 21:25, Jason Lepack wrote:
Sorry the brackets are not required as it's being used as a procedure
not a function.

Workbooks.Open "path to your workbook\name of your workbook.xls"

Cheers,
Jason Lepack

On Apr 8, 4:24*pm, Jason Lepack wrote:



Workbooks.Open("path to your workbook\name of your workbook.xls")


On Apr 8, 4:15*pm, wrote:


I must be thick. How can I open a workbook with VBA?- Hide quoted text -


- Show quoted text -- Hide quoted text -


- Show quoted text -


Thanks very much Jason! You have proved my thickness. I was using
brackets instead of quotes.....another day wasted<sigh Thanks again.
Wayne