Fermé

CASD Automation With Excel (VB)

Hi

I require an expert to complete some automation with VB in CA Service Desk

I have completed the basics to understand how i want the automation to work.

I require the automation to carry out the following.

1. Open the CA ServiceDesk website (complete)

2. Open a new Change Request (completed but with send keys) I would prefer the use of objects

3. Implement an intelligent wait for page load (the load time fluctuates greatly)

4. Switch to a new popup window

5. Complete the form with data from the spreadsheet

6. Export data from the spreadsheet into a text file - a simple list name that already exists

6a - Extract the order number from the page

6b - Export the data to a file specified in a folder on the local drive

6c. - Save the file using the name of the order number

7. Change tabs in the Webform and complete the forms with data from the spreadsheet

8. Select the attach file function in the web form

9. Instruct windows explorer to browse to the folder specified in 6b

10. Select the file specified in 6c and attach to the web form

11. Complete data on the webform using the data from the spreadsheet

12. Save and extract data from the web form and input onto source spreadsheet

13. Repeat until all rows in the excel sheet are complete

14. Create a button on the sheet that opens the created tickets and changes them to submit in the web form

15. Reference column in excel that has submit set to Yes or No

16. when yes open the CO ticket specified and change to the task to submit

Everyline of the VBA script must have comments explaining the use of the code.

Compétences : Excel, VB.NET, Visual Basic

En voir plus : automation vbs excel auto parameter, copy excel cell contents windows application macro, quality center automation error excel, autocad + vba + excel, access autocad from excel, autocad excel, autocad via excel vba, autocad automation excel, create autocad drawing from excel, open autocad file from excel vba, autocad vba commands, automation com excel classe, excel macro switch windows, vba excel delimiter default windows, macro excel activate internet windows, task automation using excel macro, visual excel automation open excel file, add line ole excel vb, airline ticket booking vb net windows application, asp net export datatable excel vb net

Concernant l'employeur :
( 0 commentaires ) United Kingdom

Nº du projet : #19455097

10 freelances font une offre moyenne de 13 £/heure pour ce travail

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus

£15 GBP / heure
(322 Commentaires)
7.9
PigtailXL

Hello Sr./Madam Hope you read my proposal and take a look into my Portfolio to see my reputation and capabilities. I am an experienced Windows Desktop Apps Developer (C#, C++), Web Data Extractor & Automator (using d Plus

£15 GBP / heure
(171 Commentaires)
7.1
shahinrahimi

hi, Good day, I read your description about this project and I'm interested in this project. I did more complicated than this project (Refer you to my recent reviews). so if you interested we could have quick chat on t Plus

£10 GBP / heure
(35 Commentaires)
4.5
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit my Plus

£13 GBP / heure
(15 Commentaires)
4.4
Jaluerp

Hi There, I am a Freelance Project Manager. I have a group of experts working for my company. I can accommodate your requirement with accurately and within the time. I have handled many of the projects same like th Plus

£22 GBP / heure
(0 Commentaires)
0.0
DebasishDevil

This is Debasish Jana. I have 5 years of experience in development field, please see my profile to know more about me. Please provide me complete details regarding your project or please send me complete code so it Plus

£12 GBP / heure
(0 Commentaires)
0.0
Frankhardy

Hi, I have gone through the requirements spec and look forward to perfect the "CA ServiceDesk" Automation System with the proposed features. I have more than 10 years experience in VBA/Advanced-Excel and have als Plus

£13 GBP / heure
(0 Commentaires)
0.0
NoSonforhim

I have 20 years in Database Developing, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Exccel, VBA VB6, Vb.net, and MS SQL server

£10 GBP / heure
(1 Évaluation)
0.0
chiragsavaliya57

Dear Hiring Manager, This is Chirag Savaliya your developer with 4 years of experience with web development and scripting based technologies. I have good experience with .NET Framework, ASP.NET MVC, ASP.NET,.NET Core Plus

£12 GBP / heure
(0 Commentaires)
0.0
alexandersolomon

My Name is Alexander, by profession I am a VBA developer, I have extensive experience on designing, analyzing, developing and automating different processes using VBA. I am RPA UiPath certified professional. With 5+ y Plus

£10 GBP / heure
(0 Commentaires)
0.0