Opening a workbook declared as a variable in VBA

[jbenfleming]

I am trying to open up a workbook that is declared as a variable. Is there a way to do this by using the variable name? I'd rather not have to use the long file path name. In the code after I move "blanksheet" from "dailysales" to "monthly" the dailysales workbook will no longer be open, as "blanksheet" was the only sheet in that workbook. After moving that sheet over I want to open the dailysales workbook again.

Option Explicit
Sub adailsalesend()
Dim rownum As Double
Dim dailysales As Workbook
Dim monthly As Workbook
Dim blanksheet As Worksheet


    Set dailysales = ActiveWorkbook
    Set blanksheet = ActiveSheet
    Workbooks.Open Filename:="filenamehere.xlsx"
    Set monthly = ActiveWorkbook


    dailysales.Activate
    Columns("k:k").Delete


    blanksheet.Move After:=monthly.Sheets(monthly.Sheets.Count)
'below this comment is where I want to open the "dailysales" book. The code does not work.
    Workbooks.Open (dailysales)


End Sub

 

[jbenfleming]

For the record, It isn't a big deal for me to just use the filepath to open to workbook. I'm just curious if there is a way to use the variable name.

 

[Norie]

Unless the folder the workbook is in is the active folder then you need the full path and name.

 

[jbenfleming]

I thought that might be the case. Thank you.