Hi everyone,
I have this excel file (please see attached "sample.xlsm") that monitors the number of transactions with an amount more than 50,000. The source file is a TEXT file with a filename of REP0607T.txt, where 06=Month 07=Day. I put all text file report together in a folder names by each year.
I wanted to have a VBA code that when i click the command button, it open/load the file with the specified date and start it in CELL A20 (as shown in sample.xlsm).
Thank you so much in advance.
Please attach a sample TXT file. Thanks.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
herewith attached the TXT file..Originally Posted by dflak
Hi everyone again,
I've recorded a macro with this thread, and it works perfectly. Below is the Code:
But my problem is, every time i want to change the date for checking... i change also the code for the destination of TEXT file.
Please Login or Register to view this content.
So what is the code to replace the destination that base of the inputted date on cell A3?
I solved it whith my own...
Here's my code:
Please Login or Register to view this content.
The macros you recorded work for June 7, 2017 only.
I looked at the text file you included. There are 46 lines in the file, the first 12 of which are blank. It looks like you want the blank lines copied in.
I will have something that will work for any date later today.
Press Alt-F11 to open the macro editor. Double click on Module1.
If you change the sheet name, you will have to change this line of code
You will have to change this line of code to show the path that contains the years as subdirectories:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks