New to VB

New to VB

• JuniorBR

  This reply has nothing to do with my question.
  

• wwwillem

  My serious advice is, can you find another job

  Apart from that, I guess you need to break it down into logical steps. For example, look in your books, and online for examples of how to find a value in a cell, and how to move that value into another cell. The more you break it down, the easier it will be to approach the steps involved, and to find help for them. Obviously, keep asking here, I'm more saying that asking a specific question will get lots more answers than a broad overview 'how do I solve the whole problem' type question.

  The other option in all of this, do you get Excel spreadsheets in an XML format I believe that Excel can save as XML nowadays If so, then you could look into using a XSLT to move data into the spread sheet. Although, the learning curve may be a bit steep there, too.

  I hate to say it, but if it was me, I'd post the job on www.rentacoder.com, get someone else to do it for $50 or so, and spend the next four weeks looking for another job. For a team of non programmers to all be given programming tasks is just plain dumb. That's like asking me to fix someone's car, I just plain would have no idea.

  
  
  

• Adamus Turner

  Selea,

     I am of the understanding Microsoft abandoned Visual Basic 6, and I don't see how they didn't unplug VBA at the same time.   Since this is the age of abandonment where we throw out a working viable infrastructure for a new piece of eye candy - that at the end of the day, STILL delviers the EXACT same business use case potential with the same amount of over paid lazy bitheads all complaining about not being paid enough...

   

  Why not consider following this new wave of bright ideas from Microsoft.

  Try Abandonment.   Abandon what you have that is working for what you think will be better in the long run at the expense of complete alienation of your own self in relationship to your wants versus your needs.

  In other words,  perhaps see if Microsoft can suck down what they serve up, try abandoning them in entirety for a 'better solution'.

  Maybe you could go into selling a 3rd party MSIL obfuscation tool so all your hard work won't be so easily reverse engineered.

  Wait, I know,  maybe you could say - hey, this common runtime for Visual Basic is the wave of the future, gee, that was a real good idea the VB team came up with,  let's pay VB due rights to success and abandon Visual Basic, hell, let's even drop it out of our user forums and send a real message of future complacency in the practices of abandonment and resell it as Common Language Runtime and mandate all language be dependent on it.

  My advice

  Fock MS and take up pottery,  protocol for designing and making a vase hasn't changed over 5,000 years.  Why re-invent the wheel eh

  Paindeeer

   

   

  
  

• DenMori

  Thanks. I'll figure it out. I feel a bit overwelmed at the moment, but I get it done. I always do.

  Melissa

  
  

• Windows Vista and DAO

  Selea, good luck on the project...

  follow cgraus advice and if you go for it use the forum. Plenty people in here will keep you pointed in the right direction.

  I also find that if your not sure about a piece of code but you know how to do it through Excel's front end then Record a Macro. This will give you the code you need, however don't rely on the recorded Macro to work all the time for every scenario. Use it as a guideline and a means to find the right function to call.

  
  
  

• Konstantin Meleshenko MSFT

  I guess the number one question would be, why have you been given this task It hardly sounds fair...

  I would suspect that you need to be more specific about what you want to do. You say the invoices come from your printing service - does that mean they are also provided in Excel format Or some other format You want to create a history of invoices in a master spread sheet Are you perhaps using the wrong tool for the job in the first place

  
  
  

• Dinesh Singh Bisht

  Hi Melissa,

  You might take a look at the VBA resources on http://www.microsoft.com/europe/vba/resources for any examples similar to what you want to do.

  -brenda (ISV BuUddy Team)

  
  
  

• Kishor Kurapati

  cgraus wrote:

  I guess the number one question would be, why have you been given this task It hardly sounds fair...

  cgraus, my company hands out projects like this all the time. Mostly to mechanical engineering graduates. It's very much a "buy them a book" approach to software development. Ever seen someone with a VB.NET book sit and code VBA

  "Well it's Visual Basic isn't it "

  
  
  

• CliffInDC

  Good luck. Sincerely.

  
  
  

• Ken Schlobohm

  Yeah, I got the feeling that the books were perhaps not even VBA ones.

  I know it goes on, but it's still wrong. It also reflects a growing trend IMO for businesses to think that coding is a trivial thing to do, which is not good for any of us.

  
  
  

• PCIGUY

  Everyone in my department has been given a project. This is mine.

  We receive invoices from our print vender once a month. We get one for each of our customers (5 currently) in an Excel spreadsheet. We use these to manually update our master invoice. I'm supposed to automate this process with VB. I have macros to format the invoices. I just need to figure out how to get the formatted invoices to update our master invoice automatically. I need it to compare corp id's and column headings and copy data from the received invoices to the master. I won't be able to take a VB class till this summer, but I have 4 weeks to complete this project.

  Others have been given projects in Access, Exceed, etc. None of us are programmers, but we are doing the best we can.

  Thank you for responding.

  Melissa

  
  
• New to VB