Hi
it's getting frustrated.
I tried to use Excel 2007 to extract data from SQL Server 2008 R2.
But I think it fails to connect to the server.
>From Excel 2007, connection from data tab, I can access to the server
and get data. the following is the connection string I got from the
property.
Pro
Hi
The following code is a testing code before creating more codes..
when I run the code below, I'm getting an error message "Object
required".. then Comboschooltype.Text is highlighted..
I created a combo box (dropdown) and renamed it as ComboSchooltype
I thought it might has to do with name s
tting
** For Each may only iterate over a collection object or an
array ..**
On Sep 23, 8:14 pm, airen wrote:
> Dear markkim,
> you forgot to write rcell after next
>
> Sub selection_area()
> Dim rcell As Range
> For Each rcell In Selection
> rcell.Value = 1
> Next r
Hi all
Well, I am not sure what's going on here..
I selected few cells then run the following code (for test purpose)
dim rcell as range
for each rcell in selection
rcell.value = 1
Next
Then I gets complie error message:
For Each may only iterate over a collection object or an array ..
Hi all
I'm trying to learn how to connect to SQL Server and extract information
from Excel.
The code below is one I got it from one of site and modified a bit (After
reading a book about ADO)
When I run the code, I get the following error
Complie error:
User-defined type not defined
Then
Hi
I have an issue with suming up numbers..
when I sum up, it shows as -1.776E-13 ... not as Zero.
I know I can fix it by simply changing the format cell to number.
But the issue is that excel doesn't think it is Zero.
in the sample worksheet, Range C54 contains a following formular
Thanks a lot!!!
Well, I looked at the macro and its' not what I want.
I thought through and came up with a following code.. ( just testing code)
In this example, there are five values: 12.25, 10.3, 24.3, 23.19, 55.2
And I need to find any combination of values above which sum up to ... let's
Hi! siti Vi
I tried to download the example workbook but no file found
could you send me the file if you can please???
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Well, I haven't tried but looks like it's exactly what I want
Thanks Million
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Jo
Hi
I can think of a way to write this macro.
What I want is to find any possible combination of numbers from given
numbers to a given total. For example,
Let's say
Given numbers: 1, 2, 3, 4, 5
total = 30
Will it be possible to get any combination of Given numbers adding up to
30?
Mac
Hi
I know a bit of SQL.. can write a bit of complicated query..
At work, I don't have Write right to SQL server.. because my role is to
investigate and report.
I would create a stored procedure and simply bring records I want using
'From other source' in Data tab.
But that's not possib
I'm not sure if I understand what you want correctly.
O2 cell in your sample file
you can have the following formula
=VLOOKUP(M2,$A$1:$B$56,2,0) * VLOOKUP(M2,Sheet2!$A$1:$B$56,2,0)
then do autofill ..
Is this what you want?
--
-
Hi
I have written a macro for you.
Open the attached text file and copy the procedures (everything) to VBS.
Run 'Copy_worksheets_Master' procedure.
For this to work
you need to copy all the files to a folder..
When you run the macro, it will ask you to select a folder where you stored
th
Hi
I’m trying to extract EFT information from the following cell
PAYMENT BY AUTHORITY TO SG FLEET SALARY PACKAGING PTY LTD SGFLEET
EFT587544
So there are 100s of transactions with such information above. I’d
like to extract only EFT587544 in the next cell (in this example). The
location and the
Hi
I have a set of data which I need to sum up between unknown range..
The following is the code I am using
Range("C:C").Find("Description", LookIn:=xlValues).Select
FBTFirstrow = ActiveCell.Offset(1, 0).Row
FBTlastrow = ActiveCell.End(xlDown).Row
ActiveCell.Value = "Total FBT Transfer to Fun
Hi
I am wondering if anyone can help me creating a macro for the
following..
Get a reference from the selected cell and take me there .
For example, A1 contains C4. The macro will take me to C4. This is a
very simple one.
A1 contains a reference Sheet2!C4. I’d like the macro to take me
sheet2 C4.
Hi
I have been trying to make these but have failed. ^ ^;;
I’d like to create a macro
A21 has a word called ‘Date’
And somewhere down in column A has a cell with a word ‘FBT Details’.
The location of FBT details depends on the amount of data between
these two headings. I’d like to remove any bla
tings, you just need to add
> that add-in to your workbook & no extra efforts.
>
> Let us know if you need any further help on this.
>
> Best regards,
> Ayush Jain
> [Group Owner]
>
>
>
> On Sun, Jan 17, 2010 at 3:47 AM, Markkim wrote:
> > Hi
>
AM, kvc praveen kumar
> >> wrote:
>
> >>> Hi,
>
> >>> Please find the attached file and let me know if this is what you are
> >>> looking for. I used worksheet events to impement the same.
> >>> Regards,
> >>> Praveen
> >>
Hi
Well, it has happened to me many times.. but I have never thought of
seeking a solution for it.
Is there anyway to back up the macro buttons that you created on the
workbook?
I have 20 Macros for my work. I have created buttons and each of these
buttons linked to a macro... Every time I ope
n Jan 17, 1:35 am, kvc praveen kumar wrote:
> Hi,
>
> Please find the attached file and let me know if this is what you are
> looking for. I used worksheet events to impement the same.
> Regards,
> Praveen
>
>
>
> On Sat, Jan 16, 2010 at 6:39 PM, Markkim wrote:
> >
Hi all
Wow.. I didn't know there is a place like this where you can get some
help from experts for Excel macro.. It's brilliant.. !!
I have been thinking for some time that It would be very useful if I
had this feature..
I hope it's possible.
I have an excel file which has three sheets.
First
22 matches
Mail list logo