VBA - open an excel workbook

[maxon]

Hi All,

I have probably easy question, but I stucked on it.

I would like to open the workbook like this:

Dim myfile as string

myfile = Workbooks.Open(ThisWorkbook.Path & "\File.xls")

myfile.open

etc.

What im doing wrong?

 

[soidog]

Try:
Dim myfile As Workbook
Set myfile = Workbooks.Open("Path to your workbook\Workbooks name.xls")

 

[maxon]

I cannot do this this way when I would like to use Thisworkbook.path, there is an error.

Dim EXCEPTIONGENERAL As Workbook
set EXCEPTIONGENERAL Workbooks.Open(ThisWorkbook.Path & "\myFile.xls")

 

[soidog]

Make sure you put the two " signs in right place and you also have forgoten the = sign.

 

[maxon]

if Im trying to this way as above I have an error "Compile error: Expected:="

 

[soidog]

Check post #2 and #4 again.

I guess your workbooks name is: myfile.xls
Only you know the exact path to your workbook you want to open.
Here is an example of a workbook path to a file on your harddrive C:
("C:\Users\maxon\Documents\excelstuff\myfile.xls")
Right click the file in Windows Explorer, choose properties and there you can see the path.