Find Jobs
Hire Freelancers

Visual basic script for Visio File (Automation of tasks from external data)

£20-250 GBP

Completed
Posted almost 5 years ago

£20-250 GBP

Paid on delivery
I need a visual basic programmer to make a script to automate the task of making pages (with names from a data source) in a visio file, based on data from an external data source. In practice, I'd select, say 10 shapes on an index, and the macro script would make 10 new pages with the page details linked to the same 10 records of the selected shapes on the index page. The activity would be: 1. The visio file would be linked to an external data source (an access database) 2. I would select a set of shapes. 3. These shapes would have a link field, with a page name. 4. The script would create the page (with the name taken from the shape's data field) 5. It would copy shapes from a template background page, paste them onto the new created page and link the data record to the shapes. I actually have the code, but I can't get it to work as I'm not an experienced programmer, so the logic should be in there. Example of code that's not working is shown in the attached file.
Project ID: 19893808

About the project

10 proposals
Remote project
Active 5 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
Awarded to:
User Avatar
The logic on the VBA code you attached here is valid already, just need to be repaired on certain lines so it will work as you expected. It is already do the page creation for a number of object/shape selection, but within the loop there is a statement which ask to do another selection which will then breaking the original selection. We should do the trick for this issue such as save the original selection to memory or anything so wont be mixed with the other selection. thats the solution
£100 GBP in 1 day
4.4 (57 reviews)
8.0
8.0
10 freelancers are bidding on average £123 GBP for this job
User Avatar
Hi! how are you? I am interested in your project. I have been developed many VB.net project for 5 years. I want to work with you for a long time. Please contact me. Best Regards.
£30 GBP in 2 days
4.9 (138 reviews)
7.3
7.3
User Avatar
Hi Nice to meet you. I read your job posting and I am very excited. I have a good skill in visual basic programming. You can check my ability in my profile. Please give me a chance to work for you. I will do my best. Thanks.
£135 GBP in 7 days
4.8 (69 reviews)
7.3
7.3
User Avatar
Hi, I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database. , especially with exporting databases to and vice versa (+ automation with VBA).  I consider myself a guru in Excel/VBA/Macro.  I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts). I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. With these skills, I develop financial modules including business valuation methodology & ratios (NPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, ROI, LTV, LTV, Terminal Value, TWR, S-Curve, sensitive analysis, optimisation, correlation and regression) for investors (including pitch decks, business plans, due diligence, financial modules like feasibility studies, and financial projections with dynamic scenarios).
£190 GBP in 3 days
4.9 (91 reviews)
7.2
7.2
User Avatar
Hello. I 'm expert in "Excel, PHP, Software Architecture, VB.NET, Visual Basic" and I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
£150 GBP in 3 days
4.8 (181 reviews)
6.6
6.6
User Avatar
Hi, Reading your project description about building a program that will automate task of creating pages makes me feel like you have me in mind when creating the project. I have all it takes to deliver. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I can complete a sample of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£150 GBP in 7 days
4.9 (58 reviews)
6.6
6.6
User Avatar
Hi, High talented Delphi, MatLab, Unity, VBA, Access, Microsoft Office, Java, Python and R, C#, C++, QT expert is here! As I am a professional Delphi, Python and C# developer, I can do your job perfectly Fast and Perfectly on time. I have 10+ years of experience for Delphi, Python, R, C#, C++ application Development. I have developed several dozens of applications such as OCR, AI, e-commerce, banking, UNESCO census. I understood what you want and want to like to discuss in more detail for your project. I sincerely hope to work with you. If you hire me and give me a chance to prove my abilities, I will give you the best results with my professional skills and will do my best to finish the project successfully. I am sure I can help you. Please see my profile. I am looking forward to your soon reply. Best regards.
£135 GBP in 7 days
5.0 (12 reviews)
5.3
5.3
User Avatar
Hi GaryDL001 I am good at PHP work I have following skills : Excel, PHP, Software Architecture, VB.NET, Visual Basic PHP - Expert! With proven experience. REPLY :- We have approx 7+ year of experience. I have commanding communication skills of English either in verbal as-well-as oral & i will be available to you on your preferred time zone for further negotiation. i have few queries that i would like to ask , kindly let me know when you are available for instant communication. please note that I am always available and can even become online anytime including my night to chat with you and can finalize the deal. Best Regards
£90 GBP in 10 days
4.9 (26 reviews)
5.2
5.2

About the client

Flag of UNITED KINGDOM
Reading, United Kingdom
5.0
8
Payment method verified
Member since Jun 9, 2014

Client Verification

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.