Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20

I have Office XP Professional and I want to open some Quattro Pro for Windows
files (*.WB1 Files) using Excel 2002. However, I keep getting this message:
Excel cannot open this Quattro Pro for Windows file. The Quattro Pro
converter may not be installed or the file type may not be supported.
How can I open these files?

--
Computers!? BAH! Humbug!


Post your answer or comment

comments powered by Disqus
I am trying to open Quattro Pro 7.0 files (.wb3) in Excel 2003. It says in
their documents about supported file formats that this file format is
supported for opening in Excel 2003, with a converter installed. I've
installed the entire Excel 2003 software, along with all service packs and
the Office 2003 Conversion Pack. I am still unable to open Quattro Pro 7.0
files in Excel 2003. There are downloadable converters for Excel 2000 and
97, and those work fine for those version. But, there is nothing for Excel
2003 and information is scarce.

I am trying to open Quattro Pro 7.0 files (.wb3) in Excel 2003. It says in
their documents about supported file formats that this file format is
supported for opening in Excel 2003, with a converter installed. I've
installed the entire Excel 2003 software, along with all service packs and
the Office 2003 Conversion Pack. I am still unable to open Quattro Pro 7.0
files in Excel 2003. There are downloadable converters for Excel 2000 and
97, and those work fine for those version. But, there is nothing for Excel
2003 and information is scarce.

My apologies for the cut and paste. I saw that someone posted this a year ago but i did not see a response. I am having the exact same issue,

"I am trying to open Quattro Pro 7.0 files (.wb3) in Excel 2003. It says in
their documents about supported file formats that this file format is
supported for opening in Excel 2003, with a converter installed. I've
installed the entire Excel 2003 software, along with all service packs and
the Office 2003 Conversion Pack. I am still unable to open Quattro Pro 7.0
files in Excel 2003. There are downloadable converters for Excel 2000 and
97, and those work fine for those version. But, there is nothing for Excel
2003 and information is scarce."

Thanks!

I've installed every option on my Office 2003 standard CD, loaded the
Office2003 Converter Pack (oconvpck.exe from Article ID : 212265 ) and
updated to the latest Office 2003 service pack. Still can't open Quattro Pro
7.0 .wb3 worksheets in Excel 2003. Where's the missing converter?

I have downloaded the Office Converter Pack per instructions and can still
not open a Quattro Pro for Windows 5.0 file. The help menu says it should be
converted. What next?

How do I convert Quattro Pro 9.0 files to Excel?

Hi,
I am trying to open some Quattro Pro (wb3) files in Excel 2007...
On the Microsoft Office Online site, File formats that are supported in
Excel article, it says for both wb1 and wb3 files: "You can open Quattro Pro
files in Excel by using a converter. You cannot save an Excel file to Quattro
Pro format." The question is what converter? I installed Office 2007 with all
the converters that came with it but when I try to open the wb3 file, Excel
simply says "incorrect format" and will not open the file. Can someone let me
know where I might get the Office 2007 converter referred to in the Office
Online article? (I might also need to open some wq1 files but I guess I will
meet that challenge when I come to it)...
Many thanks, as always, Boris.

Someone has sent me some Quattro Pro 7.0 files that I need to open up. When
I had Excel 2000 before, it was as simple as downloading a converter and the
files opened up in Excel. However, for Excel 2003, I cannot find a converter
anywhere on the web site. Can someone point me to a converter or how I can
convert into Excel 2003 from Quattro. I have already tried the "Office
Conversion Pack" that the downloads site seems to direct me to.

Thanks,
Clark

Someone has sent me some Quattro Pro 7.0 files that I need to open up. When
I had Excel 2000 before, it was as simple as downloading a converter and the
files opened up in Excel. However, for Excel 2003, I cannot find a converter
anywhere on the web site. Can someone point me to a converter or how I can
convert into Excel 2003 from Quattro. I have already tried the "Office
Conversion Pack" that the downloads site seems to direct me to.

Thanks,
Clark

Excel Help saysFile Converter for Quattro Pro 5.0 files on download site.
Cannot find it! Thanks!

After I save and close a file in Excel 2007, the next time I open the file it
always opens with the pop-up "File in Use" - Rebooting the machine fixed this
for a little while but now this always happens - why?

Rod

I know there is another Ozgrid thread with a similar problem, but it's old and my issue is different so here's a new thread.

I am creating a macro that creates and submits an entry to a database. The entry process happens over several pages. On one page, I need to upload two files. Here's what I need to do:

1. Click on the Upload button.
2. A file dialog appears.
3. Input a file path.
4. Click the file dialog's 'Open' button to upload the file.

The file path on my computer is static and never changes (it's a placeholder file). I have figured out how to do step #1 using this code:


	VB:
	
Item = ieDoc.getElementsByName("ELEMENT_NAME").Item(0).Click 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
And I tried to input a filename by doing this:


	VB:
	
Item = ieDoc.getElementsByName("filename").Item(2) 
Item.Value = "FILE PATH" 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
But it doesn't do anything. I also have no idea how to click the 'Open' button in the IE file dialog window after I enter the filename. Maybe my approach is too simplistic but my view is that if I can just figure out how to populate the filename and click the Open button, I can let the browser itself handle uploading. Each task individually seems like they should be really easy but I'm not sure.. I'd really appreciate any help!!!

Here's the code of the Upload function on the webpage:


	VB:
	
 
Large 512x512 Icon 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
// this javascript has To go below the HTML above so the DOM exists before initialization 
// I don 't want to use a document load listener so this can run easily inside ajax derived panels where the javascript
// Is execute via 'eval' and document load listening ('observer') doesn't work
 
 
var uploaderlargeAppIcon = New LCUploaderImages({uploadContainer: 'largeAppIcon', statusURL:
'/WebObjects/iTunesConnect.woa/wo/13.0.0.9.7.3.3.1.11.3.1.1.11.5.1.1.3.1.3.1.29'});
 
 
 
 
 
 
 
 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Any ideas?

THanks!!!

EDIT:
FULL PAGE SOURCE ATTACHED: Full_Page_Source.txt

We have switched to Excel 2003 at the office and I have to convert many
Quattro Pro version 11 files to Excel ... is there a conversion tool
available that will work? I have tried to save them as excel ver 97 files
within Quattro pro 11, but the program will not save the formulas, only the
values. any help is appreciated. thanks.

THF

Can someone please recommend tried and true bulletproof code that would
reside in an Excel file to manipulate an Access database file. I have not
coded Access from Excel in a long time, so I'm especially interested in code
you have used that you know from experience has done the job in these two
scenarios:

Scenario #1

Data in two Excel files needs to be combined and manipulated for pivot
tables, reports, the usual programming stuff which is no problem. So far,
that data has been getting into Excel manually, by first opening up an
Access database, manually executing two queries (named MyQuery1 and
MyQuery2), and downloading each Query's recordset into its own spreadsheet
file. I need reliable code that will:

From within Excel with a macro, open C:MyFilePathMyDatabase.mdb, execute
MyQuery1 and MyQuery2, with each query creating its own Excel file, then
close the MyDatabase.mdb file. I can deal programmatically with the 2 new
Excel files from that point.

Scenario #2

I have a table of records in my Excel file in Sheet1 (row 1 is header and
the records start in row 2) that needs to be added to an existing table in
an Access file named C:MyFilePathOtherDatabase.mdb. So, from Excel, I
need to open said Access file, add the Excel Sheet1 records to a table named
MyTable, close said Access file, and then maybe go have a beer.

Using Office 2003.

Thanks !!

How can I open Quattro Pro files in Excel?

How do I open or convert a Quattro Pro 8.0 spreadsheet in Excel 2002?

Hi All:

I use Office 2007 and recently I have been experiencing the following.

1. I double clicked an xls file from within My Documents
2. Excel fires up but does not open the file
3. Observation: The File in Use dialog box is displayed with the following message:

"FileName.xls is locked for editing

by R:

Open Read-Only or click Notify to open read only and receive notification when the document is no longer in use."

4. There are three command buttons: Read Only, Notify and Cancel.

Note that I even rebooted my computer and then clicked the file, but the same behavior as seen.

Has any one encountered and resolved this issue? Thank you all.

Are there any free file conversion utilities that will allow the import of Quattro Pro 9 or 10 (*.qpw) into Excel 2000 (*.xls)?

I have checked Microsoft Update and found (and installed) the Quattro Pro 7 file converter as well as an Office File Converter Pack. There are no tools or utilities to import Quattro Pro 9 files.

A search of the web led me to a program called DataLoad. I could not get it to work as stated.

Thanks

Lately I found that I can't double click on an .xls file to launch Excel and
open the file. I have to launch Excel then from within Excel open the .xls
file. I went into file types to try and re-establish the association with
Excel and .xls files without success... Any suggestions?


Quattro Pro is desktop publishing, and Excel is spreadsheet, can't say
how Quattro Pro would import/export to .xls, .wks is old microsoft works.
Check in quattro pro on exporting files.

Danny

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Lately I found that I can't double click on an .xls file to launch Excel and
open the file. I have to launch Excel then from within Excel open the .xls
file. I went into file types to try and re-establish the association with
Excel and .xls files without success... Any suggestions?

Neil.Krohn@freescale.com

Hello

I am using excel 2003. I have more than 500 text file which are result of some numerical analysis. I have another bunches of the same file number. I can record and play around with macro.

What I want to do is
-copy selected cells from imported text file in excel and paste in new or in first opened excel file. I have recorded macro for one file including importing from text to excell, copy and paste the selected file (look the macro below). But I have more than 500 files and I want to do the macro the same thing for each file in one excell file. Do i have to make one macro for each file??, that takes much more time than manual import and copy paste. The cell position and range to copy is the same, but have to be pasted in new row (in one excel summery file). The file name of each text file is different and all are in the same folder.
Sub text_to_excel()

    Workbooks.OpenText Filename:= _
        "I:ResearchVALERI_germinationvaleri_slopevaleri_slope_COREL_DHPoutputDSCN2589.txt" _
        , Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
        xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, Semicolon:=False, _
        Comma:=False, Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1), _
        Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), _
        Array(9, 1), Array(10, 1)), TrailingMinusNumbers:=True
    Range("C1:C2").Select
    Selection.Copy
    Range("M25").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
    Range("H1:H6").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("O25").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
    Range("J1:J6").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("U25").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
    Range("G20").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("AA25").Select
    ActiveSheet.Paste
End Sub


Hi All,

I got the below coding from some other sites.. but while executing this macro, i got error messages and i can't solve this coding issue. Please help me to get resolve or any new coding to split tif images thru excel vba macro.

Option Explicit

Dim ImageFile As Long
Dim BitMapImage As Long

Private Sub cmdFile_Click()
cmdSplit.enabled = False

' create a open dialog so that you can select
' the multipage tiff to split
CommonDialog.InitDir = App.path
CommonDialog.DialogTitle = "Select Multi Page TIFF"
CommonDialog.DefaultExt = "*.TIF"
CommonDialog.filter = "TIF Files|*.TIF|TIFF Files|*.TIFF"
CommonDialog.ShowOpen

If (Len(CommonDialog.filename) > 0) Then

' apply the selected image to the Kodak
' thumbnail control to display icons of the
' different pages
imgThumb.Image = CommonDialog.filename
imgThumb.Refresh

' use the FreeImage DLL to open the multipage
' TIFF file, and use the GetPageCount function
' to determine if there are multiple pages to
' process

ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _
CommonDialog.filename, False, True)

If (FreeImage_GetPageCount(ImageFile) > 1) Then
cmdSplit.enabled = True
End If

' update caption bar with filename + page count
Caption = CommonDialog.filename & " " & _
FreeImage_GetPageCount(ImageFile) & " page(s)"

' close the multi-page TIFF file
Call FreeImage_CloseMultiBitmap(ImageFile)
End If
End Sub

Private Sub cmdSplit_Click()
Dim pages As Integer
Dim i As Integer

' use the FreeImage DLL to open the multipage
' TIFF file, and use the GetPageCount function
' to determine if there are multiple pages to process
ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _
CommonDialog.filename, False, True)

pages = FreeImage_GetPageCount(ImageFile)

i = 0
Do While i <= (pages - 1)
' use the lock page function to copy that
' page into a new variable BitMapImage
BitMapImage = FreeImage_LockPage(ImageFile, i)

' save that page out to a new filename
Call FreeImage_Save(FIF_TIFF, BitMapImage, _
App.path & "page" & i + 1 & ".tif")

' unlock the page
Call FreeImage_UnlockPage(ImageFile, i, False)

i = i + 1
Loop

' close the multi-page TIFF file
Call FreeImage_CloseMultiBitmap(ImageFile)

' feedback to user that process is complete
MsgBox pages & " pages, split from " & _
CommonDialog.filename, vbInformation, "Complete"
End Sub

I will expect this coding solution as earlier as possible.

Thanks & Regards,
Ganesh

Please Help
I am using Excel from office 2000 for small business in Windows XP for printing bill for customer in small restaurant. For example :

column A column B
coffee £ 1.00
Tea £0.80
Rice £1.00
................................................................. Bill
.................................................................
when I want to print bill for customer, here
I use excel autofill function to make my bill printing quick, for example

c the coffee will come up
r the rice will come up

but I have to fill in the informations in column B (price) by hand and use it at the end of the bill for adding up.
My question is ?
when I Key in C I want coffee from column A come up with £ 1.00 from column B
Please tell me how
Thanks


No luck finding an answer? You could always try Google.