Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VBAnovice43

    Looking through Excel cells for Date

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

    Converting an Excel file to text file

    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!
  3. VBAnovice43

    Converting an Excel file to text file

    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 =...
  4. VBAnovice43

    Converting an Excel file to text file

    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 =...
  5. VBAnovice43

    Converting an Excel file to text file

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

    Opening up an Existing Excel Workbook and worksheets

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

    needing to increment a date by one day and print to excel

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

    Opening up an Existing Excel Workbook and worksheets

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

Part and Inventory Search

Back
Top