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