How to set TIME condition for if-statement?
Sat, 20 Mar 2010 19:23:01 -0700
I would like to process following code if time is between 12:30PM and 2:30PM.
Does anyone have any suggestions on how to code this if-statement in VBA
coding for Excel's macro?
Thanks in advance for any suggestions
Eric
if time is between 12:30PM and 2:30PM then
(
Coding
); ...
|
Manipulating Table data
Sat, 20 Mar 2010 17:53:01 -0700
Hello,
I am hoping to work out a method to transform a data table into a running
list.
The table has identifiers in column A, and product weights in a dynamic
number of columns to the right. i.e. Cols B-M. I would like to manipulate
the table into a running list of three columns
Col A = Value of ID @ r ...
|
How to code it in macro?
Sat, 20 Mar 2010 17:11:01 -0700
Does anyone have any suggestions on how to code it in macro?
If cell A1 = B1 under ABC sheet on DEF.xls file, then process following
code, then nothing.
Does anyone have any suggestions on how to code and retrieve value from this
specific cells?
Thanks in advance for any suggestions
Eric ...
|
Sort a Column
Sat, 20 Mar 2010 16:59:01 -0700
Hi,
This feels like one of those things that is probably really easy but my VBA
obviously isn't up to the job :-(
On sheet "A" I have a column containing a list of names.
On sheet "B" I have the same list of names (not necessarily in the same
order) on a different sheet in the same workbook that has a loa ...
|
How to code macro to disconnect internet connection?
Sat, 20 Mar 2010 16:52:01 -0700
Does anyone have any suggestions on how to code macro to disconnect internet
connect for macro?
I would like to add a code at the end of macro to disconnect internet
connection, does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric ...
|
Prevent cursor/focus from moving
Sat, 20 Mar 2010 13:42:11 -0700 (PDT)
Create a small Userform. Put two TextBoxes in it. Add the following
code.
Private Sub UserForm_Initialize()
TextBox1.Value = "0.00"
TextBox2.Value = "0.00"
End Sub
Private Sub TextBox1_KeyDown(ByVal KeyCode _
As MSForms.ReturnInteger, _
ByVal Shift As Integer)
...
|
Ribbon Customisation
Sat, 20 Mar 2010 19:41:17 -0000
Hi All,
I just wanted to know if its possible to to add custom controls to the
ribbon by using VBA alone? And what object reference to I need to add, to to
this?
Any help will be very much appreciated!
...
|
|
|
Extract last name from Last, First
Sat, 20 Mar 2010 11:42:01 -0700
I know this has to be a common question, but I can't find the answer...
Using VBA, I need to extract the last name from the format:
Last, First
For example:
the cell contents extract to a variable the value of
JONES, AMY JONES
ADAMS, HARRY ...
|
Build a String Sort Key, sort a 2 dimen array Mar20
Sat, 20 Mar 2010 10:38:01 -0700
Hi All, Mar20
I'm building a utility function that sorts the rows of a 2 dimen
array on any up to all of its columns, (ascending or descending by wanted
column.) My 'first' version is working fine.
I'm enhancing the first version which handled only positive integer
and long da ...
|
odbc connection lost
Sat, 20 Mar 2010 10:32:01 -0700
while reading excel file I am getting the following error
[Microsoft][ODBC Excel Driver] The connection for viewing your linked
Microsoft Excel worksheet was lost
--
Trioum ...
|
