15,891,372 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by iris.frigole (Top 12 by date)
iris.frigole
14-Oct-11 11:02am
View
Thanks! I think I stubbornly googled "excel worksheet" and "excel workbook" then selection, current range, active range and so on...
The thing is the Selection property "Returns the selected object in the active window." and, yes, even if one application has more than one workbook open it still has only one active window!
iris.frigole
10-Aug-11 22:51pm
View
Long thread that I did not read, as the 1st reply solved my problem, but thanks for providing the link in Spanish!
iris.frigole
10-Aug-11 22:50pm
View
Yes... Data Source instead of Source did the trick! Thank you!
iris.frigole
10-Aug-11 22:50pm
View
Yes!
iris.frigole
1-Mar-11 8:36am
View
I will have a look to the linked article later today and let you know... I am a newbie, so I can't tell without reading everything more than once! Thank you.
iris.frigole
25-Feb-11 11:03am
View
you are right, i tagged c# because although i am using vb .net i was happy to receive c# code as an answer, as i was more interested in the logic than the language. thank you.
iris.frigole
25-Feb-11 7:04am
View
Accepting your answer, as (as far as i can tell) this is C# for
AddHandler mi.Click, AddressOf the_handler_sub
Thank you!
iris.frigole
25-Feb-11 5:36am
View
Maybe you want to check this CP article too, it has lots of screenshots:
http://www.codeproject.com/KB/dotnet/Win_App_Setup_Project.aspx
This article shows how to create and use the Windows Application Setup Project.
iris.frigole
2-Dec-10 13:20pm
View
Deleted
To read content of a cell:
Dim xlWorkSheet As Excel.Worksheet
Dim xlRange As Excel.Range
Dim sCellText as String
....
xlRange = xlWorkSheet.Range("D1,D1")
sCellText = xlRange.Text.ToString
...
if you want to loop D to g, use a function that returns letter from index:
Public Function getExcelColumnLetter(ByVal iColNumber As Integer) As String
Dim sResult As String
'End If
If iColNumber > 26 Then
' 1st character: Subtract 1 to map the characters to 0-25,
' but you don't have to remap back to 1-26
' after the 'Int' operation since columns
' 1-26 have no prefix letter
' 2nd character: Subtract 1 to map the characters to 0-25,
' but then must remap back to 1-26 after
' the 'Mod' operation by adding 1 back in
' (included in the '65')
sResult = Chr(CInt(Math.Round(((iColNumber - 1) / 26), 0) + 64)).ToString & _
Chr(((iColNumber - 1) Mod 26) + 65).ToString
Else
' Columns A-Z
sResult = Chr(iColNumber + 64).ToString
End If
getExcelColumnLetter = sResult
End Function
iris.frigole
29-Nov-10 13:01pm
View
Deleted
Ok, i have never done this, but probably the class you want is System.Net.FtpWebRequest.
Check method WebRequestMethods.Ftp.ListDirectory. HTH
iris.frigole
27-Nov-10 22:49pm
View
Yes, I assumed winforms and probably the question was for web development, you are very much right.
iris.frigole
26-Nov-10 11:53am
View
how you shall pass comma? you mean textBox1.Text = textBox1.Text & ", " & passedValue.
is this what you are asking????
Show More