Devam Ediyor

Create a VBA / Microsoft Office application to query a SQL database and populate a Word template

Scenario:

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.

Details:

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

Objective:

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.

Resources:

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.

Beceriler: Microsoft Office, SQL, Uygulamalar için Visual Basic

Daha fazlasını gör: visual workflow, microsoft number, vba time, vba for word, sql microsoft access, microsoft workflow, microsoft vba, microsoft access sql, end vba, microsoft company, write query, workflow microsoft, word template, vba word, office vba, microsoft word template, Microsoft office word, microsoft office template, microsoft access vba, extract information to, editing a template, create word template, create additional applications, word template microsoft, windows vba

İşveren Hakkında:
( 15 değerlendirme ) Newtown, Australia

Proje NO: #7001165

Seçilen:

tlaengineering

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

%selectedBids___i_period_sub_7% gün içinde 500%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 23 freelancer ortalamada $500 teklif veriyor

maverick44000

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

in %bids___i_period_sub_35% gün içinde600%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
6.0
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience in handling /PHP/Wordpress/Magento/Joomla/Drupal/Angular.js/node.js/ HTML5/CSS3/Java/ Python/Django/Javascript/MySQL/iOS/Andr Daha Fazla

in %bids___i_period_sub_35% gün içinde1030%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
5.7
feninsoftech

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

in %bids___i_period_sub_35% gün içinde722%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(27 Değerlendirme)
6.0
boriscikotic

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

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)
5.2
Teloquence

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

in %bids___i_period_sub_35% gün içinde789%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
5.2
svet63

Office/VBA/SQL developer. This is what I do as my daily job. Can help. Regards, Svet.

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
5.4
avinav606lx

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

in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)
5.0
hieutc

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

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
4.6
vnb400sl

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

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(40 Değerlendirme)
5.0
salih0vicx

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
4.5
abhinovpankaj

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

in %bids___i_period_sub_35% gün içinde266%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
4.4
expertatwork

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(22 Değerlendirme)
4.3
AcuityInfotech

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

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
4.2
AndroidAll

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

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
3.7
gperete

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
3.3
Mufaddalsaifee

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
3.3
danielrinf

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.5
oFAZo

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

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
4.2
nikhiltechnology

Hello I will do this job perfectly assuring professional results Ready to start quality work immediately Regards

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
2.8
epservsolutions

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

in %bids___i_period_sub_35% gün içinde252%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0