Search results for query: *

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..)...

much appreciated to both of you. The macro works and i was going to ask how i could mask or put in the leading zeroes. so bravo to both of you. Thank you so much!

Hey, Thanks for replying. I decided to try using that code in Visual Basic 6.0 to make a stand alone application, but it gives me an error: Run Time error '1004': Method 'Cells' of object '_Global' failed and it highlights the "Do Until Cells(iRow, 1).Value =...

Sorry about that. Here's a sample of what the data looks like on the Excel sheet: a1 = "Check #" b1 = Issue Date c1 = "Amount" a2 = 0001010 (its a check number) b2 = 102303 (a date) c2 = 00010000 (a dollar amount w/ leading zeroes and is reads as 100.00) a3 =...

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 tried that code, along with different variations and it gave me a runtime error '438'--object doesnt support this property or method. Any other ideas?

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...