Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It keeps giving me a notification of Object variable or Will block variable missing but I cant figure out what I am missing. Someone please

image text in transcribed

It keeps giving me a notification of "Object variable or Will block variable missing" but I cant figure out what I am missing. Someone please help me out.

This is the entire code I have. I don't have a source code.

Microsoft Visual Basic for Applications DF Master to Prod TOOL WORKINGm (break-Module Codell file Edit View Insert Format Debug Run Tools Add-ins Window Help - XXM KST in 6. Col 66 (General) Sub Get Data From File() Dim File ToOpen As Variant Dim OpenBook As Workbook Application.ScreenUpdating = False File ToOpen - Application.GetOpen Filename (Title:="Browse for your File 4 I FileToOpen. Sheets (3) .Range("A").Value = "Actual Travel" Then Set OpenBook = Application. Workbooks.Open(File Topen) OpenBook.Sheets (3).Range("E2:E13").Copy ThisWorkbook. Worksheets("Input").Range("G28"). Paste Special xl Pasteva Set OpenBook - Application. Workbooks.Open(FileToopen) OpenBook. Sheets (3) .Range("H2H13").Copy ThisWorkbook.Worksheets("Input").Range("020"). PasteSpecial x1 Pasteva OpenBook.close false Else Set OpenBook = Application. Workbooks.Open(FileToOpen) OpenBook. Sheets (2) .Range("G2:13").Copy ThisWorkbook. Worksheets("Input").Range("028"). PasteSpecial xl Pastoval Set OpenBook - Application. Workbooks.Open(File ToOpen) OpenBook.Sheeta (2) .Range("N2: N13").Copy ThisWorkbook. Worksheets("Input").Range("029"). PasteSpecial xirasteval OpenBook. Close False End If Application.ScreenUpdating = True End Sub

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

U11 Informing Industry: Publicizing Contract Actions 317

Answered: 1 week ago

Question

I receive useful feedback about my performance.

Answered: 1 week ago

Question

I am encouraged to offer opinions/suggestions.

Answered: 1 week ago