|
Cell Auto Code
Hello. I have a little formula/code of sorts that I am trying to tweak. The
code basically places an "X'" in a cell no matter what the user types into
the cell. Work great by the way! Now I want to make it even more difficult!!!
lol...
What I am trying to do is get this code to basically place an "X" in cell
G25, an "L" in cell G26, a "M" in cell G27, etc...no matter what a user might
...
|
2 |
12/31/2008 3:03:00 AM |
|
|
Confused by CDbl behaviour
Hi,
Can someone please tell me why this does not work (it throws up a type
mismatch):
Sub Cost_Update()
Dim dMitCost As Double
dMitCost = (CDbl(FmRiskCost.TextBox9.Value) +
CDbl_(FmRiskCost.TextBox10.Value) + CDbl(FmRiskCost.TextBox11.Value) +
CDbl_(FmRiskCost.TextBox12.Value) + CDbl(FmRiskCost.TextBox13.Value))_
FmRiskCost.TextBox23.Value = dMitCost
End
...
|
8 |
12/31/2008 1:23:16 AM |
|
|
Linkk Workbk to data source
How do I create tables in Excel WkBook across multiple worksheet and connect
to a database source (MSSQL). From there I want to continously generate
update query monthly based on certain criteria(Queries).
Please I am a novice in this. Any step by step instruction will do. Or Link
to useful information as to get this done.
THanks...
|
1 |
12/31/2008 1:11:01 AM |
|
|
SUMIFS with relative reference r1c1
Have to SUMIFS some columns in a Grand Total row, which in the following
example happens to be on row 53, but could end up in any row from 10 to 500.
Have designated FinalRow as whatever the Grand Total row is, -1.
Would like it to calc "sumifs columns b thru v, from row 6 down to FinalRow
[or from FinalRow up to row 6], as long as any row in column a contains the
text "total".
At p...
|
4 |
12/31/2008 1:10:37 AM |
|
|
user editing cell when code runs
Hello
I'm not sure about the terminology, but my situation is that a user is in
the middle of editing the contents of a cell and then clicks on a toolbar
button, and interacts with a custom form - causing the program to either
write the "open" cell (the cell currently being edited) or create a new sheet
in the workbook. In either case the operation throws an exception.
Is there a co...
|
7 |
12/31/2008 1:09:23 AM |
|
|
Writing a named range to SQL Server 2000 table
I have a named range called BPEntry that I would like to write to SQL Server
2000 on the click of a button..
The range has the fields EntryDate, SBP, DBP, HR
The table in SQL 2000 has the same fields and a couple of extra ones that I
would like to adjust the insert using VBA with my own SQL String. After it
writes it to SQL Server as set of values with a Serial number, I will clear
...
|
1 |
12/30/2008 11:40:00 PM |
|
|
Indirect question
I want range ("CB4:CN289") to indirectly reference Range ("BL4:BX289")
As far as I can see I have to enter the indirect command into each cell
individually. Is there an obvious way of mass producing and doing it in one
go?
Many thanks
...
|
3 |
12/30/2008 10:54:15 PM |
|
|
Each Stakeholder of A File Must Select His Name (Only)
I am imaging this situation: There is a file (shared or non-shared) ,
to which several users have access. These users enter data in their
responsible areas.What I would like to see is that after an user
enters the data, he types or selects from a dropdown box his name, so
we all know who makes the entry. The problem is that if he has to
select a name from a dropdown box, how to avoid selectin...
|
2 |
12/30/2008 9:58:43 PM |
|
|
copy content from Multiple file to one file
Hi,
I currently have a folder which contains close to 800+ excel files. I need
to copy a range of cells from each of these files to another excel file. I'm
writing a Macro to do this, however It's not working.
I was wondering if someone could go through my code and let me know where I
made a mistake.
Thanks,
Prash
***************************************************
The Code
**...
|
3 |
12/30/2008 9:50:44 PM |
|
|
VBA + Excel Performance: your feedback requested
Hello all - The Excel development team is currently investigating a number
of scenarios where VBA macros take longer to run in Excel 2007 than in
earlier versions (i.e. Excel 2003).
I am looking for folks who believe they have run into a VBA performance
slowdown and who would be willing to share their code/workbook/steps to
reproduce the issue. Given the enormous variety of solutions p...
|
1 |
12/30/2008 8:14:33 PM |
|
|
Rename new worksheet with the current date
I have a workbook that I do not use every day, but when I use it I need to
copy the contents of the last sheet to a new worksheet and then name the new
sheet with the current date. What I have now is very simple, since the
worksheet I want to copy is always the active sheet I just used the following:
ActiveSheet.Copy After:=ActiveSheet
Now I want to name the new sheet whatever the c...
|
6 |
12/30/2008 7:51:33 PM |
|
|
how do i show non-unique records (duplicates) using advanced filte
i want to show the duplicates and hide the unique records. advanced filter
works great when selecting "unique records only", but i want the opposite
result. any ideas on how to accomplish this using the filter or VBA would be
great!
Thanks!...
|
4 |
12/30/2008 7:42:50 PM |
|
|
Can you do user defined Menu Macros in Excel like in Lotus?
A short example would be wonderful if possiable
or point me to a list excel vs Lotus (I am not a programmer)...
|
2 |
12/30/2008 7:28:28 PM |
|
|
How can I automatically POST in a Public Folder?
I have an Excel sheet that I want to Post in a Public Folder. How can this
be done with a macro? I would like the macro to insert the current month
into the subject line of the post.
--
Thanks!
...
|
1 |
12/30/2008 7:02:51 PM |
|
|
How can I automatically format a column as it is imported?
I have a macro which automatically imports the contents of a .csv file. The
data which is imported into Coulmn A is a date but it is not in the format
that we want. When it is imported, it looks like this...
20081223155307
We want it to look like this...
12/23/08
We currently have the column format set as Numeric without decimal places.
Can we set the column to a Date format an...
|
7 |
12/30/2008 6:59:10 PM |
|
|
Last Day of the Latest Month Syntax problem
From a column of sorted dates in A
I need to generate the Month columns headers in the YYMM format,
First : I need to find the Earliest and Latest dates in Column A
Second : From the above, I need retrieve the Last day of the Latest
Month.
I have a syntax problem there in assigning date to
variable and variable to cell
'
'Sub MonthCostDistrib()
Dim LastRow As Long
Dim rD...
|
6 |
12/30/2008 6:58:19 PM |
|
|
Enabling add-in causes excel to crash
I am using Excel 2007...and saving everything as Office Excel 97-2003
Worksheet. I created an Excel 97-2003 Add-in called CompFxnsAddIn.xla
which contains the code at the bottom of this post.
The code seems to work fine...giving me the expected values, etc (they
are intended to be used on a timeseries in a single column). Anyway,
now everytime I open the file, I get the following notifica...
|
3 |
12/30/2008 6:42:51 PM |
|
|
Volatile UDF evaluates to zero on opening workbook until I press F9 or change a cell
I wrote a UDF that wasn't recalculating when I needed it to. I added
Application.Volatile at the beginning of the code and that fixed it
except...when I saved the file, all the values turned to zeroes. I
didn't understand why but I added Workbooks.Application.Calculate to
my Workbook_BeforeSave event procedure and that fixed it. Then I
closed the workbook and reopened it, and the cells wit...
|
4 |
12/30/2008 6:20:38 PM |
|
|
Save Error Message
I am writing a 3rd party program (OpenInSight MultiValue Database) and I am
using OLE to populate an Excel 2000 file. When I send the Save command, I
get a Microsoft Excel error message:
A file named 'RESUME.XLW' already exists in this location. Do you want to
replace it? - Yes, No, Cancel
There is no RESUME.XLW on the entire hard drive (Yes, I checked).
Is there any way to get rid of th...
|
2 |
12/30/2008 6:17:14 PM |
|
|
Writing value to another file
I have this in code:
Range("OpenFile1.xls!A1").Value = "First Option"
This writes "First Option" to Sheet1 of the file I think becuase that is the
active sheet. "OpenFile1.xls" is open.
How can I write "First Option" to "OpenFile1.xls" Sheet2 A1. I dont want to
have to actually activate the window but just write to it.
Thank you,
Steven...
|
3 |
12/30/2008 5:44:01 PM |
|
|
File or Window is open
Is there a way to tell if a file or window name is open in the current
session of excel and not use the full path. I have seen a routine written of
IsFileOpen()
If IsFileOpen("C:\History\Ac01\File001.xls") Then
'Do this
End If
Function IsFileOpen(filename As String)
Dim filenum As Integer, errnum As Integer
On Error Resume Next ' Turn error checking off.
filenum ...
|
3 |
12/30/2008 5:42:23 PM |
|
|
Over My Head Print Code
I am probably overthinking this and making it more complicated than it really
is and now have myself really confused. I have a sheet to track project costs
by the day that is fixed at 47 rows, however, the number of colums is
dependent on the job length. I would like to repeat columns A thru H on each
sheet printed out and have the sheets print out 7 days per sheet (2 columns
required fo...
|
5 |
12/30/2008 5:39:03 PM |
|
|
how do i calcalate hours above 7am and >19:00am leaving 12 hrs
how do i calcalate hours above 7am and below 19:00am leaving 12 hrs on a %
basis.
So if i work 06:30 and finsih at 18:30 that is 30 minutes as a % rate
Also if i work 14:00 and finish at 2am so thats is 7hours % rate...
|
3 |
12/30/2008 5:39:02 PM |
|
|
Project is unviewable - for specialists
Hi there,
I downloaded an excel file having a few very interesting macros attached.
The problem was that the VBA project was password protected. So I used the
"Hex method" for replacing the password, but when I try to access the VBA
project, instead of dialog box for password input, I receive the message
"Project is unviewable". 2 additional comments:
- the file is not shared;
- I d...
|
10 |
12/30/2008 5:16:41 PM |
|
|
Transpose Text to Columns
I have 9 sheets with over 9000 rows per sheet filled with data that needs to
be moved into Access. So I need to transpose the multiple sets of 7 rows into
organized columns in another sheet appending each sheet into one.
Original Data looks like this:
(these are in 2 column sets with title in first, data in second -- columns
A-G)
(a) (b) (c) (d) (e) ...
|
3 |
12/30/2008 4:52:01 PM |