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 also asked the question pertaining to 'Copy the resulting-from-conditional-format interior color of a cell to another cell'. This second question will work.
How can I copy the conditional ...
Hi all,
I have an excel file, where I have some special characters (like
áí) which I want to export to CSV file.
For the export I am using vba with the code bellow. If I export the data, ...
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...
I am importing financial data into a database with a file that is in .csv format. Currently, I have to open the .csv file that I converted from .xls in Notepad and then use the Find / Replace ...
Hello,
I have the following code which I would like to auto update a number of links when opening the work book. I would like the user not to be asked to update existing links.
At the m...
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!
Hi Experts
After playing around with MID, FIND et al, time to reach into bag of points to solve this one:
I have a text string in in A1 thru to Ax - x being anywhere up to 10,000 - (wit...
I would like to, from a vbscript file, open an Excel file, select a sheet, and insert a column. Easy enough, but not really :(.
Thanks.
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...
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,
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...
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. ...
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...
I am making a chart of server processes that run in different timezones. I need to make a master list of these processes in GMT. Can someone suggest how to do this in Excel?
The heading w...
I am dealing with the usual problem of Users inserting rows at the top and bottom limits of Excel Sum Formulas. I've tried using a hidden row at the top and the offset named range for the bot...
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...
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...
Hi
I have a 10 column ListBox and want to have column headers. I have set ColumnHeads to true and then
in columnWidths have 70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt;70 pt.
Ho...
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 3 buttons the build 3 different layers of 'protection' in an excel 2007 workbook, and one that completely locks the workbook. the code is working (just using xlVeryHidden and worksheet ...
