vba to open workbook

[jondavis1987]

What am I doing wrong?

Sub Open_Workbook()
'Open Workbook
Workbooks.Open ("Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls")
End Sub

 

[JoeMo]

What am I doing wrong?

Sub Open_Workbook()
'Open Workbook
Workbooks.Open ("Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls")
End Sub

try deleting the parentheses around the file path and adding a drive before Users

 

[jondavis1987]

I've tried this but it seems to fail at the workbooks.open line and says it couldn't find it but that's the exact filepath

Sub Open_Workbook()
'Open Workbook
Workbooks.Open "C:\Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls"
End Sub

 

[JoeMo]

I've tried this but it seems to fail at the workbooks.open line and says it couldn't find it but that's the exact filepath

Sub Open_Workbook()
'Open Workbook
Workbooks.Open "C:\Users\jdavis\Dropbox\Quality Control\Asphalt\Misc\Yearly HMA Charts.xls"
End Sub

Perhaps you haven't gotten the exact file path. Here's a quick test to ensure you have it right.
1. Open the workbook manually
2. With the workbook open, press alt+F11 keys to open the VBE
3. Press ctrl + g keys to open the immediate window
4. In the Immediate window type (w/0 quote marks) "?Activeworkbook.FullName" and press the Enter key

 

[jondavis1987]

I appreciate the help. I had the filepath correct, but I didn't put ".xlsx" instead I just had"xls"

 

[JoeMo]

I appreciate the help. I had the filepath correct, but I didn't put ".xlsx" instead I just had"xls"

You are welcome - thanks for the reply.