473,327 Members | 2,118 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Should I use VB?

1
Hi,

I'm trying to do several things with the goal of automating some reporting, and am not sure what the right tools to use are, so maybe you folks can provide some clarity for me. I'm trying my best and have been trying many different tools, so any help is very appreciated!

Basically, I have a directory full of daily Excel files that I need to open, and merge into a larger sheet.Based on the file namesI need to add a "Date" value to the larger Excel sheet in a column so I know what date file the same from.

Next, I have some canned formulas I wrote I need to have run every time and automatically filled down in their respective column every month

in Column AA
=NETWORKDAYS(R2,Z2,Holidays!$A$2:$A$817)

in Column AB
=NETWORKDAYS(Z2,S2,Holidays!$A$2:$A$568)

in Column AC
=NETWORKDAYS(R2,S2,Holidays!$A$2:$A$876)

in Column AD
=IF(A2=31,"RDC",IF(A2=32, "RDC",IF(A2=38,"RDC","Proposal")))

in Column AE
=IF(AA2>=60,"60 plus",IF(AA2>=30,"30-59 days",IF(AA2>=10,"10 to 29 days",IF(AA2>=2,"2 to 9 late",IF(AA2>=1,"1 Day",IF(AA2=0,"0 days","Advancedl"))))))

Next, I need to automatically screen the data and clean for certain things, like rows in column A that start with 038, 031, 032 need to be pulled to a new sheet, etc.

So, knowing these requirements how would you ladies and gentlemen suggest I proceeed? Is there a tool I should use that has a low enough learning curve for me to use?

Many thanks in advance for your suggestions
May 6 '08 #1
1 1281
jeffstl
432 Expert 256MB
I would say you want to use VBA, which is essentially visual basic for office applications.

Excel will have tools for writing the code you need. (Hit Alt+F11 to get into the VBA editor within excel) Or go to Tools, Macro, Visual Basic Editor.

If you have not written VB before try to go online and find specific samples of Excel VBA code snippets and try them out so you can see how things work.

When you run into specific problems with code, post the code and the error\problem for help.

I can't point to any particular "good" site for VBA tutorials. However, there are alot of examples out there if you search, including some on this site.

This one might get you started.
Excel VBA Discussion
May 9 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

303
by: mike420 | last post by:
In the context of LATEX, some Pythonista asked what the big successes of Lisp were. I think there were at least three *big* successes. a. orbitz.com web site uses Lisp for algorithms, etc. b....
3
by: Andy Visniewski | last post by:
Should be easy, but I've been trying to figure this out for about half an hour with no luck. There is a table 'Cybex' which has all the Cybex products we sell, and a table 'Datasheets' which...
36
by: Jack Hughes | last post by:
This argument has come up two or three times lately. We have a web standards document at our company that say "Use valid HTML 4; We don't recommend switching to DIV-based CSS-P for layout just...
12
by: Sanjay | last post by:
hi, We are currently porting our project from VB6 to VB .NET. Earlier we used to make scale transformations on objects like pictureBox , forms etc.Now Such transformations are made on the...
8
by: Chris Mayers | last post by:
I am trying to track a suspected memory leak in an application I'm writing and through repeated simplification of my project, I have found the following which is quite easily replicated should you...
20
by: HKSHK | last post by:
Hi guys, I want to write a database application, which I later want to sell. Now I am looking for a nice, little database which would have to fullfil these requirements: * Either free or low...
24
by: John | last post by:
I know this is a very fundamental question. I am still quite confused if the program call stack stack should always grows upwards from the bottom, or the opposite, or doesn't matter?? That means...
18
by: Zytan | last post by:
I want the same function to be run whether you press Enter or double click the listbox. It seems really verbose to write both handlers to both events everytime, even if they both call the same...
8
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - When should I use eval? ----------------------------------------------------------------------- The ` eval() `...
2
by: JohnnyBR | last post by:
A particular talent competition has 5 judges, each of whom awards a score between 0 and 10 to each performer. Fractional scores, such as 8.3, are allowed. A performer's final score is determined by...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.