Re: $$Excel-Macros$$ Japanese characters were garbled using ADOconnection to Oracle
Assign the output to a variable and paste in excel using the variable. I had
the same issue with russian chr and it worked.
Regards,
Roopesh Kapur
Sent from my BlackBerry® smartphone from !DEA
-Original Message-
From: taquito
Sender: excel-macros@googlegroups.com
Date: Wed, 23 Jun 2010 04:50:51
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Japanese characters were garbled using ADOconnection
to Oracle
Hi,
I am trying to pull data from Oracle using ADOconnection.
I was able to connect to Oracle, pull some data, and pasted into
worksheets, but every Japanese characters were garbled like "??".
I appreciate if anyone can help.
I think my Excel uses "shift-jis" character set while Oracle data uses
UTF-8.
Thanks
++
+
Sub Connect2Oracle()
' Define parameters/arguments
Dim mySQL As String
Dim oConOracle
Dim oRsOracle
Dim strConOracle As String
Dim colCounter As Long
' Define ADOConnection properties
Set oConOracle = CreateObject("ADODB.Connection")
Set oRsOracle = CreateObject("ADODB.RecordSet")
'Connect to the data base - Refer to tnsname.ora
' XXX is taken from tnsname.ora
strConOracle = "Driver={Microsoft ODBC for Oracle}; X"
' Open Connection to Oracle
oConOracle.Open strConOracle
' Return connection message
If Err = 0 Then
MsgBox "Connection successful
Else
MsgBox "Connection failed"
End If
' SQL query
mySQL = "SELECT * FROM " & gPRD_AUD
' StatusBar
Application.StatusBar = Now & " Running query number: 1"
' Execute SQL
Set oRsOracle = oConOracle.Execute(mySQL)
' Header
For colCounter = 1 To oRsOracle.Fields.Count
With wksOutput
MsgBox oRsOracle.Fields(colCounter - 1).Name
.Cells(1, colCounter).Value = oRsOracle.Fields(colCounter -
1).Name
End With
Next
' Start copy
wksOutput.Range("A2").CopyFromRecordset oRsOracle
' Disconnect
oConOracle.Close
Set oConOracle = Nothing
End Sub
+
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)
y can either use sendkey or go to a website cld. Www.dataload.net On 8/17/09, bala Subrahmanyam puligadda wrote: > Hi All, > > Can anyone help me in loading the excel information to Oracle Applications. > I have a list of transactions which I manually enter in to Oracle AP > transactions manually. can we record macro which automatically pic the > transactions by step and post it to the Oracle Applications tab which I use. > > > Thanks in advance > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help to break vbaproject password
how do u do it. Thx On 8/16/09, Dilip Pandey wrote: > Dear Mahesh, > > Please find the unprotected file. I have removed Worksheet passwords > + VBA Password. Thanks > > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > On 8/15/09, mahesh parab wrote: >> Dear All >> >> Can anyone break the vbaproject password of attach file, Please send me >> the >> link or software if anyone can. >> >> >> >> >> Thank You >> >> > >> > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Mail Merge in Outlook
pls search the forum. I had posted a solution some months back. Rgds On 8/6/09, Ujjwal Jha wrote: > Dear All, > > I can use mail merge with msword. But if I want to write mail in outlook and > want to send to many recipients but dont want them to see multi recipients' > names. I can use BCC but dont want to. I want to write mail and send them to > multiple but i want them to see their name only in 'TO' field. > > I hope I was able make u understand. > > -- > > Luv & Regards > Ujjwal Jha > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Leading zeros
prefIX the zero with an "'' On 5/19/09, john wrote: > > I have a basi questions. When I try to enter a number with a leading > zero, it ignores the zero and enters the rest. Where do I go to > correct this so all numbers including the leading zero be entered and > displayed? > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Calculation of FDR Interest
You are more than welcome mate, pls share the outcome. Rgds, Roopesh Kapur _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sergio Abadesso Sent: Wednesday, April 22, 2009 9:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest Hello Roopesh, thanks for your positive feedback and your plenty of ideas for improvement. I will defenitly work on a full-fledged solution. In the next step I will put in all your recommendations and will post a new Version in the next days. Thanks and regards, Sergio 2009/4/22 Roopesh Kapur Readers, No doubt the excel sheet is brilliant and if correctly implemented it is great. Below is my response: Things that are incorrect: 1.TDS is where most people go wrong. As a thumb rule, TDS is paid to the govt. at either every payout or at year end (31-mar). 2.While compounding only net of tax interest is added to the principal, the TDS gets debited from the interest and get credited to the TDS GL where it remain till it is paid out to the Govt. 3.I am attaching the correct way of calculating for a compounding FD a.If you observe each qtr that has 31-Mar in it has been broken down into 2 parts as banks have to calculated TDS and pay the govt. b.Banks usually take a year to be 365 days and interest is calculated on a daily basis hence it is not correct to calculate annual interest and divide that by 4. Some qtrs have 91 days and even less. c. Enhancements that I recommend in this very useful utility spreesheet. 1.TDS is different for different types of customer (individual 10.3%, Trust 11.33% and non individuals 22.6%) 2.Some customer are exempt from tax, so it will be useful if the macro is able to pick if the TDS is to be deducted firstly and then what amount of TDS is to be deducted. Let me know, if you want to make this spreadsheet into a full-fledged tool for people to look at, will give more ideas. Regards, Roopesh Kapur _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Sergio Abadesso Sent: Wednesday, April 22, 2009 2:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest Hi Shafiq, I always tried to attach the files through the group Window because I didn't know that it is possible to write an answer through E-Mail. It works fine now! Thank you! Regards, Sergio 2009/4/22 shafiq online Attached file and send it through email.what the problem ! > Date: Tue, 21 Apr 2009 01:34:32 -0700 > Subject: $$Excel-Macros$$ Re: Calculation of FDR Interest > From: groups.abade...@googlemail.com > To: excel-macros@googlegroups.com > > > Hello Ashish, > > I am working on a solution for you! > > But I still don't know how to attach a file in an answer. > > I'm new in this group and I really want to help people with VBA > problems. > > But before I have to know how I can attach files. > > Best Regards, > > Sergio > > On 20 Apr., 15:51, Ashish got engagged <4everash...@gmail.com> wrote: > > Hello, > > > > I am attaching herewith one excel file in which I have calculated Fixed > > Deposit Receipt Interest. Plese give me any fixed format so that I can just > > enter the FDR No, amount, tenure, interest rate. So that it will > > automatically calculate the Interest for each quarter, i.e. June, Sep, Dec, > > Mar end. > > > > Thanks, > > > > Regards, > > > > CA. Ashish > > > > FDR Interest.xls > > 173KAnzeigenHerunterladen > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need Help regarding split Emp. Name & Emp. ID
There you go. _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Lavprasad Kori Sent: Monday, April 13, 2009 5:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help regarding split Emp. Name & Emp. ID Dear Friends, I am downloading the employee data from our portal. In, there is employee name & Emp. ID both are in the same column. I want to split Emp. Name & Emp. ID in to two different column. I am also attaching the reference file. Please help me. Thanks in advance. -- Thanks & Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Split Name No.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Macros in Outlook
Mudassar, Can you send me the code. Regards, Roopesh Kapur _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mudassar Ramzan Sent: Wednesday, April 08, 2009 11:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Macros in Outlook Please find the attached file. Maybe helpful for you. I didn't remember who share. But its better one I have seen ever. Regards, Mudassar Ramzan - Original Message - From: shashank bhosle <mailto:catchshashankbho...@yahoo.co.in> To: excel-macros@googlegroups.com Sent: Tuesday, April 07, 2009 11:24 PM Subject: $$Excel-Macros$$ Macros in Outlook Hi I have to send a same mail frequently to all the employee.so i need to some macros where as i run the macro,the content to automatically apear in new mail Thanks and Regards Shashank Bhosle Life is all about Uncertaity _ Add more friends to your messenger and enjoy! Invite <http://in.rd.yahoo.com/tagline_messenger_6/*http:/messenger.yahoo.com/invit e/> them now.http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Automating the MIS
Hi Everyone,
I need some help from you all, my requirement is that there are 11 people in
my team and each one uses a different workbook as theri MIS at the end of
the day I have to combine data from each ones MIS into a master MIS. Few
Points.
1) All the workbooks are saved in the same location.
2) The format is a standard
Can this be automated, such that at the end of the day, I tell the macro the
path of the folder where the MIS' are saved and then it goes to that folder,
opens each file, copies data from a particular sheet, copies the data in my
master MIS, closes the MIS and then opens the next one repeats the cycle.
This way I will save lot of time and will get the MIS of all my team one
below the other.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Peter Jorgensen
Sent: Wednesday, March 04, 2009 10:17 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Find next available row
If the next available row is the first blank row on the spreadsheet you can
use this:
iNextRow = Worksheet("MySheetName").Range("A65535").End(xlUp).Row + 1
Worksheet("MySheetName").Range("A65535").End(xlUp).Row returns the row
number for the last row in column A with data in it (you can change the
range to use a different column) and then adding 1 will give you the next
available row. You can use this then like so:
Worksheet("MySheetName").Range("A" & iNextRow).Value = Date
This will put today's date in the next available row.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of iwasinnihon
Sent: Wednesday, March 04, 2009 8:39 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Find next available row
I am writing a macro and would like to have it find the next available
row on a sheet, enter the date, do a vlookup, and enter a running
sum. I can do everything except find the next available row. How
would I do this?
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Exclude weekends in time interval calculations
Try using networkdays(smaller date, higher date,range of public holidays)-1.
This function is not readily available in excel, however you had add an
addin (donot remember which one, you have to search it on the net).
If you manage to find the addin, it will certainly work I have used it in my
previous organization.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Wednesday, February 11, 2009 9:16 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Exclude weekends in time interval calculations
Without knowing the nature of your data, it's hard to know the 'best'
approach.
but here are some "tools" to try.
first of all, the Datediff function can tell you the number of
days,months, weeks, years, hours, minutes, seconds between the two dates.
which may be a bit more flexible than (end - begin)
Second,
the Weekday function will tell you... well... what day of the week the date
is.
for instance:Weekday(Begin_dt, vbMonday) says that 2/6/2009 is day "5"
(vbmonday = 1, Tues = 2... friday = 5)
Weekday(End_dt, vbMonday) = 1, or 2/9/2009 is a Monday.
using that, you can test to see if the date is 6 or 7, or..
you can use:
If (Weekday(begin_dt, vbMonday) + DateDiff("d", begin_dt, End_dt, vbMonday)
>= 6) Then
this uses the Weekday() function to determine the day number.
then the DateDiff function to determine the number of days between the two
dates.
If you take the day number and add the number of days, and the result is
more than 6,
then you're including a weekend (at least one).
At that point, you're going to have to do some more programming to determine
how MANY weekends.
also, you're going to have to decide what to do if the date is a Saturday or
Sunday.
for instance, for the beginning date, if the date is Saturday, do you shift
it to
Monday at 12:00:00am? (there are several functions you can use here)
what about end date? if it is on sat/sun, do you shift it to Friday at
midnight?
what to do?
Paul
- Original Message
> From: mongoose
> To: MS EXCEL AND VBA MACROS
> Sent: Tuesday, February 10, 2009 11:24:54 AM
> Subject: $$Excel-Macros$$ Exclude weekends in time interval calculations
>
>
> Hi, I am looking to automatically exclude weekend hours from time
> interval calculations
> Example of simple calculation including weekends:
> Begin dt = 02/06/2009 19:44:31
> End dt = 02/09/2009 10:13:41
> (End - begin)*24 = 62.48611104 hours
>
> Example of what I want without weekends:
> Begin dt = 02/06/2009 19:44:31
> End dt = 02/09/2009 10:13:41
> (End - begin) * 24 and excluding weekends = 14.48611104 (hours)
>
> I can get 14.48611104 if I subtract 48 to acct for the weekend, but I
> don't always know which dates are weekends and am hoping to identify
> them automatically in my (end - begin) calculation.
>
>
>
>
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
If you find any spam message in the group, please send an email to Ayush @
jainayus...@gmail.com
-~--~~~~--~~--~--~---
