Đã Hủy

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

Kỹ năng: Visual Basic

Xem thêm: 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++

Về Bên Thuê:
( 79 nhận xét ) Amami, Japan

Mã Dự Án: #58712

18 freelancer đang chào giá trung bình $65 cho công việc này

sachinsanchela

I can do it well.

$60 USD trong 8 ngày
(56 Đánh Giá)
5.6
ajay192

Please see PMB for details.

$72 USD trong 3 ngày
(3 Đánh Giá)
3.6
ramvinod

we can do it for you

$65 USD trong 2 ngày
(1 Đánh Giá)
3.3
ingemaj

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

$55 USD trong 3 ngày
(2 Đánh Giá)
3.0
raheelafzal

Hi plz see PMB for detail

$70 USD trong 3 ngày
(1 Đánh Giá)
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 Thêm

$50 USD trong 3 ngày
(5 Đánh Giá)
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 trong 1 ngày
(1 Đánh Giá)
2.7
softwareprabhu

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

$100 USD trong 4 ngày
(4 Đánh Giá)
1.9
trendset

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

$50 USD trong 10 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
0.0
mlhos

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

$50 USD trong 20 ngày
(0 Đánh Giá)
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 trong 7 ngày
(0 Đánh Giá)
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 Thêm

$99 USD trong 10 ngày
(0 Đánh Giá)
0.0
splend

We have very strong Skill in VB.

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
Jaimon

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

$60 USD trong 2 ngày
(0 Đánh Giá)
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 trong 20 ngày
(0 Đánh Giá)
0.0
jetenterprise

Will definitely be satisfactory else money will be sent back.

$45 USD trong 2 ngày
(0 Đánh Giá)
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 trong 2 ngày
(0 Đánh Giá)
1.4