Terminé

VB Script Needs

We have a data file that needs the following changes to the file:

1. Rename the single tab in the file to WCKD_InvReport (this one is already renamed in the example attached, but many are not so we just want to rename it to ensure it works) - this file is linked to an access database which is why we need the naming consistent.

2. Delete Rows above the header row (always start with the UPC field in column A), but could be varying row counts.

The VB code has to be in a separate file (named [login to view URL]) so we can add it to BAT file processing and trigger the macro.

The macro file containing the VB CODE needs to have a directory cell so we can enter the directory of the WCKD file to edit as this will impact a number of the same files of the same name stored in different directories per client. We maintain separate data warehouses per client so we do not need more than one directory location being modified at a time.

We will copy the file to a new directory location, update the directory in the excel file containing the macro, and then trigger the macro by adding a line in the bat file.

The requirements are the macro works on office365 excel installed on windows server 2019. The current excel version is Microsoft® Excel® for Microsoft 365 MSO (16.0.14131.20296) 64-bit

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

En voir plus : run script web page changes, script check website changes, script automatic check changes webpage, php script check page changes, script check webpage changes, script check price changes, script check page changes, php script detect page changes, add user group file vb script, asp vb script facebook application, autoupdate vb script, calculation table coding vb script material, calling vbscript vb script, calling web service asp classic application vb script, call website vb script, check set delimeter vb script, cisco vb script, convert multiple text files excel worksheets vb script, copy paste vb script, create database vb script

Concernant l'employeur :
( 3 commentaires ) Bentonville, United States

Nº du projet : #30977403

Décerné à:

bouslimi1979

Hello, Do you want to select the folder/directory using windows folder button, or do you want to enter the directory manually ? also in that directory, we will find a singe file to process or we may find other files ? Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(308 Commentaires)
7.8

26 freelances font une offre moyenne de 152 $ pour ce travail

(832 Commentaires)
8.9
(433 Commentaires)
8.3
(371 Commentaires)
8.1
(132 Commentaires)
7.1
(342 Commentaires)
7.2
ksriniravi

Greetings! I can come up with [login to view URL] file that would have a field to select the folder for processing and a button to initiate processing of files in the selected folder (in case manual initiation of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(227 Commentaires)
7.1
(215 Commentaires)
7.0
(165 Commentaires)
6.8
wsh2

* MsACCESS/MsEXCEL/SQL/VBA Business information, programming and database expert. American English is my first and only language. USMC combat veteran. Greetings from Easton PA, USA.. {smile} Highly experienced (25+ y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(56 Commentaires)
6.5
(121 Commentaires)
6.7
(143 Commentaires)
6.2
(126 Commentaires)
6.3
(21 Commentaires)
5.0
(28 Commentaires)
4.9
(25 Commentaires)
4.4
agupta2812

Hello there! Good day! I am interested in this project. I can help you with this. I am expert in VB script with more than 8 years of experience. Please reach out to me to discuss further. Thank you!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(5 Commentaires)
3.1
arunodaya123

HI hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects. I has done tons of projects similar to your requirement using VBA,. I c Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
2.9
DominikKrivarics

Hi, I can write a macro for you that completes the tasks listed in the description. Please contact me to discuss the further details. Thanks, Dominik

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
2.6
umairnoor32

Hello sir, i have read your all instructions and I can do it efficiently. Give me this project. I will never disappoint you and will give you unlimited revisions after completion the work. Thanks. Regards:- umair

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(2 Commentaires)
1.1
tomiapage

hello , ican do it for You. It seems to be very fast and easy job for me. If you want please contact me.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(1 Évaluation)
1.0