VBA EXCEL COPY BETWEEN WORKBOOKS
I am trying to consolidate from multiple Excel workbooks loaded individually
into a single master spreadsheet via VBA code.
The code fragment following works if I reference within the workbook(2), but

Ok heres the thing...I can manage to get Excel to save a file as
"whatever.whateverextension" but I am wondering...it is possible to
set an attribute to the "Save As" macro to save as a hidden file in
Windows, so someone couldn't see it?

i am using 2 variables, tmpWt and tmpTime. weight is in pounds, time is in
minutes.
they are both dimmed as double
the 2 variables always have to correct values, yet when i try to divide the

EXCEL 2003
Rows = 165
Goal: Run a macro that will 'check' if a cell is empty (C5). If so,
copy previous cell (C4) into a different cell C11. IF not empty

Interesting problem...How do I go about doing this? I need Excel to
understand the value of capitalized letters and not automatically
replace based on its value... Take a look at code below.
Sub Eng_to_code

On a particular WS I have to custom views set up.  I want to put a
button
on the sheet to Toggle between the 2 views.
Off google I found the below (from Chip Pearson):

I have spreadsheets which vary in number of rows.  I want to put a
border around all the records in column b starting at row 2 and to the
bottom of the sheet.  Then I want to put another border around column
c through column o also starting at row 2.   The columns will not ever

To count all of the characters (including spaces) in a UserForm Textbox, I
can use:
   Len(UserForm1.DayList.Text)
Is there a way to just count the number of characters that are in the first

I have a 3 column ListBox with a growing list of clients.  I have a way to
delete them if necessary.  What I now need is a way to pull their profile
(based on a condition) to Sheet1 or Sheet2.  I select the name in the
ListBox, which corresponds to one row and columns A:AP in ...

I use the following code to delete cells from the Active Worksheet,
Range("A2", Cells(Rows.Count, "A")).Clear
this works fine but when I try to delete cells from a different sheet in my
Workbook I get 'Application-defined or Object-defined Error'.

How do I modify this code to place the selected names from a MultiSelect
listbox starting in cell A73 not A1?
Sub DropButton_Click()
Dim i As Long, j As Long

I have a spreadsheet that has data in row 4, colums B thru G.   There are
formulas in these cells that get numbers from other cells (if applicable -
sometimes these cells are blank).  Sometimes the cells in the row might only
contain numbers from  B4 to D4.  Other times the ...

I have tried all versions of Mr. Erlandsen's examples (Import data from a
closed workbook using ADO) and found none that will work in my case.
1- the workbooks I have to import from contain one single sheet with a named
range that incudes all the data but with no column (fields ...

How can I modify this macro to default to the last label typed for
this input box?  I only need to be able to override it, so I don't
need to re type it every time I run it.
Sub header()

I need to combine two text cells in Excel into one character string with
filler dot characters in the middle to produce a character string of a fixed
length in inches that will end up in a Microsoft Word table.   The fonts are
proportional and the same in both Excel and the Word ...