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!

Recent content by rlvbrussel

  1. rlvbrussel

    Copy error from attachment to a cell in Excel

    Sorry i have that in mine code where i started Extra with access.
  2. rlvbrussel

    Copy error from attachment to a cell in Excel

    where must I used it, because i got the proper output where i want it. What did I forgot? Gr Raoul
  3. rlvbrussel

    Copy error from attachment to a cell in Excel

    Thank you for your help i got it work. Gr Raoul
  4. rlvbrussel

    Copy error from attachment to a cell in Excel

    Hello, sorry the code works... but i can you tell me how i can save the sheet. this is mine another part of mine code. Option Compare Database Option Explicit Public Sessions As Object Public Sess0 As Object [highlight #E9B96E]Public MyScreen As Object[/highlight] Public System As Object...
  5. rlvbrussel

    Copy error from attachment to a cell in Excel

    Hello, Indeed column G. I have tried your code but it didn't put the error in the cell. Set MyAreaDDN2 = MyScreen.AREA(23, 2, 23, 46) If MyAreaDDN2 = "M281 ARTIKEL IS NIET GEREALISEERD OP DEZE MAS" Then [highlight #F57900]MsgArea = Trim(MyScreen.GetString(23,2,79))...
  6. rlvbrussel

    Copy error from attachment to a cell in Excel

    msgarea string fillhttp://files.engineering.com/getfile.aspx?folder=6a851502-5051-43e1-8585-8fcddc59bc58&file=extra.png
  7. rlvbrussel

    Copy error from attachment to a cell in Excel

    I have a screenshot from access. http://files.engineering.com/getfile.aspx?folder=96fac726-76cc-48a4-b86e-5a549648a414&file=attachmate.jpg
  8. rlvbrussel

    Copy error from attachment to a cell in Excel

    Sorry, but it don't write to excel.
  9. rlvbrussel

    Copy error from attachment to a cell in Excel

    Must i put the code here or must i do something more. Because i put it there and i don't see the error in excel.. Sub Main() g_HostSettleTime = 1000 ' milliseconds OldSystemTimeout& = System.TimeoutValue If (g_HostSettleTime > OldSystemTimeout) Then System.TimeoutValue = g_HostSettleTime End...
  10. rlvbrussel

    Copy error from attachment to a cell in Excel

    Dim MsgArea as string MsgArea = Trim(MyScreen.GetString(23,2,79)) ' x=23, y=2 and long 79 can i use this for all the error messages' MsgArea = Trim(MyScreen.GetString(23,2,79)) MsgArea = Trim(MyScreen.GetString(9,2,79)) gr Raoul
  11. rlvbrussel

    Copy error from attachment to a cell in Excel

    Hello, the message error are on the follow area's MyScreen.AREA(23, 2, 23, 59) '"M280 GEREALISEERDE AANTAL IS ONVOLDOENDE VOOR AFBOEK-ACTIE" MyScreen.AREA(23, 2, 23, 46) '"M281 ARTIKEL IS NIET GEREALISEERD OP DEZE MAS" MyScreen.AREA(23, 2, 23, 34) '"V001 NSN/OSN MOET WORDEN INGEVULD"...
  12. rlvbrussel

    Copy error from attachment to a cell in Excel

    Hello, I have a question. I have build an access tool that starts extra. Extra gets data from Excel. If extra give me an error, then i want too copy that error to a cell in Excel on the same row. Mine code that i have: Sub Main() g_HostSettleTime = 1000 ' milliseconds...
See more

Part and Inventory Search

Back
Top