I have an excel file that needs to enter data into a web page. Click a button, wait for it to load the results and copy the results into excel.
Below is the source code for the site, and m...
Each month for our income statement monthly report I run 4 reports from our report writing program and save the results as 4 separate Excel files. The problem is, the company officers do not ...
I need to save as a .csv but have the delimiter be a ; instead of the default comma. How do I do this?
I need to copy the cell value from one file cell and paste that value to another file cell. I cannot copy the entire sheet or do a range. The source file has no consistant pattern. However,...
How do you fix this error?
Microsoft Visual Basic Run-Time Error '53': File not Found: ADTMSOADDIN.dll
Thanks, James
I have set the Macro security to LOW but am unable to access the Macro buttons on the Developers Tab since they are grayed out. I have searched and cannot find anything to tell me how to ena...
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...
I need to take a number in an Excel cell such as 10.40 and have it print on a check as Ten & 40/100. Is this possible in Excel 2007? Thanks!
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...
I need to be able to export the contents of a custom list in an excel sheet because the Out of the box functionality of "Export to Spreadsheet" is not working because of form authentication. ...
Hi,
While working with inputted data in my macro, I normally use Range(...).interior.colorindex to determine the shading for a particular cell. This time, I noticed that one of the cells is...
Is there an easier way to write the code below? Basically I'm trying to copy and paste values between workbooks by cell. See below VBA code
Sub IS_CopyValues()
Range("B8").Select
Wi...
Hi,
I have added the following formula in a pivot table to calculate growth rate in Year2 from Year1. I want the formula to return blank or N/A if the result is an error. However, my form...
Hello, I would like to count duplicate entries in a row and display the result in a seperate row / column...how would i do that?
E.G.
A | B
apple |
apple | 2
orang...
I have a subtotal in a cell calculating the prices of some products then I want to be able to add a 6.5 percent sales tax in a formula and calculate the grand total. So cell b13 should have a...
I have an on errror handler in Excel VBA of the form:
on error goto doa
...application code...
exit sub
doa:
MsgBox ("Application.MemoryUsed=" & Application.MemoryUsed)
...
I have column D on worksheet1 with 192 rows of data. I have column C on worksheet2 with 500 rows of data. I want to compare the data in worksheet2 column C to the data on worksheet1 column D b...
My Excel 2007 on Vista has started failing to open documents with the
error 'the system cannot find the file specified' when I double click on
an Excel file or Excel attachment. In Outlook...
We need an excel formula that will calculate a person's age in Days based on Date input in the spread sheet. For example, If we provide date of Birth (ex, may 1, 1934) and current date we wan...
What is the correct syntex to return the maximum numeric value in a list using VBA code? I have a spreadsheet with a single column list and would like to find the max value.
I have a Dell Inspiron laptop with Vista. Its about 1 1/2 years old. Starting yesterday, I can not open any selected Excel file -- 2007 .xlsx or 2003 xls -- from any file folder. I get the...
I need a macro, that selects ActiveCell.Offset(2, 0).Range("A1:B1"), and move it to ActiveCell.Offset(-2, 1) then selects ActiveCell.Offset(3, 0), and move it to the same row as the first, to ...
Every time one of my users tries to open Excel, Excel appears to try installing something then gives an error saying D:\pa561401.cab is missing. It only allows you to retry or cancel. I am n...
I have been looking for some time now for an Excel VBA version for calculating the total ISO Week count for a given month and year.
The function of days per month / 7 gives errors in some cas...
I have a few Lotus Notes files.
they are saved as .123 and we no longer have lotus installed.
is there a way to convert these files to be able to open them in excel without installing lo...
