Vba as400 iseries jobs

Need to create a VBA macro in excel to copy the data from other workbooks into single workbook but in different sheets. Then refresh the already present pivots and rename the file. We can see repeatedly tasks in near future similar to this.

Editable Powerpoint Automation through vba .

I will need a person for a excel VBA work today for 1 hour

Hello, I'm looking for a VBA developer to write a script or process that takes columns of data in Excel and transforms it to text in a Word document. Copying-and-pasting won't work for our scale and purpose. More details will be shared with shortlisted applicants. Prefer hourly rate vs. fixed project price in case there is any back-and-forth needed, but open to anything. Please let me know if you're interested and your availability. Thank you

Hi, I need an excel expert well versed in Formulas and VBA for a small task.

Hello, I have a word template with a customized toolbar and I need to copy the entire toolbar from one-word document into another. The customized toolbar is developed using VBA Macros

I need Autometic invoice generator that will generate invoice Save pdf in folder Print invoice Save all data in database Etc

I am preparing a GUI for call log and i need a developer to link the GUI with the Excel data base. The GUI is ready and also the datasheet. I need it by Sunday, June 26. How much would that cost?

I am preparing a GUI for call log and i need a developer to link the GUI with the Excel data base. The GUI is ready and also the datasheet. I need it by Sunday, June 26. How much would that cost?

I would like to build an excel VBA spreadsheet that is able to trade stock options and stocks on the SAXO trading platform. See the link below: You should use the OpenAPI add in provided by Saxo to develop the VBA code. You can setup a free demo account on your own to also test the code. It should be able to retrieve the live prices of the options, allow the user to buy and sell options direct from the the excel spreadsheet. It should also be able to retrieve all the associated information about the particular stock option, and stocks. For instance, last done price, “option greeks”, days to expiry etc. A proof of concept is necessary before I will award the project. The proof of concept can be tested using a demo trading account which you can

Hi Zoltan N., I noticed your profile and would like to offer you a two hour online work job. I'm looking for the one familiar with VBA, Computational Finance related tasks. The work which will be held on 27.06.2022 from 18:00-20:00(GMT+2). Candidate should be available to me in this time slot. Please reach out to me for more details.

Looking for a professional for an online work (VBA, Computational Finance related tasks) which will be held on 27.06.2022 from 18:00-20:00(GMT+2). Candidate should be available to me in this time slot(This is crusial). The candidate should be familiar and should be able to perform perfectly the tasks in attachment. Please reach out to me for more details.

Hi! I would like someone with the expertise of Macro excel to create a simple system for me. I have the design ready but the buttons need to be coded. Basically, need the system to search a data from textbox in excel and display a different data to another textbox. Please look through the PDF file for more info.

We are currently working with an Excel spreadsheet + VBA for automated processing of our online orders. The VBA script scraps the data from our wordpress/woocommerce store, enters it into the spreadsheet, mails the orders to the suppliers, puts the mail in a folder on the server, updates order statuses and exports data for accounting. In the future, these operations should be performed not by VBA, but with the help of Office Scripts and Power Automate, so that we can work with the table from MS Teams. The VBA scripts are all viewable and can be used as templates. However, it would be desirable that the developer not only adopts the code 1:1, but also critically scrutinizes it and makes suggestions for improvement.

I have a folder with 6000+ xml files, all structured in the same way. I need to import them into MS access in order to have a more useful database. I manually imported a couple of them, however I would now like to import the rest in an automatic fashion. The xml files need to be appended to the only table in the access file. The xml files are named in sequence with the following structure where the suffix MGPPrezzi obviously does not change. The files start from 20050101 and end 20220624: some files are attached so that you can test the script. I am not sure if there are missing files, should the file be missing, the script should write down the filename/date in a (single) txt file or in a separate table, and fill in the 24 rows (hours) for that day with an empty cell. Not a N/A, not a ...

I am looking for a skilled Full-stack hard worker. I need to start the contract work today. Read the below requirements correctly before the proposal. - Must have skills set: 1. ReactJs. 2. Chrome extension development 3. Ruby on Rails - Must be an indi...3. Ruby on Rails - Must be an individual developer. - MUST work on PST for 4~5 hrs as PART-time (So it is preferred for the full-time dev who can work on PST as Part-time) from Monday to Friday, sometimes need to work on the weekend. - MUST work on for the next 2~3 years for long-term - Familiar with Github and Jira If you can do it now, just reply with the word "Individual Skilled Full-stack (VBA + PHP)Hard Worker" and select your prefered option on the proposal. Thanks Hourly rate will start from $8/h and inc...

I need a simple excel vba code. copy paste rows based on cells data/condition. Thank you!

Task 1: Improvement existing Makro in Rollei Orderformular, tab WE Overview Source File: Rolleo Orderformular, tab WE Overview Target File Rollei WE data base - I have changed some input in the file. Therefore, some changes are needed. - The new source file columns AA to AD are currently not exported to the target file. Please revise the macro. Any newly added columns (which are not hidden) must be also exported. This should work generic also in future without changing the macro every single time. - The new columns AA to AD are hidden in the target file. The upload must still take place once the export macro is initiated. - if columns are hidden in the source file  no export shall take place. - If columns are hidden in the target file  export shall take place - In the target file I ha...

Task 1: Improvement existing Makro in Rollei Orderformular, tab WE Overview Source File: Rolleo Orderformular, tab WE Overview Target File Rollei WE data base - I have changed some input in the file. Therefore, some changes are needed. - The new source file columns AA to AD are currently not exported to the target file. Please revise the macro. Any newly added columns (which are not hidden) must be also exported. This should work generic also in future without changing the macro every single time. - The new columns AA to AD are hidden in the target file. The upload must still take place once the export macro is initiated. - if columns are hidden in the source file  no export shall take place. - If columns are hidden in the target file  export shall take place - In the target file I ha...

I am looking for a skilled Full-stack hard worker. I need to start the contract work today. Read the below requirements correctly before the proposal. - Must have skills set: 1. ReactJs. 2. Chrome extension development 3. Ruby on Rails - Must be an indi...3. Ruby on Rails - Must be an individual developer. - MUST work on PST for 4~5 hrs as PART-time (So it is preferred for the full-time dev who can work on PST as Part-time) from Monday to Friday, sometimes need to work on the weekend. - MUST work on for the next 2~3 years for long-term - Familiar with Github and Jira If you can do it now, just reply with the word "Individual Skilled Full-stack (VBA + PHP)Hard Worker" and select your prefered option on the proposal. Thanks Hourly rate will start from $8/h and inc...

I am looking for a skilled Full-stack hard worker. I need to start the contract work today. Read the below requirements correctly before the proposal. - Must have skills set: 1. ReactJs. 2. Chrome extension development 3. Ruby on Rails - Must be an indi...3. Ruby on Rails - Must be an individual developer. - MUST work on PST for 4~5 hrs as PART-time (So it is preferred for the full-time dev who can work on PST as Part-time) from Monday to Friday, sometimes need to work on the weekend. - MUST work on for the next 2~3 years for long-term - Familiar with Github and Jira If you can do it now, just reply with the word "Individual Skilled Full-stack (VBA + PHP)Hard Worker" and select your prefered option on the proposal. Thanks Hourly rate will start from $8/h and inc...

Looking to create a file extract from MSAccess using VBA code. The user will click on the MSACCESS form and generate an excel document. The output tab displays the format we are looking to get. Sheet1 is the source data that would require to use of columns "Catagory Name" & "Name" to produce specified output in tab spread sheet.

We have an excel macros sheet in which calculators are built. I need someone to build the same calculator on google sheets with the same functionality. Attaching the current calculator & Brief document for reference. I would need this done with strict timelines.

The current version of VBA Word macro () is not functioning properly. Please correct macro and rename it so I can run your own version. Several files were sent via chat.

Previous VBA worked perfectly, but a new poem is partially successful. Need to update code into ribbon VBA 2.0.

I have linked-up hysys with excel through VBA and managed to extract some data from hysys into the excel file. However, I am still struggling to extract all the data I want. Example: I am not able to extract pipe segment performance data (reynolds number, inlet and outlet velocities), bulk properties such as bulk density and bulk velocity of a stream. Currently I am using version 10 of Aspen hysys.

Hi there, glad to catch you online! I would like to hear if you have a bit of time to look at some VBA work within PowerPoint? I want to run macros to automatically setup the animations and transitions.

In recent Microsoft updates, they set VBA macro-enabled workbooks from the internet with an attribute called "Mark of the Web". This attribute has caused my excel workbooks on my network drive to become unusable, as when I open the workbook, macros are blocked. A picture of the error is attached and I have tried everything that they have suggested in the below link without luck. Maybe I am doing somthing wrong, but setting my network drive to a trusted location and recognized as a trusted source does nothing. Setting Excel 365 to recognize my file as a trusted file yields no results. This error does not allow me to turn on macros regardless of excel policy settings for the file that I open from my network drive.

automation engineers for its business processes. This role is ideal for people with automation experience in both web and client-server environments. You will be required to work on both long term projects and short-term rapid development en...people with automation experience in both web and client-server environments. You will be required to work on both long term projects and short-term rapid development engagements. Strong analytical ability to grasp functional requirements and visualizing future automations will be needed. Skills and experience - C#, ASP.NET, WebAPI - SOAP, Rest API integration - Process automation using .NET or VBA - Running SQL/ODBC queries - Interest to work with AI services offered by AWS or MS Cognitive Services - Knowledge of the healthcare industry is a...

5 – 7 Years of hands-on experience in .net Framework, C#, VB.net, VBA, Web API, SQL, JavaScript and HTML on windows platform Handson experience with Power Automate RPA tools Handson experience with building and compiling solutions, and hosting web APIs and applications on IIS Good knowledge/understanding of SQL/Stored procedures Knowledge and experience with RPA tools like Automations Anywhere, Blue Prism, UIPath would be an added advantage Knowledge and experience with web crawlers/scrappers will be an added advantage. Good understanding of web application unit testing and creating unit test plans Good knowledge of quality process, knowledge of Agile would be an advantage Experience working in healthcare domain and cloud-based solution would be added advantage...

I need vba developer for one task. I need some changes in my previous projects.

Create a VBA Code for my outlook to 1. Count Inbox Emails by Sender Domain in My Outlook. 2. It must be based on my inbox. i.e. count domain from inbox Vinny @ or nancy @ or adam @ Output format in Excel i.e. Count Domain 65 @ 35 @ 31 @

I am looking for a skilled Full-stack hard worker. I need to start the contract work today. Read the below requirements correctly before the proposal. - Must have skills set: 1. React Native. 2. laravel 3. React and NodeJs - Must be an individual devel...React and NodeJs - Must be an individual developer. - MUST work on PST for 4~5 hrs as PART-time (So it is preferred for the full-time dev who can work on PST as Part-time) from Monday to Friday, sometimes need to work on the weekend. - MUST work on for the next 2~3 years for long-term - Familiar with Github and Jira If you can do it now, just reply with the word "Individual Skilled Full-stack (VBA + PHP)Hard Worker" and select your prefered option on the proposal. Thanks Hourly rate will start from $8/h and inc...

I am looking for a skilled Full-stack hard worker. I need to start the contract work today. Read the below requirements correctly before the proposal. - Must have skills set: 1. React Native. 2. laravel 3. React and NodeJs - Must be an individual devel...React and NodeJs - Must be an individual developer. - MUST work on PST for 4~5 hrs as PART-time (So it is preferred for the full-time dev who can work on PST as Part-time) from Monday to Friday, sometimes need to work on the weekend. - MUST work on for the next 2~3 years for long-term - Familiar with Github and Jira If you can do it now, just reply with the word "Individual Skilled Full-stack (VBA + PHP)Hard Worker" and select your prefered option on the proposal. Thanks Hourly rate will start from $8/h and inc...

We have an excel macros sheet in which calculators are built. I need someone to build the same calculator on google sheets with the same functionality. Attaching the current calculator & Brief document for reference. I would need this done with strict timelines.

Looking for someone to check and fix error on existing file. Details will be provided via chat. Only bid if you can start right away and can complete it in next hours. Budget 20$. Confidential project.

Hi, i need a script that i can send a lot of json post request with excel. All informations should be in 1 file possible and the script should be that it is no problem if we have 1 or 300 "FormularItemList" Please check the pictures

I need an Access / VBA expert to develop above requirements: 1) Show on client file ( file / PP_MASK) inside form header all totals related to 7 fields (columns Ø, ORE CARRELLO, NO COD, 901, 922, TOTAL, PP) according to selected filters (REPARTO anda DATA) Development files will be sent during project discussion. Please check carefully all project files before asking informations and make a bid. These are the first requirements for interesting engagements on my future projects.

I need to modified vba and macro project made by my senior by following my preferences, changing terms, it just simple modification, by due to my little experience in vba and macro, i ant to ask for assistant I need someone that has availability, speaks good English, and is a pro.

Source File name: "Rollei Auslandbestellungen" VBA Export button in the file creates the target file "BestellungenMail" We have now added in the source file 2 new columns: 1) Column C (Rev.) 2) Column D (Lot) Task 1: The new columns in the source file shall also be added to the target file. The sequence of the columns in the target file and column description shall be same as in the source file. Task 2: The current VBA uses the combination of "Order Number" + "Art.No." as identification to compare old and new data (new data are marked yellow). This shall be changed as follows. "Order Number" + "Art.No." + "Rev." + "Lot" shall be the new identification. All other aspects of the existing VB...

I have a VBA code which works fine. my requests are as follows: 1- The workbook will be in a shared drive and used by several users (not in the same time), so everything must by dynamic. Any reference to drives must be avoided (D: or C:). 2- The workbook will be in a folder with some other folders. the content of those folders to be attached based on the criteria selected in the master sheet (screenshoot attached). So if I select Product1, all files inside Folder1 to be attached in the email. 3- the workbook has a Contact sheet which includes email addresses, the email generated must include them all in the BCC. and it should be dynamic as well (xlDown). Happy to explain further if required.

Hey, I have a pdf file. I need to create this pdf (use the word excel VBA at the top of your proposal) as same as in the excel program. So that we can do our day-to-day work. Please chec the attaced file Thanks

Hey, I have a pdf file. I need to create this pdf (use the word excel VBA at the top of your proposal) as same as in the excel program. so that we can do our day-to-day work. Please check the attached file. Thanks

Hi Khizer T., I noticed your profile and would like to offer you my project. We can discuss any details over chat. I'm a financial reporting analyst, I have an excellent experience in excel, however, I need assistance in some VBA macros to help me automate the reports to my management. I'm offering $10 dollars/Macro. I'll require around 5 to 10 Macros to automate my reports during the upcoming week. Please let me know if you're interested and available for the assignment. Best Regards,

I have a VBA code which works fine. I want it to include all files inside a folde, the folder path is in a cell, not in the code itself. which makes it dynamic. Also, I want the email to get all the email addresses in a certin sheet in the workbook (contacts) into the BCC field. but it should be dynamic also (xlDown)

Already created a user user. Need help with VBA coding to make the user form working. Need it to be done in 2 hours. Only people with knowledge of VBA should bid. Msg with VBA to know that you read the project.

Hi Friends, Hope you can help me, I got two excel files, x1 & X2 both contains identical columns (date ,reference number and amount), I need your help in regard to 1) Sort on the basis of Date & Reference Number (each files) -As same reference will repeat on different date 2). Open X!.xls add together amounts in accordance with same reference number ...in the step 3, store in different name yamt 4) Copy both files in single sheet with all columns (Including xamt & yamt) 5. Check these calculated figures (xamt & Yamt ) are matching each other with same reference number & date loop , if matching just highlight, otherwise write not "Matching" Please file attached files, thanks in advance , the result should be as in the third file, I also need VBA s...

I have a VB.net code and want to call it from EXCEL. Can anyone make an example for me? In the attached VB code, I have a subroutine and a function. I want to call subroutine to get function. Check the attached code, it should be straightforward. Expected deliverables are: (1) VB project file (2) Working EXCEL example - for example, get xvalue(10) from mvalue(1 to 3) Use the following mvalue for the sample calculation mvalue(0) = 1.0195 mvalue(1) = 0.44943 mvalue(2) = 0.58316 mvalue(3) = 0.41768

...performing non-tipped work. This means that 36.67% of the time spent by the server performing work in the week was on non-tipped work. That 11 hours should be paid at the full minimum wage. Approach To calculate the difference between the BWW payments and what was legally required the actual time at tables must be calculated. To do this the use of a programming language is needed, in this case, VBA would be the most straightforward as it is within Excel. The purpose of the program will be to automatically apply the law as stated above to the given data to calculate the true deserved pay. The first step is to calculate the actual time a server was with tables this can be done in the same manner for every day and employee, so it should be nested within a loop that cycles th...

INSTALL HYLAFAX ON A NAKED SERVER - LIKE A OWN ROOT SERVER ON DEBIAN... JUST FOR BEING READY TO BE T.38MODEM READY AND OPERATE WITH CISCO AS400 GATEWAYS IN BEING ABLE TO SEND OUT FAXES ON 160X E1 FAX LINES AND EVEN RECEIVE FAXES .... WE ARE NEEDING AS VM-TELECOM SRO IN SLOVAK REPUBLIC... WHICH IS OUR BUSINESS OPERATING AS VOIP TELCO COMPANY... WHERE I TRY TO ESTABLISH A OWN WEBPAGE... BEING ABLE TO SIGN UP FOR EVERYBODY IN THE WORLD ... FOR A OWN FREE FAX NUMBER.... AND SEND OUT FAXES... TO THE WHOLE WORLD... INCLUDING CURRENTLY "UKRAINA" AS COUNTRY +380 AS TELEPHONE NUMBER...THAT YOU CAN SEND TO UKRAINE COUNTRY FREE OF CHARGE AS MANY PAGES AS YOU WANT... -YOU EVEN SHOULD BE ABLE TO RECEIVE FAXES... SINCE IN EVERY CITY WE HAVE LOCAL TELEPHONE NUMBERS... WHERE WE HAVE THE...