Programming Help

Web Development



What's Here?

  • Members: 136,458
  • Replies: 479,295
  • Topics: 74,678
  • Snippets: 2,567
  • Tutorials: 676
  • Total Online: 1,861
  • Members: 97
  • Guests: 1,764

Welcome to Dream.In.Code
Getting VB Help is Easy!

Join 136,458 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,861 people online right now. Registration is fast and FREE... Join Now!




Excel

 
 Reply to this topicStart new topic

Excel
masipro
4 Aug, 2008 - 12:49 AM
Post #1

New D.I.C Head
*

Joined: 8 Jul, 2008
Posts: 39
Hai smile.gif ,

Please tell me to open an excel file thro' VB and if the excel file is protected with password, it should ask for password in VB itself. Also let me the supporting library files to use (in 'Reference' or 'Components')

Thanks smile.gif

User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: Excel
4 Aug, 2008 - 01:02 AM
Post #2

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 8,993



Thanked: 125 times
Dream Kudos: 8625
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Please post like this:

Thank you for helping us helping you.
User is offlineProfile CardPM
+Quote Post

masipro
RE: Excel
4 Aug, 2008 - 02:56 AM
Post #3

New D.I.C Head
*

Joined: 8 Jul, 2008
Posts: 39
QUOTE(PsychoCoder @ 4 Aug, 2008 - 02:02 AM) *

Dream.In.Code has a policy by which we prefer to see a good faith effort on your part before providing source code for homework assignments. Please post the code you have written in an effort to resolve the problem, and our members would be happy to provide some guidance. Be sure to include a description of any errors you are encountering as well.

Please post like this:

Thank you for helping us helping you.


Hai,
code is given below


Dim fso As New FileSystemObject, fil As File

Private Sub Command1_Click()
Dim str As String
str = "C:\temp.xls"
fso.GetFile (str)
AppActivate str

End Sub
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/2/08 03:50PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month