I have a long string in an excel cell (over 1200 characters), which is periodically altered programmatically. Excel cells cease to display characters above 1200~, which makes it impossible to...
I am sure that this has been answerd before but i cannot find the details. We are running a windows XP environment and our users RDP to the workstation and perform copy/paste within excel (an...
Is there an equivalent to the Step-1 parameter for a "for each" loop?
I'd like my loop to start from the last member of a collection and end with the first.
Thanks for your input,
Thomas
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. ...
I am using Microsoft Excel 2007. I have an excel workbook saved on my desktop that has a cell link to an excel workbook on my company's common drive. It is a "sumifs" equation, and it works ...
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...
When we create a Pivot Chart Report (with Pivot Table) without column items, just row items and data items, the column head will be 'total'.
And also, the label of Pivot Chart Legend is 'tot...
The attached spreadsheet attempts to graph the 'cumulative' hours for budgeted, actuals, and estimated to completion. I need a second pair of eyes, as one of my collegues insists that the the ...
I understand David Brett (a.k.a. brettjd) wrote an excellent utility for removing duplicates within Excel. but his original web site is gone, does anyone know where I can get a copy of this ut...
I'd like to loop through each cell. However, I notice VBA loops through all my cells in a table from left to right, then down. Can I loop through each cell vertically instead?
I ask because...
Good day Experts,
I have developed a VB script (Code Snippet below) that can gather information about all Installed MSI's from the remote or local PC (XP SP2) and display it in formatted Ex...
Hi,
(Before I start, worth pointing out that my excel skills are basic at best...but moving on) I have a spreadsheet which contains data from an out-of-comission dbase program we used to u...
Hi Guys,
Can you help. We have a large excel doc, with 20+worksheets. Each worksheet is several hundred lines. Is there a quick way to create a shortcut to certain cells within each work...
Hi
In Excel VBA I have a ListView control on my form
I need to add twenty columns.
What code do I use to add columns, column headers and show gridlines
How can I create two stacked columns, from two different but related data on the same chart?
For example, this data would have two stacked columns for Light and two for Dark, one column for...
When I export an Access database to Excel 2003 (format) the resulting Excel spreadsheet text fields have a hidden leading single quote.
I can't Find and Replace this single quote (Excel doe...
Is it possible to run an Access macro inside of excel using an ado connection?
Hey guys,
I'm using VBA in Excel 2003 to process some data and display some charts. It's all working well but on some charts, the datalabels are blocked by the bars of the chart itself. See...
Hi all,
background
excel 2007
question
i have a league table which is sent around the sales staff each week. i want to have a column showing a coloured arrow - green, up - red, down - ...
My list of contacts has all of the data in a single column like this:
LastName, Title FirstName
JobDescription
Employer
MailingAddress1
MailingAddress2
Telephone
Facsimile
EmailAddr...
I have a user (sales person) who wants to share an excel workbook with clients so that client can manipulate all fields except those in a hidden column.
She would prefer it be locked so as to...
I have a network with 8 systems. All are running XP Sp2 Pro. I have two systems that are opening one
single file very slowly using Excel 2003. All other systems open and use this file perfec...
MS Excel
Hello,
I see that I could save a worksheet as a comma separated (CSV) or tab separated text file.
But how could I export a worksheet to a text file with | (pipe) as a delimit...
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 ...
I have a spreadsheet which has something like this in column C;;
AB2
AB3, AB4, AB5, AB6
C1
C2
C3, C4, C5
and so on....
What I need is to split the cells that have more than one va...
