Several issues I'm hoping some smarty pants can help with :)
I am importing data from a text file that the user will refresh on open.
There are 5 columns to the right of the imported data used for calculated
fields.

I need to allow the user to select a folder so that .xls files meeting a
specific file naming convention can be opened.   I know how to create an
array of workbooks based upon that naming convention, but I've not been
successful in allowing the user to select a folder.   How ...

I have a seemingly hard to find request....
I want to find or get guidance on code that will paste previously
copied data to a specified cell (not a currently active.
Essentially, I've create macros (and assigned a button form) in other

Hi all...
I am having a strange issue with Excel v9.0.6926 SP3.
I make changes to a UserForm's design (that I created when using Excel
2003 - just information in case this could be the cause) within my

Can anyone help
I have a list of numbers with an associated date in two coulmns which are
NOT in date order. I wish to add up the numbers in date order creating a
cumulative total to be recorderd in a third cell on the line of the latest

Hi, I have some simple code (below) that works most of the time.
Unfortunately, if there is an error in the data in the spreadsheet, this can
cause some of the values in the spreadsheet to go N/A, 'Not a value', Div/0
or something similar. The result is not just that the macro ...

I want my user to enter the time of day into an input box.
My code looks like this:
  Dim CollectionTime As Date
  CollectionTime = _

Im trying to write a simple macro that determines the bottom end of a
collumn of data, and then down drops down one more row to a blank space.  
This would be useful for a situation when you want to tack on more info in a
collumn where you dont necessarily know where the previous ...

hi!!
i keep getting this error in vb!!!
worksheetCount = objExcel.Worksheets.Count=== this is my code...
the error i get is Run Time error 1004--- Application  Defined Error

Hi, I need a macro to run at 5 pm daily to clear out the days notes on a
shared workbook.  Each worker has a notation page, cell B6.  All of them are
B6, all B6 cells except for the front page called "Note Tracker" need
cleared.  Should I run an OnTime macro to clear these, and ...

I'm trying to send data from an excel (2007) spreadsheet to an IE (6) web
form.
Can someone suggest the best method possible?
I've tried sendkeys, and it only works sometimes.

I try to populate a 2 dims array in VBA with a 2 dims created in
DLL(via VB6). Declaring in Vb6 the array as public is rejected.
Help please
Avi

Want to do something like:
arrayvar = ("alpha","beta","delta")
For B = A(1) to A(3)
......

I have an external app that is opening Excel.  When Excel loads none
of the add-ins are being loaded with it.  The add-ins are listed and
checked in the add-in installation box.  However none of the add-in
code seems to have activated (i.e. no custom menus are loading).  None

I have a userform with couple of hundreds textboxes,spinbuttons and stuff...
I recently added a few more and I get this error when I try to show the form.
Compile Error - Out of Memory
Anyway can I get around this one?