|
Getting string from database table with VARCHAR(MAX) field
I'm working on a Excel 2003 VBA macro, trying and failing to retrieve a 5092
chars string from a SQL Server 2005 table with a Varchar(Max) field.
I can retrieve the string from a table with a Varchar(8000) field but not
from a Varchar(Max) field so there's something about such a field that Excel
doesn't like. But what? And is there a workaround?
I'm using an ADODB Recordset to get at ...
|
1 |
12/17/2008 2:52:15 PM |
|
|
Using ADO to get the first 5 fields horizontaly
Hi,
I know how to retieve data via ADO from access.
But can I
1) retrieve only the first 5 first records of the result of SQL
2) display them in Excel horizontaly (First in A1, second in B1, third in
B3...)
Many thanks,
Dan...
|
5 |
12/17/2008 2:24:57 PM |
|
|
Autofill to last cell in other column
How can I autofill the selected cell down in the selected column to the last
cell in the column to the right? I'd also like to exclude cells where the
cell to the right is null. Thank you very much....
|
3 |
12/17/2008 1:47:01 PM |
|
|
xlCellTypeBlanks, but no blank cells to delete
As part of importing a csv file, I have to correct some errors in the data.
What I had before worked OK, but this weeks version of the csv made my code
bomb out.
What I'm doing is deleting some blank cells. This week, there were no blank
cells in the csv!
This is what I have now:
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Delete Shift=xlToLeft
What I need is somet...
|
5 |
12/17/2008 12:00:05 PM |
|
|
Copy worksheet to another workbook
Hello
I've two worksheets (SheetA and SheetB) in one worklbook Workbook1;
My SheetA has a named range RangeSheetA
I SheetB i have a cell that computes =RangeSheetA * 100
I want to copy both sheets to another workbook, using VSTO .net and keep the
same range relation.
When i copy those sheets to a new workbook i break my range formula... in the
new SheetB the formula points to the range...
|
2 |
12/17/2008 11:56:05 AM |
|
|
Populate Combo Box Drop Down with Collection Data
Hey guys,
i previously put a post up about optimising a search feature in a piece of
VBA i was writting, but i have decided against this now as it would just take
up too much time. my new idea of getting around this problem is to take all
the values in a column, pick out 1 instance of each (Via a collection) and
then out put that collection to a drop down menu/Combo Box. this is the cod...
|
2 |
12/17/2008 11:27:34 AM |
|
|
Can Excel show OLE object created in DLL of VB6 ?
In VB6 I created a DLL with a form including an OLE object with Microsoft
excel chart.
When I call this DLL in Excel for showing form, OLE object is blank. It has
data, title etc, I can retrieve their values but cannot see them in OLE
object.
When I call same DLL in Power Point for showing form, OLE object works ok.
Is there any solution for Excel to see chart of OLE object ?
T...
|
14 |
12/17/2008 6:16:13 AM |
|
|
Mergining two pivot tables into one
Hello,
How does one merge two pivot tables into one? I have pivot table A and pivot
table B, which I want to merge it into pivot table C. I don't know the
code and the two pivot tables rows may vary. I am using Excel 2007 Any tips
will be appreciated. Thank you in advance.
...
|
1 |
12/17/2008 5:07:01 AM |
|
|
Rounding, List, Compare, Match
How do I compare two lists of figures to match the same item? The hard
part is that some figures are results of rounding, like 12345 vs 12346
vs 12343, they all have the same order number but the different data
sources make them look different.
Thanks in advance (always, I have learned a lot from you guys)...
|
2 |
12/17/2008 3:30:27 AM |
|
|
user to select path
Hi,
I'm using Excel 2003
I want to automate the importing of data from a .txt file, but the .txt file
won't always be in the same place.
When I do it manually, (with the macro recorder on), I use:
Data > Import External Data > Import Data
The 'Select Data Source' dialogue box appears, I find the file I want, hit
OK, then the 'Text Import Wizard' box comes up, etc.
Problem is, the m...
|
6 |
12/17/2008 1:51:01 AM |
|
|
resorting columns
I use data that is export from electrical test equipment in CSV
format. For years I have been developing vba code to manipulate this
data for analysis. One problem with the data is that it is grouped in
columns in a way that makes analysis and charting cumbersome. I
should have worked this out long ago but must have enjoyed the
struggle.
the data come in in columns like:
TYPE, DATE, DC...
|
7 |
12/17/2008 12:12:11 AM |
|
|
Missing code in macro
I recorded a macro but when I go into the editor a lot of the code is
missing. All I see are objects that are activated or selected (see below).
I am using Excel 2007 on WindowsXP. Does anyone know what is going on? I
never had this problem with Excel 2003.
Thanks in advance,
Lee
Sub Macro2()
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveSheet.ChartObjects("Chart 1")....
|
3 |
12/16/2008 11:44:11 PM |
|
|
Help with if and looping
Okay, I have a table that lists people, their age and then their work status.
Looks like this
Name Age Day 1 Day 2 Day 3
Joe 18 Reg Stock Sick
Jill 20 Leave OnCall Reg
Mack 18 Reg OnCall Stock
Now I have a roll up table that needs to show for each day how many 18 yrs
olds worked. So it would look like this
Age...
|
9 |
12/16/2008 11:33:02 PM |
|
|
SetFocus OLEobject by macro
Hi all, How can i SetFocus Microsoft Date and Time Picker control by
macro....
|
1 |
12/16/2008 10:25:16 PM |
|
|
calling other events from an initial event
hi everyone,
this is the last part of myproject thats eluding me i have tried several
variations/ combinations.the story so far. i have aworkbook with 3 worksheets
labelled MRoster, Depts 1&3, Depts 2&4.
the last 2 worksheets supply all the data to the MRoster by copying and
pasting each entry.
i have 3 peices of code which are event based and when run seperatley from
the worksheet work wit...
|
3 |
12/16/2008 10:21:26 PM |
|
|
Formatting
I am working on a spreadsheet where I am dealing with different medicines. I
have one column set up where it subtracts the actual cost from how much the
insurance pays. When the number is negative I have the cell formatted where
it becomes red with parenthesis.
My question is how can I set it up where the medicine also becomes red, when
the amount is a negative number besides manual...
|
9 |
12/16/2008 9:48:35 PM |
|
|
Couple of Macro Questions
Hi All,
Pretty new to this but been having a play with a simple macro that resets
column width, row depth, print settings etc of a spreadsheet that has been
exported from Access. A couple of questions:-
1. When I record a macro there used to be a stop button. Its gone!! I know I
can still stop the macro in the menu but what have I done to cause the stop
button to disappear and can I ...
|
6 |
12/16/2008 9:22:23 PM |
|
|
Skip hidden lines?
Hi,
Thanks to some super helpful people in this community, I've been able to do
some pretty cool stuff.
However, now I've had to modify the spreadsheet such that it has some hidden
rows in the midst of where this script places it's values. Is there a way
that it can "skip" hidden rows? (For instance, if rows 8 and 9 are hidden,
that it skips them, and copies values subsequent to 7 i...
|
5 |
12/16/2008 10:41:01 PM |
|
|
HOW CAN I DELETE A COLUMN BASED ON A CONDITION
I want to delete an entire column if it is EMPTY
Please help...
|
2 |
12/17/2008 12:55:14 AM |
|
|
How can I calculate peak minutes in Excel? (< 9:00 PM, weekdays)
I am looking for a formula in Excel that will calculate peak and non-peak
cell phone minutes. Non-peak hours are after 9:00 PM and on weekends.
Thank you,
...
|
3 |
12/17/2008 4:20:00 AM |
|
|
select entire row from a lookup
I need to allow users to make a selection from a dropdown then I want code to
select the entire row (in this instance A throuhg J), copy the row and paste
it into a customizable list.
Can anyone tell me how to select an entire row in that manner?
Thanks....
|
6 |
12/17/2008 7:49:25 AM |
|
|
This request for the very experts. Please reply at the earliest
here is a programme I found on net. I want to modify this programme so that
the project itself becomes unviewable. I can bet that I had one code before
which I have misplaced . That four to five liner use to just shut down the
project.
here sis the code found from net. It is not mine. I am not capable of such
sophisticated coding as of now. Thank you
Option Explicit
Const Break...
|
2 |
12/17/2008 8:16:40 AM |
|
|
Contents of Formula Bar overflow cells
Hi everyone,
I've got a workbook that users fill in scores against a number of questions
and it calculates scores for each sheet and then total score.
The worksheet has a number of macros to help with the calcs but most are
formulas on each of the sheets so I have used protect interface.
My problem is that the last sheet of the book has three columns to allow
users to make additiona...
|
5 |
12/17/2008 9:28:01 AM |
|
|
Remove duplicat entry w/out deleting cell
Hello all,
I'm looking to clear infomation from colums a-g when they are duplicates.
Data is listed from A1-N877.
Thanks
...
|
2 |
12/17/2008 12:15:34 PM |
|
|
Sum of each row.
Hi All,
i have created one xls file using c# Excel =
Microsoft.Office.Interop.Excel. DLL
and i have the data like below
A B C
1 100 20 30
2 101 20 31
3 102 20 35
4 103 20 35
5 104 20 ...
|
4 |
12/17/2008 1:39:57 PM |