Search results

Question - I am going to take this same workbook, and I would like to be able select the name for sample data on the ADT_Analysis tab, have the filename display (not the path, just the filename) and then at the same time, have the data in that file import onto the Sample Data tab. Instead of...

You have been most kind. Can you point me in the direction of a good place to start my VBA education? I am going to go through some of the classes on this site, but do you have any suggestions on the "Best way to learn"? This is all incredibly helpful, and I'm learning so much by trying to...

Aha! Of course. This resolved it!

Hello! I have added in a second button that will allow the users to load the sample file onto the sample data tab, and it works exactly as I wanted. However, when I went in and added an additional tab "MRG", it no longer functions. I think I updated the code properly, and I've gone blind and...

Sorry - Just discovered the feature "xlOverwriteCells" Solved that one!

One additional question please. Below is my code for importing data from a text file. When I run, I want the data to paste beginning in cell A3, but what is happening is that all columns are shifting out to allow for the imported data, including the button that I added for triggering the...

Thank you again. One question - Why am I getting "Invalid Type Identifier XXX" (and YYY, ZZZ)? Is there a way to just have it ignore anything other than those values that match the tab names?

This is beautiful! I think that I have seen a setting described where it can hide the actions going on with the copies (no screen blinking)? But it does exactly what I need it to do. I have also added a button to let the user select the text file to bring to the Sample Data tab. Here is how...

I think I'm getting closer to figuring out how to load the file. I have found an example of how to provide a file import dialog box and I'm working on that part right now. :-)

Huge apologies for giving such a bad example! A. In the sample workbook, the tab is "Sample Data" B. This workbook has the text already imported. The user manually imports into this tab in the current process. C. The way the text files exist, the first column will always denote the...

Hello - I am trying to find a method that will allow my users to import a text file into Excel, then copy rows to corresponding sheets within a template workbook based on the value found in column A. This is related to HL7 validation, and it works very well when the users manually filter and...

THANK YOU Thank You Thank you! This is what I was hoping to get to and it works. I added a button to the page and assigned the "TOC" macro to it, and it's simple and works. Hope to keep learning and one day contribute back to others!

You all ROCK. Thank you for the quick and helpful responses. I am going to try with the 'new' code shared above, but here is the original code I was working with. This (obviously is not my own original work - but was provided somewhere on the internet - my apologies for not having the...

Hello - I am brand new to VBA, but reading everything I can find and walking through tutorials and examples etc. I have added a Table of Contents module to my workbooks due to a huge number of sheets required in each. I would like to make this more user-friendly, by adding an "Update" button...