We use a commercial product to manage properties and currently have to manually extract information on a regular basis to do a populate a Word document based on a template. This is extremely time consuming so are looking to automate this process.
The back-end to the product is a SQL Server database. As it is a commercial product we do not have access to the schema nor can it be modified. We already have the SQL query with the fields that we need to have populated in the Word document. It is anticipated the workflow will going something like this:
1. User opens the Word document template
2. Connection to the database
3. A dialogue box prompts the user to select the property from the database (or they can type the property number if they know it)
4. When the property is selected, the query is run on that primary key and results are returned from the database
5. The Word document is populated and returned to the user for further editing
You will need to write VBA or equivalent using Word and Office to achieve this. The additional software footprint should be minimal for the workstation. Our company uses Office 2010.
For this task, you will be given a login to our network with Remote Desktop Gateway and access to a workstation running Windows 7 with Office 2010 and access to a SQL Server.
Hi, I'm new to Freelancer, and keen to make a good impression. I have an engineering degree from the University of Adelaide, and in my current role as a Petroleum Engineer, I have become an expert in MS Office, and Daha Fazla
Bu iş için 23 freelancer ortalamada $500 teklif veriyor
Hi Sir. Instead of VBA scripting I can design a professional Word Add-in, using .Net, for your organization that shall be accessible through top ribbon like other controls and would populate the Word Doc from SQL datab Daha Fazla
Hi, This will be achieved by designing a MS office addin in Visual Studio. A word toolbar button will be added to do this data extraction. I have 9 years experience in C# win-forms, VBA, office addins and SQL Se Daha Fazla
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: P Daha Fazla
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to Daha Fazla
Office/VBA/SQL developer. This is what I do as my daily job. Can help. Regards, Svet.
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement, (SQL db and fields etc) and I can start to get this done Daha Fazla
Hi, I could help you with this. About the Step 3, how do you want the user to choose the property? A list by name or search by location or how (sorry I don't know your database so these are the only suggestion)? Daha Fazla
Hello sir i can develop the required code in Microsoft Office (VBA) to extract data from MS SQL Server and insert into Word Document(s) Best regards vnb400
Hello, I would go with ADO to extract data from the database. The final solution would be VBA based with no third-party software needed. I'm trusted developer - your data will be safe with me. However, I would r Daha Fazla
Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Prod Daha Fazla
Hey there - Do you want it as a macro (VBA) ?... I believe : separate application would be good for your scenario....I may require you to show me the steps in your computer the list of steps that you are doing manually Daha Fazla
Hi, We’ve had a good look at your project description and we’re very interested in providing a solution. We will develop a macro to run on the Word2010, which will fetch the data from the SQL server and will Daha Fazla
Dear sir, I'm interesting in your job. I have much experience in the MS Word, Excel, Access and VBA. I can do this job. If you want, I can develop a demo within a short time. Regards. PS. In order to show m Daha Fazla
Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.
Thanks for posting this project. I will write a which connects with database and perform all the required functions. I have 3+ years of experience in VBA coding and VB.net. i have recently developed to projects w Daha Fazla
Hello There. This is an Easy Job. let me give you an advice, Change the price range. is to high. I can do this task for AUD $180. Your needs are very clear. I did something like that but in Excel instead Word but Daha Fazla
I have extensive experience with MS Office automation, MS Excel, MS Word, MS Powerpoint, Ms Access, MS Outlook (in no particular order) using varies technologies, VBScript, VBA, VB6, VB .Net. As per your description, I Daha Fazla
Hello I will do this job perfectly assuring professional results Ready to start quality work immediately Regards
Hi, We are an experienced (6+ years of industry experience), highly dedicated and a proactive team of Developers, Designers and Social Media Marketing experts. We are working extensively in ASP.NET, PHP, HTML, V Daha Fazla