Open excel workbook using a macro

Closed
Report
-
 jim -
Hi, Can some1 help me open a workbook using a macro from another workbook.

Im working in two.xls and need to run a macro and open workbook one.xls?

Is this possible.

Tried the following:

Workbooks.Open FileName:="C:\Users\Bastard\Desktop\one.xls"

i just get a run time error 1004 - cant find this file. it is there trust me.

Please help.
Thanks.

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
It should work. try deleting the macro and retype the macro and see
6
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Hi thanks for the reply.

I have deleted and tried again and no luck.
I created the same macro at work using my xp pc and office 2000. Here at home im using vista and office 2003.

Do u think its got something to do with vista or office 2003?

Thanks again for the help.
workbooks.open("c:\name\name\name")
worksbooks("c:\name\name\name").close

if you use .kill it will delete it