routines

As I trying to get my coding better, I've been searching for advice regarding which is a better technique. More Modules, each with a unique name referring to the (perhaps) one to five related modules, or fewer modules with more routines in each module. I have figured out it's easier to have a...

Hi, What is the code for activating an already opened session of IE? And can I identify this as a variable name that I can call from different routines? Thanks, Bobby

Hi, I'm struggling to find the answer.. probably because the way I'm wording the search. I have a Main Sub Routine which in turn Calls various smaller Sub Routines. in the 1st Sub I assign a name to the active 'main' workbook eg. Dim workbooknamemain As String workbooknamemain =...

How do I carry a variable forward so that its value can be used in another sub routine? I have several routines that are identical except for the column they're affecting. Just before each routine comes to an end, I assign a value to a variable (the same variable exists in all routines) and I...

How can I recover the wind that allows you to write Sub() routines. I dod someting and it disappeared?

I have a Module that has worked for almost a year but is now not working. I've had to rebuild the worksheet because of a un-delete-able style issue that was causing confusion on the part of the end users. So I copied this module into the new workbook. Here's a sample: Sub VehInv() cntYear...

Hello, i want to know how it is possible to have an automated routine that will archive the workbook and will create a new workbook ready for entering the new data. Any method of doing this would be greatly appreciated! Thanks!