|
Excel macro to insert a row
Hello,
I have a worksheet in which the parameters are arranged as per 'temp'.
I want to search the word temp and insert a complete row before it. Can
I get some help with the same?
...
|
1 |
29.09.2006 20:15:32 |
|
|
excel schema
Hello,
I am starting to look at the XSD stuff. I think that is what it is.
Where you can have XML data. and a schema. and it will popluate the excel
workbook from the xml.
Can you only populate data starting from row 1?
Or can you have a bunch of tables. a few on each sheet? and populate all
over the place?
thanks for any help
...
|
1 |
29.09.2006 19:43:39 |
|
|
Securing Budget Info in Shared Spreadsheet
I have a team budget with several worksheets. One sheet has salary info and I
need to keep the confidential (for me only). But I would like to let other
team members look at and edit other worksheets (ie costs for projects they're
managing). Can you recommend a method for this?
Last year, team members created their own project spreadsheets and then I
linked to their data. I also put a h...
|
4 |
29.09.2006 18:53:02 |
|
|
Generating random lognormal distribution
I'm trying to generate a random lognormal distribution of stock returns
where the mean return is 6.5% and the standard deviation is 20%.
Previously I've done this with a normal distribution, using
NORMINV(RAND(),mean,stddev). However, since stock returns tend to be
lognormally distributed I'd like to do a lognormal distribution. This
has turned out to be tricky. When I set up
LOGINV(RAND()...
|
4 |
29.09.2006 18:51:11 |
|
|
Beta 2 Technical Refresh
Hi, I have just loaded the Tecnical Refresh for MS Office Beta 2, however
when I try to open any spreadsheets (predominantly MS Office 2003 versions)
they get blocked by anti virus software - presumably linked to the Technical
refresh. These spreadsheets were accessable prior to the refresh.
Also trying to open Word documents and not recoginising the file where the
documents are stored
...
|
3 |
29.09.2006 18:43:01 |
|
|
Disable Search Function In Excel Worksheet
Hi Everybody, Can anyone help me in disabling search function (Control
+ F ) in Excel 2003?
...
|
2 |
29.09.2006 18:03:21 |
|
|
Formula Problem
I have an excel sheet that has almost 4000 data rows. I need to compare the
old sheet to the new sheet and if the part number is equal, I need it to
show me the discount from the old sheet in a column in the new sheet.
Here is the formula I came up with: =LOOKUP(A4,old!A4:A4000,old!H4:H4000)
This compares the A column in the new sheet with the A column in the old
sheet and then will re...
|
4 |
29.09.2006 18:03:02 |
|
|
Macro insert row copy value
In a range i desire insert a blank row and copy value if the value is
different from other range and repeat until last row.
es A2:A12
blu
yellow
orange
red
....
violet
C20: C last row or about 42000
blu
yellow
red
.....
violet
blu
orange
red
....
violet
Result :
blu
yellow
insert entire row copy orange
red
....
violet
blu
insert row copy yellow
orange
red
.......
|
1 |
29.09.2006 18:02:28 |
|
|
Rounding of amounts
I have a small retail store and am currently working on price changes. I
have an excel with all the calculated prices however I would like to round
all amounts to xx.x9. The 2nd decimal should always be 9.
Is there a way to do this in Excel? I checked the help file for anything
related to rounding but did not find any examples that would let me do the
rounding to 9.
Thanks for any help.
...
|
13 |
29.09.2006 18:02:22 |
|
|
excel 2000 question
I made a score sheet for a game. It's like a standard type grid or table
with squares.
Just to jazz it up, can it be made with circles instead of squares??
Thanks in advance,
Tim fm CT
...
|
5 |
29.09.2006 16:03:33 |
|
|
Updating cells using input boxes
Hi all
My problem is that i am using Input boxes to update a spreadsheet. I
have two coloums i want to update for two diffent type of information.
I am currently trying to use
Sub Compfees()
MyInput = InputBox("Enter Students Name")
Range("Sheet1!N20").End(xlDown).Offset(1, 0).Value = MyInput
MyInput = InputBox("Enter Fee")
Range("Sheet1!O20").End(xlDown).Offset(1, 0).Value =...
|
7 |
29.09.2006 15:13:54 |
|
|
Run-time error 424, Object required
I have the following code:
sub foo()
dim record as range
set record = Range("A" & ActiveCell.row & ":K" & ActiveCell.row)
record.select
Upload(record)
end sub
public sub Upload(ByRef r as Range)
.....
end sub
It keeps throwing out error: "run-time error 424, Object required",
what's wrong?
debug.print record.Address(external:=true) shows:
[Junk.xls]Sheet1!$...
|
7 |
29.09.2006 15:10:43 |
|
|
Replace with Macros
Hi folks,
I need to replace the "," by a "." in many cells to fit another country
decimal separation. My regional parameters use normally ",".
When I do it into Excel with the replace function it is ok and produce the
macro script :
Columns("J:J").Select
Selection.Replace What:=",", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchForm...
|
3 |
29.09.2006 14:10:33 |
|
|
Problem with CUSTOMDOCUMENTPROPERTIES
hallo zusammen
i have the following problem.
*******
Function xTest()
Dim xlApp As Excel.Application
Dim xlWbk As Excel.Workbook
Set xlWbk = GetObject("", "Excel.Sheet")
Set xlApp = xlWbk.Application
xlApp.Workbooks.Open ("C:\SP5Inst\EPP\Vorlagen\D_Standard")
xlWbk.CustomDocumentProperties("SP5DB").Value = CurrentDb.Name ---->
RUNTIME ERROR NR. 5
Call xlApp....
|
1 |
29.09.2006 14:05:20 |
|
|
UTF-8
Hi,
I am exporting data into Excel. The data is in UTF-8.
Excel seems to default to Ascii ? What can I do to get Excel to switch
encoding ?
Threads like this is all over the
place...http://www.webmasterworld.com/forum32/848.htm
But I can´t find a solution...
Anyone?
Regards
Oscar
...
|
1 |
29.09.2006 13:14:56 |
|
|
Compare cell contents
Hi,
I want to check if two cells do contain the same text, e.g. the same country name.
In case there is a difference I want to highlight the first cell with color red. something like
that.
I tried Conditional Formatting but it seems that the IF function only works for numbers, and not for
text.
If you do IF (A1=A2,.....) that does not work.
Anyone an idea how to compare text str...
|
3 |
29.09.2006 10:48:40 |
|
|
Best C# Book for VBA Programmers
I have been developing in Excel/VBA/SQL for 10+ years and have a little
VB.NET.
I have a pretty good - but certainly not great - understanding of OOD &
OOP.
I want to get into C# as more and more Jobs that I'm interested in are
looking for +/or expecting it but I have zero knowledge of C of any
flavour.
Given my background I would value all your thoughts on which is the
best book(s) to...
|
1 |
29.09.2006 09:51:54 |
|
|
Macro/Database question
I am using a macro to connect to the database and update a stored
procedure. I am able to disconnect the excel sheet from the database
manually by going to "data" in the menu, then "import external data",
then "data range properties", and unchecking "save query definition" in
the window. When I try to do this in my macro the macro does not
record my disconnecting the spreadsheet from the da...
|
2 |
29.09.2006 09:25:10 |
|
|
Macro to unprotect with password
Hi Excel People
I need a macro that when pressed asks for the passwork to unprotect a
cell/worsheet.
If possible i would then like another input box asking for a number
which it inserts into this cell then locks again.
any ideas?
Thanks
Brian
...
|
2 |
28.09.2006 23:30:14 |
|
|
Getting a bird's eye view of a spreadsheet's layout
Hi, All,
When I worked with Lotus 1-2-3 years ago, I found that it had a feature
which would show you, on one screen, all the cells in a spreadsheet
that had anything in them. I don't remember what it was called -- map,
layout, overview, or what. But it was invaluable when trying to
analyze a spreadsheet.
I'm now working with Excel 2003, and can't find anything similar.
Does anyone ...
|
3 |
28.09.2006 23:01:41 |
|
|
Fill in text from drop down list box in Excel
Hello,
I have created a drop down list box but the list is getting too big and
the user has to scroll down the list to select the data. Is there a
feature I can use to display the data that start with the same string.
For example: If I type "Be" in my box, the box could display the list
that start with "BE or Be".
I created the drop down list by using "Data", chose "Validation", and
cho...
|
3 |
28.09.2006 21:26:35 |
|
|
Help with amortization template
I have used the Amortization template but would like to adjust it so
that it automatically fills in the missing value. If I have 3 of the 4
values (note amount, term, payment and interest rate) it would fill in
the missing value and create an amortization table.
How do I do this? Thanks.
...
|
1 |
28.09.2006 21:08:40 |
|
|
Problem with Hyperlinks in Excel 2003
Recently my company has moved to office professional 2003. Since the
upgrade, I have experience 2 PC’s with the same issue. That is,
opening any new excel file, adding say http://www.microsoft.com to one
of the cells and then trying to click the hyperlink to view the http
content. Every attempt generates the following error. “Cannot locate
the internet server or proxy server.â€
Attemp...
|
2 |
28.09.2006 20:05:04 |
|
|
Chart Question
is it possible to create a chart, skipping columns or rows
I need to creat a chart using data from every other column and another
using data from about every 5th row
Any help appreciated
David Hopper...
|
3 |
28.09.2006 19:59:35 |
|
|
Not Enough System Resources... When Opening Excel
One of my users has just started getting this error when she opens Excel:
Not enought system resources to display completely.
She is opening Excel, not an Excel file, ie: new worksheet.
This is on XP with SP2 and all updates
Excel is version 2000 9.0.6923 SP 3
The only other apps running are Outlook 2000 and SnagIt, a screen capture
program.
I'm thinking the easiest resolution wi...
|
2 |
28.09.2006 18:35:33 |