Recent content by acjeff

In more details, I created a form which similates a word document for reporting. In runtime, I set its height equals the screen's height and its width = height * 0.7727 which is the same scale as a letter size paper and ,moreover, resize all controls to show on screen. Users can see the whole...

How could I print a VB6 form with full size on the printing paper, says, letter size? Hopefully I do not need to buy a 3rd party software. I am thinking about to enlarge each control and the form and then print it out and then resize them back to their original size. However, I do not want the...

What other solutions can I found for free? I know about Data Report in VB6. Any others or what is the best?

Hi, I am using VB6 in Visual Studio 6 Enterprise Edition. Does it bundle with Crystal Reports? I cannot find anywhere to install Crystal Reports. If it is not bundled, where can I download it like an add-in? Jeff

Hi, In Word macro programming, is it possible to set the mouse pointer to glasshour while the code is processing? How to do that? Jeff

Hi, I am writing some Ms Word macros. I need to export data to an Excel worksheet. I need a button to open a dialog box and let users to select the Excel file. How can I create a dialog box in Word macro? Jeff

Ok. Maybe my question should be: I have an Excel file myFile.xls already opened. Then in Word macro code, how do I set an object to that opened workbook? I tried Set objWorkbook=Workbooks(myFile.xls") but I got an error of Run-time error '9': Subscript out of range. And I tried Msgbox...

Hi, I use Word macro to check if an Excel file is alreay opened. If Not FileOpened(ActiveDocument.Path & "\myFile.xls") Then Set objExcel = Nothing Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.workbooks.Open(ActiveDocument.Path & "\myFile.xls", 0...

Great! Thanks.

Hi, I am writing macros to copy data from Ms Word tables to Ms Excel. Here is my questions: Before paste data onto Excel, I try to search for the last row on a worksheet. Dim lastrow As Integer lastrow = objExcelWorksheet.Cells.Find(What:="*", _ SearchDirection:=xlPrevious, _...

Hi, Is it possible? I have 2 sets of data for X and Y. I want a VB6 program to general a trendline with 4th order polynomial equation automatically and then take all the coefficients for other purposes. However, the machine do not have Excel installed. Can I still do that? Jeff

Hi, I have a form with a button to cycle the machine. The form also contains some custom menu buttons created from Menu Editor. Each time the cycle machine routine do a lot of stuffs such as timer count down, control a motor, read data, etc. Meanwhile, even though I set the menu buttons to be...

When I set Gridlines on Excel Page Setup, the linking table on the Word document contains border as well as on the printout. When I have no Gridlines on Excel, I can only put "Outside Borders" on the table on Word and printout. That is why I need it on Excel. But I still have not resolved the...

I am using Office XP. I created an Excel worksheet and had some calculations cells. Then I linked it to a Word document as the following procedures: 1. On Excel, Page Setup -> Sheet tab -> checked Gridlines box 2. Selected the desired columns and rows and Copy 3. Switched to my Word document...

I login to my computer as administrator with full permission. The database does not have any permission or password settings. I created it and give it to my customers and there were more than one customers who had the same problem once in a while. I use Access 2003 Professional version and still...