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!

  • Congratulations IamaSherpa 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. maththetraveller

    Output to Excel

    I finally got this, which works great! I'll add it to my code tomorrow. Sub Main() Dim Sessions As Object, System As Object, Sess0 As Object Dim xl As Object, xl_workbook As Object, xl_sheet As Object Dim iRows As Long, iCols As Long Set System = CreateObject("EXTRA.System") Set...
  2. maththetraveller

    Output to Excel

    Oh... Will that "append" to what's already in the file or will it overwrite on it?
  3. maththetraveller

    Output to Excel

    Thanks a lot! I'll try it at work tomorrow!
  4. maththetraveller

    Output to Excel

    That's the part of the code that sends data to different cells in Excel: Reason = "Prefers to use bank card / Other card" Open "C:\tempdata\Tracking.xls" For Append As #1 Print #1, Date, Time, Reason Close
  5. maththetraveller

    Output to Excel

    Hi! I created a macro that closes customers accounts. At first, the user needs to choose the reason for closing the account, then the macro performs the action and leaves a detailed note in the account. At the end, the macro sends the reason in a .txt file. I tried to send it to Excel, but my...
  6. maththetraveller

    Help needed for "Output to file"

    Hi! What i'm trying to do is to track a specific data in a simple .txt file everytime a user clicks on a specific macro and performs the action. What i can't figure out is how to tell the macro to go to the last line of the file before it prints the data. My code looks like this: Reason =...

Part and Inventory Search

Back
Top