Find Jobs
Hire Freelancers

fix my macro, vba and sap gui scripting error handling

$10-30 USD

クローズ
投稿日: 4年以上前

$10-30 USD

完了時にお支払い
hello, I'm new to vba and sap gui scripting, could someone point me into the right direction please? I think I have a problem with the error handling statement maybe. it supposed to put the icon value(Green per example) in column C if there is any and to leave column C empty and put "No icon " on column B and then go to the next cell and check again if there is an icon or now. I have a list of element in excel (Column A) that I want to check in sap and instead of checking one by one manually I'm working on a macro to check all the items on excel and returns the value of the icon (if green in sap, it should return the icon value and put it on column "C") if it doesn't find the icon it should put the value : no icon found on column "B". I tried to put on error resume next but the problem is that it only work once and then it start puting the same value in column C and B regardless if there is a green icon or not. if I don't put in error handling method, once there is no icon, vba shows that the problem is on the below line: [Code] [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3").[login to view URL](0).Width = 4 but when I do the following it works properly (puts "no icon" )and end exit the macro: [Copy to clipboard] '=====================Column A contains the Numbers I want to check on sap on error goto msg For Each rng In Columns("A").[login to view URL](xlCellTypeConstants) Elements= Cells([login to view URL], "A").Value If [login to view URL] Like "?56*" Then '============================================ [login to view URL]("wnd[0]").maximize [login to view URL]("wnd[0]/tbar[0]/okcd").Text = "/nvf03" [login to view URL]("wnd[0]").sendVKey 0 [login to view URL]("wnd[0]/usr/ctxtVBRK-VBELN").Text = Elements [login to view URL]("wnd[0]/usr/ctxtVBRK-VBELN").caretPosition = 10 [login to view URL]("wnd[0]").sendVKey 0 [login to view URL]("wnd[0]/mbar/menu[2]/menu[0]/menu[3]").Select [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3").[login to view URL](0).Width = 4 [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3/lblDV70A-STATUSICON[0,1]").SetFocus [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3/lblDV70A-STATUSICON[0,1]").caretPosition = 0 [login to view URL]("wnd[0]").sendVKey 2 [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3").[login to view URL](0).Width = 4 [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3/lblDV70A-STATUSICON[0,1]").SetFocus [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3/lblDV70A-STATUSICON[0,1]").caretPosition = 0 Value = [login to view URL]("wnd[0]/usr/tblSAPDV70ATC_NAST3/lblDV70A-STATUSICON[0,1]").IconName [login to view URL]("wnd[0]/tbar[0]/btn[3]").press [login to view URL]("wnd[0]/tbar[0]/btn[3]").press [login to view URL]("wnd[0]/tbar[0]/btn[3]").press Cells([login to view URL], "C") = value End If Next msg: cells([login to view URL], "D").value = "No icon" End Sub [\code]
プロジェクト ID: 21878689

プロジェクトについて

6個の提案
リモートプロジェクト
アクティブ 4年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に6人のフリーランサーが、平均$41 USDで入札しています
ユーザーアバター
Hi, I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, and Visual Basic Application including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting databases to and vice versa (+ automation with VBA). My modules allow filling information on forms (with drop-down list ), manipulating and merging the info in structured tables and populating results in build-in reports and forms. There is a search engine with high search capability to find specific records. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria. There is a report generator which enables you to develop templates independently, and the files secured by username login and password. Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
$50 USD 7日以内
4.0 (5 レビュー)
5.0
5.0
ユーザーアバター
It's better to send the Excel source file to have a look. It's more convenient to find problems. Of course, sensitive information in the file can be processed.
$20 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello, I’m a full time Excel data analyst. Please contact if you are interested. Have a great day and thank you.
$30 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I have good experience with sap gui with excel macro and vb script more then 4 years.
$30 USD 5日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

POLANDのフラグ
Lodz, Poland
5.0
2
お支払い方法確認済み
メンバー登録日:10月 24, 2015

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。