Question: I need the VBA code for this study question: Open a new workbook, insert a module, and write a sub that does the following: (1)

I need the VBA code for this study question:

Open a new workbook, insert a module, and write a sub that does the following: (1) it uses an input box to ask the user for the path and name of an Excel file to open, and (2) it then tries to open the file. Run this sub and enter the name of a file that you know exists. It should open the file with no problem. Then run it again and enter a file that you know does not exist. What happens? Rewrite the sub with the appropriate error-handling capability to take care of this possibility and present a nice message to the user in either case.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The volume, lateral surface area, and end-cap surface area of a right circular cylinder with spherical end-caps are given by the following relationships: Volume: Vol = pi r^2 h + 4/3 pi r^3 Lateral...

Steps 10 through 26 Instructions 1) You are going to develop a VBA program that asks users (students in this case) to specify a few characteristics. 2) Open a new workbook. Create a Public Subroutine...

Activity 1 Jackson's Guitars uses an incentive scheme to pay its salespeople. All employees are paid a base retainer and sales in excess of the quota set for each employee are subject to an extra...

can someone please help me!!! i keep getting stuck at step 5 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up...

USING VBA This assignment requires 2 files (workbooks): vba_hwk7_Macro.xlsm and vba_hwk7_Data.xlsx. You are to create a macro that will be of assistance at the student fitness facility. Arriving at...

So I can make the flowchart but not sure how to make the VBA code. It's all super foreign to me 13.5 VBA Project: Olympus Tours You have just been hired by Olympus Tours (OT), a bus rental company...

Could someone please answer this, with steps and pictures ? Thank you Grader - Instructions Excel 2019 Project Grader - Instructions Excel 2019 Project Step Instructions Points Possible 10 12...

Follow the instructions below. Show formulas and results separately on excel spreadsheet Grader - Instructions Excel 2016 Project Step Instructions Points Possible 17 0.5 On the Invoice worksheet,...

Please show work step-by-step for each question! F G H J A B B C 1 PurchaseID LPurchase Date Customer 2 2 1/1/16 3 1 1/1/16 4 3 1/2/16 5 4 1/6/16 6 6 6 1/8/16 7 5 1/8/16 8 7 1/9/16 9 9 1/11/16 10 8...

Open a blank Excel workbook and save it as a MACRO-ENABLED file. Your workbook must contain only one worksheets named "Probl". Open the Visual Basic Editor (VBE) and insert a new module into the...

Based on the following transactions record journal entries for the month of May, 2023: May 01. Started business with cash $15000, accounts receivable $4000 & equipment $5000. 02. Paid office rent for...

HAR Write the equation of each function SHAHARSHAHARSHAHARSHAHAR: IARSg(x) is obtained by performing the following on by performing a the following on f(x)== A reflectionARSHAHAR: a) s-axis, a...

Please help with the journal entries: Described below are six independent and unrelated situations involving accounting changes. Each change occ rs during 2 0 2 4 before any adjusting entries or...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Within the White-Collar Occupations, where do Females have the strongest and weakest representations in the Federal Service?

What are the Five Phases of SDLC? Explain each briefly.

How can Change Control Procedures manage Project Creep?