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
|