My goal is to copy a lookup table that I maintain in Personal.xlsb and paste it into whatever worksheet that is currently open on the desktop. The destination filename constantly changes (currently TESTERPASTE.XLSX) so I want it to paste it on whatever worksheet is currently open on my desktop. Is that possible ??
My humble attempt gives me an error message on line 2. Text entered is not a valid reference or defined name
Sub testerpastermacro()
'
' testerpastermacro Macro
'
'
Windows("PERSONAL.XLSB").Visible = True
Application.Goto Reference:="ENTIRELOOKUPTABLE"
Selection.Copy
Windows("TESTERPASTE.xlsx").Activate
Range("A1").Select
ActiveSheet.Paste
End Sub
My humble attempt gives me an error message on line 2. Text entered is not a valid reference or defined name
Sub testerpastermacro()
'
' testerpastermacro Macro
'
'
Windows("PERSONAL.XLSB").Visible = True
Application.Goto Reference:="ENTIRELOOKUPTABLE"
Selection.Copy
Windows("TESTERPASTE.xlsx").Activate
Range("A1").Select
ActiveSheet.Paste
End Sub