Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Excel development tools?
Hi,
I want to develop some tools at work for Excel using Visual Basic. The goal is to make an exe file which will prompt the user for data input files and create spreadsheets. What tools do I need? Do I need to install Visual Studio Express and develop the VB code? Thank you in advance for any help. NJ |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel development tools?
Why not just use the built-in tools in Excel? You could have a 'template'
workbook with the functions built right into it through VBA and UserForms. Or create .xla files (Excel Add-Ins) to add functionality to Excel on user's systems. Or you can go with the Visual Studio/VB route, but it's kind of bumpy at the start of the ride. Exactly what types of tools are you looking for? An Excel file could be used to simply provide a UserForm for data entry - or enter data directly on a worksheet in it, and then VBA code could create a new workbook based on the data entered if so desired. Both the .xla files or a utility .xls file would be much easier to distribute than a VB package. "Neil Jones" wrote: Hi, I want to develop some tools at work for Excel using Visual Basic. The goal is to make an exe file which will prompt the user for data input files and create spreadsheets. What tools do I need? Do I need to install Visual Studio Express and develop the VB code? Thank you in advance for any help. NJ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel development tools? | Excel Discussion (Misc queries) | |||
New Excel development | Excel Discussion (Misc queries) | |||
.NET, CAS and Excel Development | Excel Programming | |||
Shareware Edwin's Power Tools decompiled and became Excel PowerPlus Tools | Excel Programming | |||
Development Tools Available for Excel | Excel Programming |