Search results for query: *

Under File > Page Setup, choose the Page Tab. There is a scaling option so that you can fit the output to x pages wide by y pages tall. If it's a multi-page document and you just want to fit the width, set the "y pages tall" to something that exceeds your needs.

See faq222-429

Thanks for your help.

You can try using the CodeName property. Here is a little code that lists all of the sheet names and associated code names: Sub ListSheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets MsgBox ws.Name & vbCrLf & ws.CodeName Next ws End Sub

VB6 I am trying to display a picture in an Image control. The picture is stored in an Access table as an OLE object. I am trying to use recordset.fields(i) to get the object, which may be part of the problem. Any ideas?

You probably need to create the package with the latest version of the files. I had this problem incorporating the Outlook library without any difficulty. I think the only problem you may have will be using functions that are only available in the newer version. You may still want to wait for...

Just realized you are in the wrong forum. You should post this question in the Microsoft: Windows XP forum. Just hit the browse forums and you'll find it.

Are you using a legitimate XP CD? Some OEM versions will only install on OEM machines.

Have you tried copying the file to your hard drive? I would highly discourage working with files directly from floppy.

You'll need to open Normal.dot and change the setting. If you still have trouble, you can simply remove the file and Word will create a new default template when you open the application.

Check out faq222-428

Check out faq222-428

You may want to post a snipit of your code for us to look at.

Try this: Sub RefreshAllPivotTables() Dim ws As Worksheet Dim pt As PivotTable For Each ws In ThisWorkbook.Worksheets For Each pt In ws.PivotTables pt.RefreshTable Next Next Set pt = Nothing Set ws = Nothing End Sub

I am assuming you're using 4GL: /***********************************************/ /* Open Excel Application */ /***********************************************/ DEF VAR lReturnCode AS INTEGER NO-UNDO. PROCEDURE ShellExecuteA EXTERNAL "SHELL32.DLL": DEF INPUT...

Here are a couple of sites that offer viewers for AutoCAD. infograph.com cimmetry.com kamelsoft.com drdwg.com fastcad.com

You can try to use the Solver add-in to accomplish this.

Do While Not EOF(1) Line Input #1, DPFLine If DPFLine = " 8" Then 'grab next line Line Input #1, DPFLine Exit Do End If Loop

You will need to trap the error. Here is a quick example: On Error Resume Next TryAgain: pt = ThisDrawing.Utility.GetPoint(, &quot;Pick the Point: &quot;) If Err.Number <> 0 Then Err.Clear GoTo TryAgain End If On Error Goto ErrHndlr

You may want to try moving the code from Auto_Open() to Document_Open() in ThisDocument.