![]() So I'm going to make a few additions here. And then we've got the, when we open this workbook, that's going to be the ActiveWorkbook. We've got this workbook, which is the workbook that this code is in. It's always going to start in range A1, so we're going to make use of that starting in cell A1. And in this particular word, there were 45 different letters. And starting in cell A1, it's got all the letters. And then when we open that, it actually has opened a new Excel workbook here. That's the string for the FileName variable, so that's how we can obtain the file name. So let's go ahead and work through this, just use F8, I need to put a break point there and this is going to be stored as the variable in the Locals window down here. When we open that, it's going to import the text file as a new Excel workbook. Then we're going to open that workbook, the file named Workbook. So the user can navigate to where the file is, and that's going to be stored as a string FileName. ![]() Next we're going to open up the Application.GetOpenFilename. The first thing we need to do is obtain a file, so I'm going to Dim a filename, FileName As String. ![]() And then it converts the coded-message in a text file to an English word and it outputs that in a message box. We're going to go to Decode, we navigate to the file that we want to decode, and that was my coded-message and then it goes through and imports. ![]() So now what we're going to do in this screen cast, we're going to make a decoder so I can, this is what we're going to be creating. And we see that we have a different letter on each line of this text file. And this then is the coded Morse code for that word. So we can go ahead and open that, the text file, wherever we saved it. And it also converted that to Morse code over here. So I'm going to go ahead and save that as a coded-message. So in the previous screen cast we did this, and this file enabled the user to save it as a text file. It's 45 letters and we're going to convert this to the Morse Code. For example, I've got this is really big name here. In a previous screen cast, I showed you how you can make a Morse code converter. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. Learners who have a foundational understanding of VBA code and programming structures can jump right into Part 2 of the course without taking Part 1 and use the screencasts in Part 1 as reference.Įach module will introduce foundational and broad problems inspired by situations that you might encounter in the real world. txt files 3) automate the import, modification, and consolidation of information from multiple worksheets into a central worksheet as well as the import of information from multiple workbooks to a central workbook and 4) gain experience with creating professional user forms to interface with the user, perform advanced calculations, and manipulate data on the spreadsheet. In Part 2 of the course, learners will: 1) learn how to work with arrays and import/export arrays from/to Excel using VBA code 2) learn how to work with text strings and write data to. "Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |