İptal Edildi

program in Visual Basic to complete and automate some Excel functions

I am looking for someone to program in Visual Basic to complete and automate some Excel functions. I also would like to have a nice menu to avoids the macro setting problem when using the application on different computers. Here is a sample of what I already have:

'ARIZONA

'delete unwanted rows - needed for extra rows and columns when subtotaling

Worksheets("Arizona").Activate

Rows("2:10000").Select

[url removed, login to view] Shift:=xlUp

'run filter on STATE

Range("Inventories!$A$1:$AA$10000").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _

"DataforQueries!$A$3:$A$4"), CopyToRange:=Range("Arizona!$A$1:$V$10000"), Unique:=False

' Sort by Inventory, Subdivision and UBL

Range(("A1"), [url removed, login to view](xlLastCell)).Sort Key1:=Range("B2"), Order1:=xlAscending, Key2:=Range("C2") _

, Order2:=xlAscending, Key3:=Range("A2"), Order3:=xlAscending, Header:= _

xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _

DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _

xlSortNormal

'Sub total by Subdivision

Range(("A1"), [url removed, login to view](xlLastCell)).Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(3, 16), _

Replace:=True, PageBreaks:=True, SummaryBelowData:=True

I also have a network storage that uses the Window credentials. I currently have a Batch file that runs the commands but I would like a GUI based program that asks for login and then removed the credentials. Here is an example.



net use z: \10.57.1.254TechSupport /u:Tech

net use z: /d /yes

Beceriler: Visual Basic

Daha fazlasını görün: what to program, sort function c, sort array c, selection problem, no complete, c sort function, automate basic functions excel inventory, program visual basic excel, what is macro in excel, a1, visual, Visual Basic Excel, true, some program, rows, ORIENTATION, nice program, inventory program, filter sort, excel visual basic, excel automate, Computers, c basic, basic, basic program in c++

İşveren Hakkında:
( 79 değerlendirme ) Amami, Japan

Proje NO: #58712

18 freelancer bu iş için ortalamada 65$ teklif veriyor

sachinsanchela

I can do it well.

in 8 gün içinde60$ USD
(56 Değerlendirme)
5.6
ajay192

Please see PMB for details.

in 3 gün içinde72$ USD
(3 Değerlendirme)
3.6
ramvinod

we can do it for you

in 2 gün içinde65$ USD
(1 Değerlendirme)
3.3
ingemaj

I am an experienced VB-programmer. I can help your with any Excel automation tasks. See my PM please.

in 3 gün içinde55$ USD
(2 Değerlendirme)
3.0
raheelafzal

Hi plz see PMB for detail

in 3 gün içinde70$ USD
(1 Değerlendirme)
3.0
abhijitcari

We are working with VB for the past 6 years. We provide after sale service as long as our client wants it. It's our passion to do programming and we could even compromise on our payment for this if we are alloted the j Daha fazlası

in 3 gün içinde50$ USD
(5 Değerlendirme)
3.2
amanullahs

i can do this project. my expertise is excel vba and can finish this project in 1 day. give me a chance and i'll prove this.

1 gün içinde 75$ USD
(1 Değerlendirme)
2.7
softwareprabhu

Hello i am interested to do this job and looking forward for your reply... thanks. prabhu.

in 4 gün içinde100$ USD
(4 Değerlendirme)
1.9
trendset

I will finish this project in ten days if you give it to me

in 10 gün içinde50$ USD
(0 Değerlendirme)
0.0
ImranHabib

WE have Some Excelent Programming Skills To Complete This Project and know how to Deal with Excell Functions Automation. You will Feel great working with us.

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

I've excellent programming skills in VBA and good experience in financial sector.

in 20 gün içinde50$ USD
(0 Değerlendirme)
0.0
luckymourya

Being Expert in VBA excel. Doing the same kind of job in my regular work thats why i'm sure to complete the project on time.

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

Thanks for taking the time to review our bid At MXicoders. We specialize in providing total e-commerce, e-business and branding solutions to small and medium size business worldwide. We are selective about the jobs Daha fazlası

in 10 gün içinde99$ USD
(0 Değerlendirme)
0.0
splend

We have very strong Skill in VB.

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

I am expertise in Excel and VB. I could do ur work at right time and international standard .

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

i am not very experienced but what i want is not money but to gain knowledge. Thus, i am signing up for this project for such a low amount. I will take somewhat more time than others but so am i taking less money

in 20 gün içinde45$ USD
(0 Değerlendirme)
0.0
jetenterprise

Will definitely be satisfactory else money will be sent back.

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

Hi, I work with VB and VBA for more then 7 years. I can give you wat you want in a short time.

in 2 gün içinde50$ USD
(0 Değerlendirme)
1.4