I am writing an Excel macro to save a file as *.xml. I need to keep the SaveAs path relative because my clients may store these files anywhere on a shared drive or web server. I am not sure of...
I need to save as a .csv but have the delimiter be a ; instead of the default comma. How do I do this?
I am wanting to use a formula in Excel that will calculate the difference, in percentage, between two times and either show it as an increase, or decrease..
The cells are formatted hh:mm:ss
...
Need to get distinct values sorted alphabetically from column using formula
e.g.:- I need to have values such as below in one of my excel column.
Item 2
Item 1
Item 2
Item 1
Item 2
Item...
Hello,
How would you insert checkboxes in an excel 2007 worksheet? I'm referring to a simple box that can be clicked to place a checkmark inside of it. For example, if you had a list of ite...
Hi,
I have a worksheet of about 450,000 records and its filtered using Microsoft excel 2007 autofilter. there is also an option in excel 2007 that can delete hidden rows but i have been runni...
In Excel VBA, I have Activesheet.Paste which works fine.
I need to use ActiveSheet.PasteSpecial paste:=xlValues, operation:=xlPasteSpecialOperationNone
What am I doing wrong?
What does DIM stand for? what purpose does it carry out?
and what do the following types of DIM mean/do?
Boolean
Integer
long
single
double
string
object
variant
I'm looking for a formula to calculate the number of the vacation days based on a seniority date and accrual rate. Below is the accrual rate. I would like to see the result in number of days...
My client has a Windows Server 2003 R2 hosting a shared directory. The share has an excel spreadsheet that everyone had "Write" access to through NTFS permissions. The top level share has Sh...
Hi Experts,
What is the Excel VBA to find a value in a cell and return the row and column of that cell?
Thanks
Hi.
How do I do this?
if object_exists(activeworkbook.sheets('A sheet name which may or may not exist')) then
' sheet exists
else
' sheet does not exist
end if
I know I can iter...
Hi,
Part of when I code and I add collections, I generally notice that an error 457 comes up stating that if a collection exists, you can't add it. Okay, so fine... which is why I'll end up...
Hi:
Is there an easy way to convert month names, say 'Jan', to 1 and 'Dec' to 12?
On a worksheet I have a ComboBox where users could chose a month and then a cell where users could key ...
I am copying an Excel sheet to word in Excel 2003 sp1.
If I use
AppWord.Selection.PasteSpecial Placement:=wdInLine, DataType:=wdPasteMetafilePicture
then I get exactly the same resul...
Although I labeled myself advanced in excel I'm not feeling that way right now. I simply cannot figure this out. My wife entered all the addresses for our Christmas Card list last year in a ...
Hi guys
I have a XLA file that someone else created that i want to edit to chaneg some stuff.
How do i go about editing the XLA file?
Is there a code to center the text in a range of cells. I have a macro that after it is ran the cells are left justified, but the formatting tool bar states that it is centered.
Is there a way to close Excel in Excel VBA.?? I currently have an excel file open which runs the workbook_open code. At the end of the code I want it to close Excel. I put the following cod...
I need an Excel formula that calculates interest on several different loan amounts on a daily basis ongoing. For example, one loan is in the amount of $12,400 and occurred 4/30/03. It is to ...
I have a workbook with mulitiple worksheets that have queries and the sheets are protected except for selected ranges. I need to update the queries everyday so unprotecting and refreshing each...
Hi,
I'm trying to work out the Compound Annual Growth Rate of company PROFITs.
The standard CAGR equation is:
=((end / start) ^ (1 / years) - 1)
That's fine where 'end' and 'start' are...
I need to come up with a weekly workplan template. Essentially, it should look like a weekly calendar (Mon - Fri) with hours from 8 to 5 for each day.
I'd like to include some automated f...
Gidday Experts,
I have a Project that is quite urgent, I need to import specific blocks of text from an ini file which is huge (currently 4000 lines and growing). The ini is used for an ap...
Hi experts,
I need to collapse a worksheet that consists of raw data roughly like follows
col1 | col2 | qty | amount
A | B | 1 | 2
A | B | 3 | 4
C | D ...
