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:
'delete unwanted rows - needed for extra rows and columns when subtotaling
[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:= _
'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
18 freelancers are bidding on average $65 for this job
I am an experienced VB-programmer. I can help your with any Excel automation tasks. See my PM please.
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 Fazla
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.
Hello i am interested to do this job and looking forward for your reply... thanks. prabhu.
I will finish this project in ten days if you give it to me
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.
I've excellent programming skills in VBA and good experience in financial sector.
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.
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 Fazla
I am expertise in Excel and VB. I could do ur work at right time and international standard .
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
Will definitely be satisfactory else money will be sent back.
Hi, I work with VB and VBA for more then 7 years. I can give you wat you want in a short time.