Hi, Dear expert,
I have a daily work table, i use it every day, i want to send this excel
worksheet table to SQLSERVER database, but i do not know how,
can you give me VBA code to instruct me how to do it ? I use SQL 2008,
thanks in advance.
B.R.
--
FORUM RULES (986+ members already BANNED
Dear experts
for a command button of an userform for Printing of sheets purpose I am
using code as
sheets(sheet1).printout
whereas, i need to print 3rd page of sheet1 everytime, so what change is
required in the above code to get only 3rd page.
regards
shankar sb
--
FORUM RULES (986+
Didn't try, but should work -
http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa
On Tue, Mar 27, 2012 at 11:36 AM, sunil bn bnsuni...@gmail.com wrote:
Dear All,
Please find the attached file.
I Need the formula for Number to text in Indian Currency
Attached file of your
Hi Asa and Don
Thanks for all your comments and help.
Now I see what it is doing, as you explained in your emails. Yes it does
work, in quite a different way to what I was expecting. My apologies for
being so dumb.
With this sheet it is normally filled in once and not all of the tabbed
cells
Dear experts
How to get watermark impression on the userform while taking printout ?
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Hi Abhishek Jain ,
Its not working!
On Tue, Mar 27, 2012 at 12:23 PM, Abhishek Jain abhishek@gmail.comwrote:
Didn't try, but should work -
http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa
On Tue, Mar 27, 2012 at 11:36 AM, sunil bn bnsuni...@gmail.com wrote:
Sheets(Sheet1).PrintOut From:=3, To:=3
On Tue, Mar 27, 2012 at 12:23 PM, Shankar Bheema shankar.n...@gmail.comwrote:
Dear experts
for a command button of an userform for Printing of sheets purpose I am
using code as
sheets(sheet1).printout
whereas, i need to print 3rd page of sheet1
Did you change trying the syntax?
On Tue, Mar 27, 2012 at 12:32 PM, sunil bn bnsuni...@gmail.com wrote:
Hi Abhishek Jain ,
Its not working!
On Tue, Mar 27, 2012 at 12:23 PM, Abhishek Jain abhishek@gmail.comwrote:
Didn't try, but should work -
Hi Abhishek Jain ,
Sorry i got it... thnx very much..!
Regards
Sunil B.N
On Tue, Mar 27, 2012 at 12:39 PM, Abhishek Jain abhishek@gmail.comwrote:
Did you change trying the syntax?
On Tue, Mar 27, 2012 at 12:32 PM, sunil bn bnsuni...@gmail.com wrote:
Hi Abhishek Jain ,
Its not
Dear Shankar,
You can also use..
Sub Print_setup()
Application.Dialogs(xlDialogPrint).Show
End Sub
On Tue, Mar 27, 2012 at 12:23 PM, Shankar Bheema shankar.n...@gmail.comwrote:
Dear experts
for a command button of an userform for Printing of sheets purpose I am
using code as
Hi Abhishek Jain ,
one more help.
I need number should shown in Indian format like.
Example
55,55,555
On Tue, Mar 27, 2012 at 12:43 PM, sunil bn bnsuni...@gmail.com wrote:
Hi Abhishek Jain ,
Sorry i got it... thnx very much..!
Regards
Sunil B.N
On Tue, Mar 27, 2012 at 12:39 PM,
Hi pfa.
Kaяan
http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237
https://plus.google.com/43524614789164919/posts
On Tue, Mar 27, 2012 at 9:45 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear finos,
Anotherway to calculate amount.
On Tue, Mar 27, 2012 at
Right Click on cell...choose format cells Custom under the Type: use
this -
*[=1000]##\,##\,##\,##0;[=10] ##\,##\,##0;##,##0 *
On Tue, Mar 27, 2012 at 12:57 PM, sunil bn bnsuni...@gmail.com wrote:
Hi Abhishek Jain ,
one more help.
I need number should shown in Indian format
thnq so much..
On Tue, Mar 27, 2012 at 1:10 PM, Abhishek Jain abhishek@gmail.comwrote:
Right Click on cell...choose format cells Custom under the Type: use
this -
*[=1000]##\,##\,##\,##0;[=10] ##\,##\,##0;##,##0 *
On Tue, Mar 27, 2012 at 12:57 PM, sunil bn
Dear Noorain,
is there any prob. when i use
SUMIF(A1:B4,A7,B1:B4)
just for knowlege
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, March 27, 2012 7:45 AM
Subject: Re: $$Excel-Macros$$ vlookup with more than
Dear Garcia
Its working fine but on big file like for example 6+ rows its going
into not responding state for hours, please can you do the needful to
rectify the problem.
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Garcia
Dear Noorain
I want to delete the complete row and column if it is completely blank
after deleting row the data in the next column or row should not be
shifted to the delete row or column, please do the need full, Garcia
macro is working but on big file like 6+ row its going into not
Hi All,
I need your help on this simple task i don't know how to do this and for you it
will be easy.
I'd like to input eg 532, and I'd like to be converted to 05:32 or input 5.32
and be converted to 5:32.
I've tried to change cell format like hh:mm, [hh]:mm but its not working
what
thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Bhalara
Sent: 27 March 2012 08:16
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
Dear finos,
Anotherway to calculate amount.
On Tue,
Sir,
About 4 to 6 months back, in theis Forum Someone(may be Siti or so) has given a
formula to convert a column to table.
i.e., =Row(A1)*3-(3-Column(A1)) this works fine when A1 to A100 is 1 to 100.
But not with 10 digit cell phone number
data. Can any one suggest any formula or vba.(i am
Show us your before/after data and/or send a file with explanation.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: karunanithi ramaswamy
Sent: Tuesday, March 27, 2012 12:34 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ REG:$$Column to table
See if attached sheet is useful by formula
Aamir Shahzad
On Tue, Mar 27, 2012 at 7:05 PM, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
I need your help on this simple task i don't know how to do this and for
you it will be easy.
I'd like to input eg 532, and I'd like to be converted
Dear All,
We have two suppliers with different target slabs for a same product,
target slabs are as follows:
Supplier: A Slab 3% 4% 5% Target 2 25000 3 Actual 25000
Supplier: B Slab 3% 4% 6% Target 15000 25000 3 Actual 25000
Can somebody help me to present it in a
I have one sheet of raw data with several columns and thousands of rows.
I need to process this and I wanted to put the results on a separate sheet
with several columns and dozens of rows when done. I saw some example
code where it seemed you could do this as long as you qualified the sheet
Sub InitRefs()
dim fv As long
dim lv As long
With Sheets(“ChartData”)
fv= .Application.Match(Stopval, .Rows(1), 0) ‘notice the dot (.) before rows
End With
With Sheets(“Results”)
lv = .Application..Match(ReverseDate, .Rows(1), 0) ‘dot NOT needed on
ACTIVE sheet but needed here.
End With
May be useful to test LEN of cell (1051)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Tuesday, March 27, 2012 1:30 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ format a cell
See if attached sheet is useful by formula
Thanks. Believe me I am a firm believer in KISS. I did not realize
the . made that distinction though.
Also like getting rid of worksheetfunction. I went the other way and
tried to get rid of application and that failed. I thought it was the
redundant one not worksheetfunction.
So for cross
The file data is not available currently. The program for that is
being created elsewhere.
But essentially it is this:
Looping through raw data cells if xy then set flag value in results cells.
If other columns meet other conditions then munge data and set other
values in other results cells.
Dear Lakshman,
No problem bro..but in this case we should try to keep criteria range
instead of Criteria Range+Sum Range
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Tue, Mar 27, 2012 at 3:38
Dear Pawel.
Please try it..
=TIME(LEFT(C4,1),RIGHT(C4,2),0)
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Tue, Mar 27, 2012 at 7:35 PM, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
I need
Dear group,
After browsing the topics in this group, I found excel VBA could integrate
with Lotus Notes.
I found some VBA code useful for the integration, but do not know whether
extra library may be needed for installation.
Can anyone suggest do I need to install the library? where can find
Dear Darwin,
1. Set a reference to Lotus Notes Automation Classes. In the code window,
go to Tool -- References -- Select 'Lotus Notes Automation Classes.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
32 matches
Mail list logo