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 ?
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"...
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....
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...
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.
I am creating an excel sheet from VB6.
This is working fine. I need to change the font size and color of few cells, say sheet heading and column heading...
can anyone help..
In my VB project I read data from different tables as per the user input, I decide the table name from the user input, before my select statement I should know if the table exist in my database. Can anyone get me the command for this?
Thanks
So your graph will take the data from the selected column...
it seems you graph has data from only one column...
Do your graph in such a way that it takes data from a specific column (not from the data columns)... every time when the user enters the column number copy the data from that column...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.