Find Jobs
Hire Freelancers

Create an interactive VB macro in Microsoft Word that sends command line data to PuTTy.

$250-750 USD

Closed
Posted over 3 years ago

$250-750 USD

Paid on delivery
I have a need for a visual basic for applications macro that searches a Word documents for lines of specifically formatted text. The Word documents are preformatted by a major switch manufacturer and contain the Method Of Procedure for installing and setting up their line of Photonic switches. The documents the company sends us contain numerous numbered paragraphs that contain setup instructions and command line inputs used to setup the switches via Putty. Currently I am doing this manually via cut and paste but this is very inefficient and because there are many more installations to do in the future; I would like to automate this process. If possible, the commands need to be sent directly to Putty via an input stream. The commands within the paragraphs of the documents are formatted in a green color. So I need the macro to perform the following routines: 1. Once the macro is run: Open Putty and automatically login via ssh with a session name and a universal username and password that I will provide. The session name can be extracted from the header of the document. 2. Scroll through each paragraph in the document while searching for any text that is green in color. There may be multiple lines of green text within a paragraph so the routine will need to detect and group multiple lines and send them as a block of commands to the Putty application. The macro should loop through each paragraph and show an interactive dialog box with action buttons starting with paragraph number 1. When the paragraph doesn't contain green characters; the dialog should state "No commands found" and show two buttons with labels of "NEXT" and "QUIT". Clicking on "NEXT" will scroll the document and loop through the next paragraph; again searching for green text. Clicking on "QUIT" will exit the macro. 2. For each paragraph containing a line or Block of lines with green text to be sent to the Putty application; an interactive pop up with three selectable buttons should appear. Each instance of the dialog box will show a string "Ready to Send Commands for" with a concatenation of the Paragraph number and Title e.g. "7.1 Configure L-Port Optical Transport Unit Channel". The buttons should be placed bellow the title of the paragraph within the dialog box. The first button label will be "Continue" and the second buttons label will be "Skip" and the third button will be "Quit". Selecting continue will Send the commands to the Putty command line and close the dialog. Selecting Skip will skip the paragraphs commands, close the dialog and then loop through the next paragraph. Clicking the "Quit" button will exit the macro. This process will continue until the end of the document where a final dialog will appear stating "End of Commands" containing an "OK" Button to close the dialog and exit the macro. 3. I intend to utilize split screen on windows 10 while using the macro. Word will be on one side of the screen and putty on the other so I can monitor the progress of the macro. Specifically; as the Macro steps through each paragraph of the word document I would like to see Word automatically and synchronously scroll through each of the paragraphs as the dialog boxes appear in the document as well. I am attaching a sample document that the macro will need to work with.
Project ID: 27637034

About the project

13 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average $438 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: Create an interactive VB macro in Microsoft Word that sends command line data to PuTTy. ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$500 USD in 10 days
5.0 (219 reviews)
8.0
8.0
User Avatar
Dear Employer, I understand you need to auto login in the system and check for what you need and extract that and paste it. I am an expert and will do the job for you. Kindly check my previous reviews here for your kind consideration: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks, Ashish
$555 USD in 3 days
5.0 (30 reviews)
6.6
6.6
User Avatar
Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -Python -PowerPointMacros -Automatioin -Automation tools -PowerBI -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D
$250 USD in 2 days
5.0 (9 reviews)
3.8
3.8
User Avatar
Vb expert. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$500 USD in 5 days
4.8 (19 reviews)
4.1
4.1
User Avatar
Hi, Hope you are doing well! I have 15 years’ experience in .net development! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. We will complete the work as per requirement. Let’s start work Thanks and Regards.
$250 USD in 7 days
5.0 (2 reviews)
3.5
3.5
User Avatar
--------------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have read your project details . I can Automated Data Analysis via Excel spreadsheet by maintaining 100% accuracy of your data absolutely as you want. -------VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting. I can start right now, please message me to discuss more. Thanks,
$280 USD in 2 days
4.9 (5 reviews)
3.6
3.6
User Avatar
Dear, I have extensive experience developing and I have made similar automation applications, I can make the application you need, please write to me and we discuss about the project, best regards
$250 USD in 2 days
5.0 (4 reviews)
3.4
3.4
User Avatar
hello get free sample I'm ready to make your macro for word i'm interested in your project i have 10 years experience in this field I'm highly skilled programmer in visual Basic {vb.net, vb6} , C# Programming Database {MS-Access , SQL Server} , Crystal Report , Microsoft Reports please check my portfolio
$500 USD in 4 days
5.0 (3 reviews)
3.2
3.2
User Avatar
I have previous experience and enough time to complete this task as well as your requirements. Just send more details on Chat.
$250 USD in 3 days
4.8 (9 reviews)
2.9
2.9
User Avatar
Hi, sir. Thank you for sharing your project Create an interactive VB macro in Microsoft Word that sends command line data to PuTTy., and I would be very happy to help you with your business. Let me share you with my expertise in Visual Basic for Apps, Microsoft, Visual Basic, Shell Script, VB.NET and relevant technologies. I have been doing a lot of work for this type of job. More detail you may be interested in will be provided over chat. You may also check my profile summary and portfolio items. As per your requirement, I can give you perfect answers as well. Your project immediately can be started and is looking forward to my participation. Best,
$555 USD in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm Rajitha. I'm familiar with the first part of the project which is extracting commands from the document. haven't done project similar to sending commands to Putty but would be able to do with some trial and error. Send a Message to discuss more. Thanks
$600 USD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
henrico, United States
5.0
1
Payment method verified
Member since Jun 7, 2018

Client Verification

Other jobs from this client

Create a PowerShell Script
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.