Annulé

Create Macro

Hello every body

Please read carefully , and if you can make what I need.

-You must know how to create Macro in Microsoft Visio

-You must have the following software loaded onto your PC

-Microsoft Excel 2003 or later

-Microsoft VISIO 2003

Create Macro In Microsoft Visio

--------------------------------------

In the attached Zip folder you will find a Microsoft excel 2003 spreadsheet named TEST. This spreadsheet has 3 sheets named "Page_01", "Page_02" and "Page_03". There is no data on any of the sheets.

You will also find a Microsoft VISIO drawing with 1 blank A4 drawing named TEMPLATE.

Please create a macro button on the template drawing called "Import excel sheet names"

When the user double clicks the Macro button a macro form will appear. It will ask the user to select an excel 2003 file from there directory. Once they have selected the file the user presses a button on the form called "create pages"

The macro will then create a new VISIO page for every sheet within the excel spreadsheet selected. It will also name each page the same name as the excel sheet names.

If the user was to select the TEST spreadsheet, the user would now have four pages in there VISIO diagram named "TEMPLATE", "Page_01", "Page_02" and "Page_03"

(I need some training on VBA and Macros)

Compétences : PHP, Architecture Logicielle, Visual Basic

Voir plus : create php pages, create pages, visio microsoft, vba create folder, microsoft macro, microsoft excel vba, microsoft excel test, create folder vba, vba macros, vba excel macro, microsoft visio, macro, macro vba, macro excel, excel vba macro, excel macro vba, create spreadsheet, create folder, excel vba read page, microsoft excel template, macros excel basic, visio import data, microsoft software macro, import data macro excel, create sheets data sheet

Concernant l'employeur :
( 1 commentaire ) Giza, Egypt

N° du projet : #1641123

4 freelances ont fait une offre moyenne de 9 $ /heure pour ce travail

danielgpratidya

Hi, I have it ready in your pmb

10 $ USD / heure
(46 Commentaires)
5.2
koolsidz

VBA Whiz here. I have bid for $40 for the entire project. Also I don't see the attachment. If you are interested then please see PMB.

10 $ USD / heure
(51 Commentaires)
5.2
ifaisal

Hi Please see my private message. Regards Faisal

7 $ USD / heure
(6 Commentaires)
3.7
agtech2012

Dear Client, We (Agile Technosys) have gone through your requirements, and are pretty sure can provide you the quality solution which you are expecting. Further details are provided in the private message box. W Plus

8 $ USD / heure
(1 Commentaire)
1.0