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,
Attached is a macro which opens any file in the 'To Import' folder, it then runs a macro called 'disposed' which formats it. Then in another workbook the 'data' sheet is copied...
Hi All-
I have a small vba script that opens and closes a workbook behind the scenes. I need to let the workbook stay open for a few seconds at most to allow for another workbook to update...
I have written the following vba macro to save a particular worksheet as a separate workbook.
Private Sub ExportRptCommandButton_Click()
Dim fName As String, FileNm As String
'GET THE...
I'm trying to insert a value in an Excel 2007 worksheet cell from a VB.NET 2008 application. It looks like the value is being written into the cell correctly, however all the formulas that re...
Hello Experts,
I have a range of numbers in cells A1:A10, and I would like a macro to start in A1, moving down the column and testing the value of each cell, stopping at the first blank cell....
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 ...
I would like to know how to embed an images (jpg) into cells in Excel 2000. Each row will need to have a different product image embeded. I don't want to do Insert>picture>from file, since usi...
Hi
Cell A1 has text " **1.0 " I want to use this regular expression \*\*\d.\d to remove the **1.0 is there a function that will allow me to do that.
Something like =removematch(A1,\*\*...
I am having trouble with an Excel Macro. I need to save the current file with the same name in it's current directory. I also need to save the file as *.xml with the same name in a second dire...
Hi, I need to know how many working days have gone through specific dates but do not include Saturday or Sunday, for example for July 2005:
A1 Beginning Date
A2 Todays Date
Answer for...
Experts, I would like to create a list in a UserForm using Excel VBA that fulfills the following requirements:
a) allow multiple selections,
b) only allow items contained within existing l...
I need to know which formula in Excel to use to calculate the Standard Deviation from a Frequency Distribution.
Values Frequency
0.00-0.49 31
0.50-0.99 ...
I have a sub (see below) that is receiving the following error. This sub was working fine 2 hours ago. Can anyone help?
Run-time error '438': Object doesn't support this property or method
...
Hello,
I have an Excel spreadsheet that I need to convert into an ASCII text file where each column needs to be set at a specific width (column A is position 1-4, column B is position 5-6, co...
I am trying to communicate with a device connected to my PC using an RS232 serial comm port. I am familiar with Visual Basic for Applications with Excel. I understand that a control (MSComm)...
I have a range of cells in and Excel 2007 workbook. I would like to use a drop-down list to select from the range but have the ability to edit the value once selected. For example, I may sel...
Experts:
Is there a date difference function that returns the number of years, months, and days? I've been searching for a long time for something that would give me the correct answer.
...
I have a workbook and I want to delete the entire row if the word "Program" appears in the text string. In column A there are thousands of rows of data. I want to delete the entire row if the ...
I have to pull info out of an access database and place it in an excel file according to certain formats. I have multiple queries which pull the data and then it is placed in a new excel shee...
I have a client who has requested an Excel.xls file to be password protected when opened. This file contains confidential information so when the user attempts to open the file they would like...
I need to create a Bar graph based on various Confiedence interval values.....in excel.... and I aint got a clue....
My Excel file couldn't be saved. When I press 'save', it will pop up an error message:"Document Not Saved". My other Excel files are ok.
Experts,
In the attached workbook (EE-FROM_DATABASE-03-2008_NB.xls) I have a data import from a database on worksheet (DATA). What I want to do is create some code in VBA to copy most cells...
