Recent content by snehakevin

Dim Report As New CrystalReport7 Dim db As Database Dim rs As Recordset Private Sub Form_Load() Screen.MousePointer = vbHourglass Report.Application.OpenReport ("xxxxxx.rpt") Report.PaperOrientation = crPortrait CRViewer91.ReportSource = Report CRViewer91.ViewReport...

I have an application which populates data from acces into a template excel file, which has a graph in it, through VB code. The user copies the graph into a power point slide for his presentation. Can I copy this graph straight into the power point slide with my VB coding? Can anyone help ?

which window are you talking about... use Acc.DoCmd.Minimize you can minimize the window....

You can try this also.....if you want.... 'Code starts Dim a As Object Dim w As Object Dim WSN As Object Dim q As Object Set a = CreateObject("Excel.Application") Set w = a.Workbooks.Add() Set WSN = w.Worksheets(1) WSN.Activate WSN.Range("a1").Select...

I am using the following code to send documents through mails..... MAPISession1.LogonUI = True MAPISession1.SignOn MAPMess.SessionID = MAPISession1.SessionID MAPMess.Compose MAPMess.RecipAddress = "mailid@xxxxx.com" MAPMess.ResolveName MAPMess.MsgSubject = "Testing Email&quot...

I already have a pdf driver installed. I want to know how to print an excel file without openning into a pdf format?

I am creating few excel files from VB, the user is interested in having the excel files in .Pdf format. Can we create .pdf files from VB ? If so can anyone help!!! Thank your

I tried all your suggestions but it does not work. I have put your code (ca8msm's code above) in a new form, it works when I click the command button, but it does not work in my procedure of creating the excel sheets. I cant figure out the problem....

Thank u nicsin, I have added the progressbar, how to use it? can you explain little bit....

My application is in VB. One of my option in the application is to create excel files in a required format. The process takes more than 3minutes. I want to show a process bar on the screen. I tried with timer event.. but it is not working or I may not used in the right way.. The code is like...

Thank you very much...

I have a Cristal report to be opened in VB. My application runs in a stand alone PC, which has no VB or Cristal report installed. I have copied the .rpt files. How do I open these reports? The data is from MDB. Please help

I am using a Access DB to create, say 50 Excel files, through a VB Application. I need to send this to 50 people by mail using lotus notes mailer.. Can anyone help

I added the project in sourcesafe in the same directory, all the forms in the project got locked. Every time I open the project the forms are in locked mode only I could not do any changes.... How to unlock it? Please help.

Thank you very much...