Before I start, I just want to let everyone know this is not a VBA question. I am working with a stand along program through VB 6.0. I have made an Excel Template that was pre-made. Its a workbook where there is a sheet for every month of the year (Jan '04, Feb '04, Mar '04, Apr '04, etc..)...
Anyone know how to convert an Excel file to a text file with this format?
015P3212384351351351
...
...
Each line has fixed positions that represent some type of date like a date, a check number, etc...
The Excel file is in a template form where the first column is for a check#, the second an...
I need to increment a date (in the format of mm//dd//yy) by one and take that range of dates and put them in a column of cells in Excel. So it would appear like this:
10/1/03
10/2/03
10/3/03
10/4/03
10/5/03
10/6/03
10/7/03
10/8/03
10/9/03
10/10/03
Here's the catch: The program asks the user...
I'm fairly new to using VBA...I primarily use VB but basic functions. Let me describe what i'm trying to do first: i created a userform that basically has 5 command buttons. with a click of one of those buttons (each button is for a bank branch), a report is created with several dollar...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.