Suljettu

VBA Code for Form Filling, from an excel table

VBA Code for Form Filling, from an excel table

Hello, I'm needing a vba code that fills out a form on a page on my company's intranet.

We are talking about a Human Resources sector

In excel I have the personal registration(ID), name, note and description

On the intranet page, the code needs to copy the excel personal registration(ID) and click on an "ok" button;

A new page will be loaded, the code must click on the person's name;

A new page will load, you need to click on the link "PIN";

A new page will load, you need to click on the link "Change";

A new page will be loaded, there will be two fields:

In the first field there is a check box with the options (Blank, 0, 1, 2) and should be filled according to the excel sheet.

In the second field, it is text, and should be filled according to the excel sheet.

Finally click on the "Ok" button that will save the process.

The code will go to the next "personal registration(ID)" and will redo the process.

Note: The intranet can not be accessed by external users, so I believe we will have to chat or email so that I can provide the URLs and in case you need to "inspect the object" in some field.

The work is quite simple.

_____________________________________________________________________________________________

TRANSLATED FOR PORTUGUESE

Código VBA para Preenchimento de Formulario, a partir de uma tabela excel

Olá, estou precisando de um código vba que preencha um formulário em uma página na intranet da minha empresa.

Estamos falando sobre um setor de Recursos Humanos

No excel tenho a matrícula, nome, nota e descrição

Na página da intranet, o código precisa copiar a matricula do excel e clicar em um botão "ok";

Uma nova página será carregada, o código precisa clicar no nome da pessoa;

Uma nova página será carregada, precisa clicar no link escrito "PIN";

Uma nova página será carregada, precisa clicar no link escrito "Alterar";

Uma nova página será carregada, haverá dois campos:

No primeiro campo existe uma caixa de seleção com as opções (Em branco, 0, 1, 2) e deverá ser preenchida conforme a planilha de excel.

No segundo campo, é texto, e deverá ser preenchida conforme a planilha de excel.

Por último deverá clicar no botão "Ok" que irá salvar o processo.

O código irá para a próxima "matrícula" e irá refazer o processo.

Observação: A intranet não pode ser acessada por usuários externos, então acredito que teremos de conversar pelo chat ou email para que eu possa fornecer as URL e caso necessite "inspecionar o objeto" em algum campo.

O trabalho é bastante simples

Taidot: Excel, PHP, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: vba code generate report excel, form filling excel macro, vba code update sheets excel, excel userform data entry, excel vba forms advanced, how to create a data entry form in excel using vba, excel userform add data to table, excel vba userform code examples, excel vba data entry form download, excel vba userform examples, excel vba userform to input data, flash web form filling excel, vba code macro word excel, visual basic form filling excel, vba code convert html excel, vba code update data excel, vba code hide box excel, automate web form filling excel, vba code control handle excel, vba code run faster excel

Tietoa työnantajasta:
( 1 arvostelu ) São Paulo, Brazil

Projektin tunnus: #17838925

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

avinav606lx

Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Lisää

$98 USD 1 päivässä
(171 arvostelua)
6.5
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$30 USD 1 päivässä
(46 arvostelua)
5.1
UKgetITdone

Hi, I have good experience in VBA. Kindly give more details on requirements. Looking forward for response. Thanks Relevant Skills and Experience Good experience in VBA

$25 USD 5 päivässä
(1 arvostelu)
0.9
BAKERBHAI33

Dear sir, I read your job description very [login to view URL] give me this work.I can do the job.I am new to this market place so there is no benefit on my profiles. If you allow me to work,than I can give good [login to view URL] Lisää

$20 USD 4 päivässä
(0 arvostelua)
0.0
kishorsaundane

I have 5 years of experience in vba

$15 USD 1 päivässä
(0 arvostelua)
0.0
moksha19

With more than 8 years of experience in VBA, I have created numerous award winning macros in my organization which hav resulted in decreasing the overall efforts. Relevant Skills and Experience Do not need to worry on Lisää

$25 USD 2 päivässä
(0 arvostelua)
0.0
issamouu69

Hi, After reading the description and seeing the attached files, I can assure you that i can tackle this project with [login to view URL], as you mentioned, i will need to inspect the html page , but not to worry it should Lisää

$15 USD 1 päivässä
(0 arvostelua)
0.0
Iman90R

Dear Employer, I can do your project with VBA, or Matlab. Even I can create an interface for you with any other features you need. A have a certification for Microsoft office package Also, I have good experience in Ma Lisää

$35 USD 4 päivässä
(0 arvostelua)
0.0
tdi59413b3d7af72

Eu já criei algo parecido com oq você quer, se puder me enviar o arquivo com os dados e me dar acesso a sua intranet para os teste, talvez eu consiga entregar e 1 dia, ou menos.

$50 USD 2 päivässä
(0 arvostelua)
0.0