I have a small C# application where i need to export alot of numbers to excel from a listview in C#.
When export is done using spiro.Dataexport all the numbers are stored as text. I would l...
I need to build on a macro that will take data that I have copied and insert into the next available open cell in Column A on the next worksheet. saurabh726 has been gracious enough to help me...
Hi, I am using vlookup to retrieve data from a table with multiple fields that need to be considered as criteria. I have one field contains both values and blank cells. I want the formula t...
I think this is mainly that I am a newbie to VBA and am having problems with understanding how you set up and work with ranges, so any guidance would be wonderful.
I am setting up a macro f...
I would like to add CONCATENATE formula to a cell using VBA. I am able to add the formula but I want the surround each cell value with quotes.
This is what the input would look like
...
Hi,
I am using a combobox in a multisheet spreadsheet. The combobox is performing the same function on two specific sheets, offering the user a choice of Team (A - G) and Player No (1 to 8...
Hi Experts
Is there a way I can get a cell to flash under conditional format if so how is it achieved ?
thanks
excel_baby
Hi Experts
The code below has an array of names, "ArrayName" which is from "NoPiceNames" rangenamed from the excel sheet.
I would like to scroll through this array and on each iteration se...
Would anyone know a command button code that would be able to jump to a particular cell?
For instance I was just creating a worksheet and it would be beneficial to jump to a particular cel...
Good morning Experts,
With a list in column A which I want to use in a Data Validation dropdown I have a short macro (below) to automate the task. However I am having serious difficulty wit...
I am trying to use the listview API SendMessage to determine the number of selected items in the list.
I found some example code:
Private Declare Function SendMessage Lib "user32" Alias ...
Hi,
I have made a couple of rdlc reports with two images and a title field in the Page_Header.
Everything works fine except when the report is exported to Excel, for the images a couple
o...
i copy and pasted something from a report, into excel. All the numbers that i copied over seem to have a space after them. So i can't get the column to sum. There are several rows that i am...
Hi!
I have an excel worksheet that contain several column as a header. For example Company, Name , Email Address (or will be additional column like Description and Remarks). Basically I wan...
A program I use to connect to feed data to Excel works via a DDE link. There are several DDE links within my spreadsheet that I need to update every second. The command lines of the dde link a...
I have over a hundred text files in a folder, for this example, we use "D:\Data". I need to know what specific text files contain the multiple search terms I have placed in an Excel workbook. ...
I am developing an Excel workbook that can either be run in the normal way frm Explorer, or instantiated from an external application which then posts data into it. In the latter case, I need ...
How do I add a title to an existing chart that currnetly doesn't have a titile?
I want to use a cell that has the title.
This has been happening to me frequently with Excel 2007 - it never happened in previous versions.
When I enter a formula on one worksheet that references a cell in another worksheet (withi...
Hi All,
I am trying to login to a website using Excel VBA. I keep getting the following error message:
Run-time error '-2147417848 (80010108)':
Automation error
The object invoked has dis...
I have a MS Excel File that contains lots of formulas in it that have embedded links. I can open this file just fine on a PC running MS Office 2003. When I try to open the file on a PC runni...
I need a VBA that creates changes the cell fill color if the following scenarios occur.
1. Cell color = yellow if the value of that cell is greater than 24 hours and the value of adjacen...
Hello -
One of these days I'm going to have an epiphany about setting Excel objects and I'll feel a little less stupid for at least a day.
I am trying to load data to specific cells in a spr...
I have just installed Office 2007 Professional Plus on an XP SP3 workstation and the installation completed with no problems. However, when I open spreadsheets (in either 2003 or 2007 format)...
I am running Office 2007. When copying data to the clipboard from Access 2007 or Word 2007, the copy function works fine. When pasting into Excel, the paste function is disabled. I can, how...
