Devam Ediyor

Convert Excel VBA Application to Excel Add-In for Excel 2007

I wrote a Excel Scatter Chart program in Excel 2003 VBA that I need converted to a Excel Add-in that can be run as either a button in a menu or a menu item in Excel 2007 & Excel 2010. I average Office user will need to be able to install and add to menu (button or menu item) easily.

Background

I wrote a Scatter Chart program in VBA in the mid 1990s and converted it to an Excel add-in that others in my company and a few colleagues used in our analysis. The VBA application uses forms to collect info from the user on the XY Scatter Chart (X range, Y range and label range). The reason I had to build it was because you can not add a separate set of labels to the values of a XY Scatter Chart in Excel unless you do it manually. The application also allows the user to easily update existing scatters with a new data point and new label.

It has worked fine until Excel 2007. I am assuming it is a combined problem of a tougher security model and the shift to Ribbon menus, but frankly I do not have the time and my tech skills have been neglected, to figure out the fix. I have the spreadsheet and when I run the application from the spreadsheet XLS it works fine. It is the XLA that I can not run the way I used to run because I can’t see it and can no longer call the program from a menu button.

Before, I would have people drop the XLA on their hard drive. Copy down the path to the file. When in Excel they would add a Macro Button (I prefer smiley face) to a menu bar and assign the button to run the application. Example

'C:\temp\programs\excel\scat\[url removed, login to view]'!Goscat

Beceriler: İş Analizi, Excel, Microsoft

Daha fazlasını görün: excel 2007 add, excel vba add, works need excel, vba with, problem set analysis, excel to application, example of a company background, data forms in excel, data analysis with excel, data analysis for excel, company background example, call tech, business company background example, background of the company example, background of a company example, background company example, vba application add, convert vba macro excel menu item, vba time, vba for, uses for excel, tech background, new excel, in vba, excel vba with

İşveren Hakkında:
( 1 değerlendirme ) Greenwood Village, United States

Proje NO: #736445

Seçilen:

koolsidz

Please See PMB

2 gün içinde 400$ USD
(99 Değerlendirme)
5.7

12 freelancer bu iş için ortalamada 368$ teklif veriyor

hsameer

I am an expert in Microsoft Excel & Word services & well aware of your current problem. Please consider my bid & give me a chance to solve your problem ASAP.

in 2 gün içinde250$ USD
(3 Değerlendirme)
2.6
lohatama

You can use Visual Basic 6 (addin type project) for this purpose. So, it will have much change considering it has the similar syntax with your current VBA

in 2 gün içinde300$ USD
(1 Değerlendirme)
2.2
pradeep1210

Please see PMB

in 2 gün içinde400$ USD
(1 Değerlendirme)
1.9
self

Hello, check PM please, thanks.

in 7 gün içinde250$ USD
(2 Değerlendirme)
1.9
perumsat

There are two ways for presenting addin in Excel: use VSTO or use Shared addin. Which one do you prefer? If VSTO, then you need to have VSTO runtime installed while shared addin you dont need it. So, you need it presen Daha fazlası

1 gün içinde 500$ USD
(0 Değerlendirme)
2.4
mamun02

i extremely Need this job.

in 12 gün içinde350$ USD
(0 Değerlendirme)
0.0
paleboyeh

Hi there, I am a softwar engineer with and expeience of over 12 years programing and system administration and absolutely keen to deliver you the solution.

1 gün içinde 550$ USD
(1 Değerlendirme)
0.0
NikitaS

Hi, I'm very good in excel and VBA fo: excel so I can write any programm you need. As concerns that project I can convert your current script to 2007 add-in with ribbon menu. Regards, Nikita

in 3 gün içinde250$ USD
(0 Değerlendirme)
0.0
kathyglobcom

Hi I could do this job for you. If you need more people i can prvide you.I have a 50 seater call center here in the [url removed, login to view] services are telemarketing(inbound,outbound),Data Entry/Data Encoder,Virtual assistant Daha fazlası

in 5 gün içinde320$ USD
(0 Değerlendirme)
0.0
SCAnalytics

We have a team of VBA experts. We can do this project for you.

in 2 gün içinde250$ USD
(0 Değerlendirme)
0.0
freejourney2010

I can do this job

in 7 gün içinde600$ USD
(0 Değerlendirme)
0.0