I need to import a csv file into excel but the file is way too big to
load onto a single speadsheet.  How would have excel import the file,
then once a sheet is full, create a new sheet and continue the import?

Hello folks..
I'm trying to get text from a html form, and store the information into
a variant, or just place the information as text in a cell...
Could anybody help me?

I am trying to get a table from internet site.  This particular site
has password protection.  My question is the new web query wizard does
not allow me to write my password anywhere.  How can I do this, please
help.

Hi All ~
Need to separate this kind of data into 3 fields
Los Angeles, CA 90038
I found this bit of code which ALMOST does what i need it to

I need to write a macro to do some math. Cell A has a date lets say 5/15/80,
Cell G has a date  lets say 5/15/06, Cell F has the eqation G-6574. If Cell A

Dim i As Integer

I'm trying to use code to force the entire column to be currency.  I also
have another column I'm trying to force to text, any help is appreciated

Looking for an elegant way to take a spreadsheet range and update certain
fields in an Access table.  I'm sure I could loop through the rows and create
insert statements, but was wondering if there was something equivalent to the
oppisite of CopyFromRecordset, where an object ...

***Sorry I'm reposting because I placed it in the wrong category****
I have a macro that goes into a folder, grabs all excel documents and
combines into one workbook. I want to move that particular file after its
combined to the master file. Basically, I have two folders

Hi All........
I am trying to use this code but on some files I get a VB error on the "Last
Save Time" line........how may I cause a return of "Not available" instead of
the VB error?

I am familiar with what a recursive call is, but am still working on getting
good at them.
I'm trying to use the filesystemobject to create a directory, which may be
several levels down from the existing directories.

I need some guidance on how to handle a multi-line text file import to
excel.
I have a multi-line text file i am attempting to parse into Excel2003.
Here is an example of the file:

I need help,
This is my VBA macro
Sub Macro5()
Dim mtchValue As Variant

I use the following code to Cause the first (1) letter of an entry i
column C to be Upper case.
Can I modify it to force the first Two (2) characters to be Upper cas
if in fact they are letters? Or do I need a whole new set of code?

I want to determine whether a string will fit into a column or now
(i.e. whether it needs to be wrapped or not).  I looked at the WrapText
property but that is only set when the cell is actually wrapped.
Is there a way to determine a "wrap necessary" or "will be wrapped"

I have been working all day on a worksheet, using design mode to create
some simple check boxes and hidden fields etc. All was going fine,
until just now! Whenever I open the worksheet, I get the error "macros
are disabled because the security level is set to high...". The