How to open another excel using VBA

Question

I have tried to write a script to open another excel.

My code

Sub test()
filetoopen=thisworkbook.worksheet("sheet1").Range("D18")

Where is my mistake?

Thank you for your advice.

Jonas Palačionis · Accepted Answer · 2020-03-07 15:45:38Z

2

You can use:

Sub test()
filetoopen = ThisWorkbook.Worksheets("sheet1").Range("D18")
Workbooks.Open FileName:=filetoopen
ActiveWindow.ActivatePrevious

answered Mar 7, 2020 at 15:45

Jonas Palačionis

4,8804 gold badges31 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1