Opening a Workbook

[vectorges]

I have a macro that opens a workbook, then tries to copy data from a specified area. WHen I run the macro, I get the error:

Run Time Error 1004

The macro stops, but the desired workbook is open. The code I am using is:

Sub CopyDataFromWeek()
Dim SheetName As String
Dim FullName As String
SheetName = Range("A19") & ".xls"
FullName = "C:AwipTsp43_xls" & SheetName
Workbooks.Open FileName:=FullName

And teh last line is highlighted. Any ideas??

[brettvba]

On 2002-05-14 15:27, vectorges wrote:
I have a macro that opens a workbook, then tries to copy data from a specified area. WHen I run the macro, I get the error:

Run Time Error 1004

The macro stops, but the desired workbook is open. The code I am using is:

Sub CopyDataFromWeek()
Dim SheetName As String
Dim FullName As String
SheetName = Range("A19") & ".xls"
FullName = "C:AwipTsp43_xls" & SheetName
Workbooks.Open FileName:=FullName

And teh last line is highlighted. Any ideas??

The code works fine on my comp with the exception that i changed the path for the filename.

Suggest that maybe something is wrong with your path otherwise everything should be a ok

[vectorges]

The path in my code has single backslashes, the test in this post has double slashes. I assume you are using single slashes in the path name?

[Tom Schreiner]

FullName is a property of the Workbook object.
Ex. Workbook.FullName
Not a good idea to use variables with the same name of a property in the object model you are working with.
I would chage FullName to something else...
Tom

[brettvba]

Yeah what Tom said

for some reason when you post it puts in double slashes don;t know why!