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

    AS400 update file

    That's right, I was getting a compile error... The problem is solved now, it was indeed an incorrect record name. Thank you for your help!
  2. schwob

    I use a macro to automatically upda

    I finally found the solution!!! it's VERY tricky, especially for someone like me who is relatively new to VBA programming... The problem was that the embedded object had no name, so when I ran the macro I got "1004" error msg. What I did was the following: Dim XL As Excel.Application...
  3. schwob

    AS400 update file

    I AM using a "write".. I put an "A" in the file's F-spec as you said, but it seems that I'm not referring to the right record name, and I forgot how to look for the record name (I know, it must be VERY simple, but I'm not quite used to AS400 interface yet, since the first one...
  4. schwob

    AS400 update file

    I am totally new at AS400 & RPG programming, and I wanted to make a prog that takes a file from PC and transfer it to AS400 ... I had help for this first part and it works perfectly, but now I want to update the file I get from the PC it and send it back to the PC. I used "CPYTOSTMF&quot...
  5. schwob

    I use a macro to automatically upda

    In fact, my (simplified) code is: Public Sub Tarif1() Application.DisplayAlerts = False ChDir "G:\" On Error Resume Next ActiveWorkbook.Save On Error GoTo 0 If Err.Number = 91 Then '=> error Else Filename = ActiveWorkbook.FullName If...
  6. schwob

    Macro pb in Excel worksheets inserted in Word

    I use a macro to automatically update and save an Excel workbook in *.csv type. It works perfectly for any document opened in Excel, but when I use it on an inserted object in Word, it fails... I have a 1004 error message each time I run my macro on an Excel Worksheet object inserted in Word...
  7. schwob

    I use a macro to automatically upda

    I use a macro to automatically update and save an Excel workbook in *.csv type. It works perfectly for any document opened in Excel, but when I use it on an inserted object in Word, it fails... I have a 1004 error message each time I run my macro on an Excel Worksheet object inserted in Word...

Part and Inventory Search

Back
Top