Question: Needing some VBA help.. How do you use the GetOpenFilename method to navigate to the file and obtain the file name? I am not allowed

Needing some VBA help.. How do you use the GetOpenFilename method to navigate to the file and obtain the file name? I am not allowed to open it as a workbook instead I am to open it for import. I then have to use the split method to parse the line of text into an array. and then build a message box that will display all of the words in the text file as a column. I appreciate your help.

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!

Please code in Microsoft Excel Visual Basic for Applications (VBA). Objective: Import and parse text from a file. - Write a sub that imports a single line of text from the text file...

Protecting Your Trademark ENHANCING YOUR RIGHTS THROUGH FEDERAL REGISTRATION Basic Facts About Trademarks United States Patent and Trademark Office MESSAGE FROM THE USPTO Thank you for requesting a...

I have the following completed: 1120, 2220,1125 A , 1125 E I need the following forms completed asap:SCHEDULE D and G form 4562, form 4797 schedule detail M-1 it should be fairly easy to do the rest...

txt file 12 swa Elon 9 0 0 0 qae Les 0 0 10 0 swe Todd 0 9 7 0 qae Jamey 0 0 8 0 swm Jeff 0 0 0 9 swe John 0 9 9 0 swe Eric 0 10 9 0 qae Darrel 0 0 9 0 swe Ariel 0 9 10 0 qae Joanne 0 0 8 0 swa Tim...

Module 9 Assignment: TOC Answer all the questions and submit your answer report to Module 9 Assignment in Dropbox by the deadline . The report should be typed, single spaced, in one MS Word file. You...

please try to answer parts 3,7&8 especially using python 2.7. my code is not working and this is due today. verify using working test codes. Basically I am stuck with the longestORF non reading (part...

please help with pictures Windows 10 Skills Review 1. Understand files and folders. a. Create a file hierarchy for an ice cream manufacturing business, using a name that you create. The business has...

Macon Supplies inc. sells auto parts to the wholesalers. When a customer calls in with an order and gives the customer ID and name, an order entry clerk keys in the customer number, and the computer...

For fuel cell trucks operating at high voltage efficiency (high fuel utilization) is more important than operating at maximum power. Describe the region on the polarization curve where you would want...

The perimeter of the rectangle is 2 4 . Write an equation to represent this situation. Then, write an equivalent linear equation.

Assuming no brokerage fees, calculate the amount of cash needed to retire Baldwin's 12.4S2030 bond early. Select : 1 Save Answer $5,421,896 $5,756,951 $6,135,775

Identify the elements of an effective employee assistance programme.

Design a health and safety policy.

Conduct simple mathematical calculations to identify demand and supply data.