Dibatalkan

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

Kemahiran: Visual Basic

Lihat lebih lanjut: 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++

Tentang Majikan:
( 79 ulasan ) Amami, Japan

ID Projek: #58712

18 pekerja bebas membida secara purata $65 untuk pekerjaan ini

sachinsanchela

I can do it well.

$60 USD dalam 8 hari
(56 Ulasan)
5.6
ajay192

Please see PMB for details.

$72 USD dalam 3 hari
(3 Ulasan)
3.6
ramvinod

we can do it for you

$65 USD dalam 2 hari
(1 Ulasan)
3.3
ingemaj

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

$55 USD dalam 3 hari
(2 Ulasan)
3.0
raheelafzal

Hi plz see PMB for detail

$70 USD dalam 3 hari
(1 Ulasan)
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 Lagi

$50 USD dalam 3 hari
(5 Ulasan)
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.

$75 USD dalam sehari
(1 Ulasan)
2.7
softwareprabhu

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

$100 USD dalam 4 hari
(4 Ulasan)
1.9
trendset

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

$50 USD dalam 10 hari
(0 Ulasan)
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.

$60 USD dalam 3 hari
(0 Ulasan)
0.0
mlhos

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

$50 USD dalam 20 hari
(0 Ulasan)
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.

$60 USD dalam 7 hari
(0 Ulasan)
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 Lagi

$99 USD dalam 10 hari
(0 Ulasan)
0.0
splend

We have very strong Skill in VB.

$100 USD dalam 5 hari
(0 Ulasan)
0.0
Jaimon

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

$60 USD dalam 2 hari
(0 Ulasan)
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

$45 USD dalam 20 hari
(0 Ulasan)
0.0
jetenterprise

Will definitely be satisfactory else money will be sent back.

$45 USD dalam 2 hari
(0 Ulasan)
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.

$50 USD dalam 2 hari
(0 Ulasan)
1.4