• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    How do i refer a cell in SAP code.

    Dear All, This codes (session.findById("wnd[0]/usr/ctxtS_BUKRS-LOW").text = "277") updates a SAP field with the Value "277". The value 277 is based on the excel Sheet1 Cell = A2 . So how can I refer this cell in the above code to have the value. Example : If A2 = 299 , then i need a code as...
  2. P

    Copy & Paste Codes from sheet2 to Macro module

    Thanks for the reply Logit ! I have a set of SAP macro codes in the excel Range (B2:B61). sheet name " Codes" ( This codes Varies al the time based on my input) I need to copy this code in VBA module to Run it.. ( By clicking a button) Since the Codes varies all the time, Manually copying the...
  3. P

    Copy & Paste Codes from sheet2 to Macro module

    Dear All, Attached excel file with codes and steps to perform. Request your kind help on this.
  4. P

    Copy & Paste Codes from sheet2 to Macro module

    Hi all, Greeting, Need your kind help for completing my project. Requirement:- I have a customized macro codes in the excel sheet named "sheet2 " from cell A2 to A250 . i need to copy this code in Macro Module named "Format" and save .. so that i can run a macro with my customized code. Need a...
  5. P

    Combines 2 range of data untill the input is empty

    Dear Sir, 1.Date as per new - dd.mm.yyyy 2 . Common code - as per new , 1st common code for start and end date , 2nd common code for Esc date. 3.Below screenshot to specific the content color wise, Green color are Common code + inputs, Blue color are default data for each contract processing...
  6. P

    Combines 2 range of data untill the input is empty

    Hi Sir, where is a lot of confusion due to i have inserted a row and the comments what i have given is very generic. Now attach the new file with what really i do here with the same code and same format. Please refer the attachment and help me in finding a code.
  7. P

    Combines 2 range of data untill the input is empty

    Thank you sir , Code works perfectly for what i have suggested but some more i have missed to explain you in my previous post. Sorry for the inconvience Attached again the input data file and code original codes which i use for the processing. Highlighted in Yellow color in the file - Default...
  8. P

    Combines 2 range of data untill the input is empty

    Dear All Greetings !! I'm new to Macro coding and need your support on my below query I have a Range of data and common codes separately . I'm looking for a code which combines both and results as below Have attached a file with a scenario . Please need your best support to simply my work...
  9. P

    PDF EDIT

    Hi All, Greetings ! I'm a learner in VBA coding. please help me in the below requirement. > We will save many PDF files in a specific folder. > PDF may have many pages. Example : In PDF, We have many pages and all the pages have a similar heading as " Invoice copy", We no need the word "copy"...
  10. P

    Help on Input box in excel using VBA

    Hi Shrivallabha, Code works !! . Thanks a lot for your help. I'm happy to learn from you. Hi Debraj, Thanks for your reply . yes what you said is correct
  11. P

    Help on Input box in excel using VBA

    Hi Shrivallabha, I will be using only one row in my template to copy datas from excel to .vbs file, like A2:A57 or A2:A123, not like A1:C20 as you mention. Sorry i have not clearly mentioned this is my 1st post. I have attached a excel file which will help you better to understand my...
  12. P

    Help on Input box in excel using VBA

    Thanks for your quick reply Shrivallabha, Your codes help me but I need the data range the user given should be copied to .vbs file (Path "C:\Users\prasoonj\Desktop\New folder"). Please help me on this.
  13. P

    Help on Input box in excel using VBA

    Hi All, I'm a beginner in excel and I need your assistance to complete my requirement. Scenario : I need to copy data from Sheet1 Range starts from cell name C1 and end with the cell name which user required and need to paste it in .vbs file. Please assist me for creating INPUT BOX which may...
  14. P

    Copy and Paste problem

    Hi All, I need your help for simplifying my work. Could you please teach or prepare a macro for my below request. I use to work on excel the same work . i need to copy a value form cell reference C4 & E7 (Default) in sheet1, sheet2, sheet3.....sheetn and paste in the separate Consolidated...
Back
Top