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

Free Microsoft Excel 2013 Quick Reference

Quattro Pro X5 (.qpw) to Excel 2010 (.xlsx) conversion

Hi,

I am trying to convert .qpw files to .xlsx. I have both Quattro Pro X5 and Excel 2010 installed. However, I can't seem to find a way to easily convert a .qpw file to .xlsx. I have searched the web for converters, but there only seems to be a converter for Excel 2000. I have also tried publishing the .qpw file to XML in Quattro Pro X5 and then opening through Excel 2010, but I either get an invalid file, or it opens, but the data is displayed as text (no formulas and formatting). Can anyone please advise on how to convert a .qpw file to .xlsx while keeping the correct formulas and formatting (is this even possible, since the formula syntax in QP and Excel is different?)

Thank you very much in advance!


Post your answer or comment

comments powered by Disqus
I am trying to convert a Quattro Pro .wb1 file to Excel 2003.

I have read about converters on the previous posts, however, I cannot find
any of these still available, except the Office 2000 version. I have tried
to run this using the modified registry entry, but it will not run. (error
message).

Is there another way to read to Quattro Pro file?

(also, I do not know anyone who has Quattro Pro to open this file, or I
would have used that method).

Does anyone know of a converter that I can use to convert my Quattro Pro v8 files to Excel 2002.

Phillip

We would like to open some old quattro pro wb3 files in excel 2003. For some reason, excel will not open the file. Any suggestions?

Thanks,

Capt. B

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

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

Hello, It's been a while.

I've been using this vba code, to search for files, on a media drive. It worked well, when in Excel 2003. I recently upgraded to Excel 2010. Now when I run the code, I get error.

Highlighted area is after clicking debug: With Application.Filesearch

Sub SrchForFiles()
     ' Searches the selected folders and sub folders for files with the specified
     'extension.  .xls, .doc, .ppt, etc.
     'A new worksheet is produced called "File Search Results".  You can click on the link and go directly
     'to the file you need.
    Dim i As Long, z As Long, Rw As Long
    Dim ws As Worksheet
    Dim y As Variant
    Dim fLdr As String, Fil As String, FPath As String
     
    y = Application.InputBox("Please Enter File Extension", "Info Request")
    If y = False And Not TypeName(y) = "String" Then Exit Sub
    Application.ScreenUpdating = False
     '**********************************************************************
     'fLdr = BrowseForFolderShell
    With Application.FileDialog(msoFileDialogFolderPicker)
        .Show
        fLdr = .SelectedItems(1)
    End With
     '**********************************************************************
    With Application.FileSearch
        .NewSearch
        .LookIn = fLdr
        .SearchSubFolders = True
        .Filename = y
        Set ws = ThisWorkbook.Worksheets.Add(Sheets(1))
        On Error GoTo 1
2:                      ws.Name = "FileSearch Results"
        On Error GoTo 0
        If .Execute() > 0 Then
            For i = 1 To .FoundFiles.Count
                Fil = .FoundFiles(i)
                 'Get file path from file name
                FPath = Left(Fil, Len(Fil) - Len(Split(Fil, "")(UBound(Split(Fil, "")))) - 1)
                If Left$(Fil, 1) = Left$(fLdr, 1) Then
                    If CBool(Len(Dir(Fil))) Then
                        z = z + 1
                        ws.Cells(z + 1, 1).Resize(, 4) = _
                        Array(Dir(Fil), _
                        FileLen(Fil) / 1000, _
                        FileDateTime(Fil), _
                        FPath)
                        ws.Hyperlinks.Add Anchor:=Cells(z + 1, 1), _
                        Address:=.FoundFiles(i)
                    End If
                End If
            Next i
        End If
    End With
     
    ActiveWindow.DisplayHeadings = False
     
    With ws
        Rw = .Cells.Rows.Count
        With .[A1:D1]
            .Value = [{"Full Name","Kilobytes","Last Modified", "Path"}]
            .Font.Underline = xlUnderlineStyleSingle
            .EntireColumn.AutoFit
            .HorizontalAlignment = xlCenter
        End With
        .[E1:IV1 ].EntireColumn.Hidden = True
        On Error Resume Next
        Range(Cells(Rw, "A").End(3)(2), Cells(Rw, "A")).EntireRow.Hidden = True
        Range(.[A2 ], Cells(Rw, "C")).Sort [A2 ], xlAscending, Header:=xlNo
    End With
     
    Application.ScreenUpdating = True
    Exit Sub
1:          Application.DisplayAlerts = False
    Worksheets("FileSearch Results").Delete
    Application.DisplayAlerts = True
    GoTo 2
End Sub
ANy help, much appreciated.

Hi,

I'm trying to import a Hebrew text file that was generated by a Linux server to Excel 2010 with the import text wizard. I've tried code pages Hebrew logical and Hebrew visual and in both cases i get the text reversed. On the same computer i have Excel 2007 installed and it's displayed correctly there (when i choose Hebrew visual). I've also tried opening the file with Firefox / Internet Explorer, and when i change the code page to Hebrew visual it's displayed correctly, so it seems like an Excel 2010 issue and not regional settings system configuration issue. Can anyone help me?

I'm attaching a file with one word in Hebrew. The correct form is "שלום" but i get "םולש" in Excel 2010.

Thanks.

My .qpw files will not open in Office Excel 2003; file format is not valid.
I did find a fix for Quattro Pro 7 to Excel 2000, but did not try that for
obvious reasons. Also, is the best way to move spreadsheet files from one
computer to another via cd? Thank you all in advance.

Is there anywhere I can get a free Quattro Pro trial download to convert a
QPW file?
I can't find a converter utility to read a QPW file.

How i can covert Quattro Pro documents (version 11/ 12 with extension .qpw,
..wb3, .wb2, .wb1, .wq1, .wq2) to MS Excel 2003 ? Please advice

I am trying to convert some spreadsheets from Corel
Quattro Pro (version 8) to Microsoft Excel 2003.

We had no problem bring in word processing files from
Corel WP8 to MS Word 2003, but with Excel it doesn't seem
to work. (Gives an error message saying " the file
format is not valid").

Does anyone have any suggestions for how to do this?
Perhaps there is an interim conversion that is required
(ie: from Corel 8 to Corel 10 and then to MS Excel)???

Any suggestions would be appreciated.

I have a Quattro Pro 7 file on a disk. I no longer have the Quattro Pro 7
program. I want to open the file in Excel 2003. It says it is not a valid
format.

I am trying to convert some spreadsheets from Corel
Quattro Pro (version 8) to Microsoft Excel 2003.

We had no problem bring in word processing files from
Corel WP8 to MS Word 2003, but with Excel it doesn't seem
to work. (Gives an error message saying " the file
format is not valid").

Does anyone have any suggestions for how to do this?
Perhaps there is an interim conversion that is required
(ie: from Corel 8 to Corel 10 and then to MS Excel)???

Any suggestions would be appreciated.

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.

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 have a .XLSM file created in Excel 2007 that contains a function to copy several worksheets into a new Excel file. When my user runs it in Excel 2010, she gets the error message:
Run-time error '1004':
Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy thedata ... "This is what I don't understand:

1. Normally you get that message when trying to copy a 2007 worksheet into a 2003 file, but how can you get it too when it's opening in 2010? The 2007 file is a .XLSM. The 2010 should be a .XLSX default.

2. My user is the only one in her organization using 2010. The rest of the organization are still on Excel 2003. Could it be possible that she set her 2010 default file type to .XLS so that the rest of the people can read her file? In that sense I can understand that the file her Excel 2010 creates is a .XLS file. Is it possible to pre-set Excel 2010 to start new document as .XLS? I only see it in the Excel Options that you can set the default Save format but not new document format. Are they equivalent?

Thanks in advance for your help!

Hi all

I am trying the below code to run macros in a number of files from a single file and single macro.

This code was taken and amended from another post: http://www.ozgrid.com/forum/showthread.php?t=85767.

It opens the first file fine, but breaks down when trying Application.Run.......

There is no error message, just a complete crash of Excel.

The only reason why I am trying this new code is because we have recently updated from Excel 2003 to Excel 2010 and the corresponding removal of Application File Search.

Would super appreciate any views/help.

Thanks

CODE HERE:

Sub updatemodel()

Dim Ci As Long
Dim wbResults As Workbook
Dim MyWorkbook As Workbook
Dim sPath As String
Dim sFil As String
Dim Iloop As Long

Application.ScreenUpdating = True
Application.DisplayAlerts = False
Application.EnableEvents = False

'last 3 lines stop Excel from showing each file as it opens and also stops the save changes window
'opening every time a file is opened and closed.

sPath = "cz.intlondonUsersRTDaily Bond Macro Test"

'here's where to look for

ChDir sPath 'same as above, change directory to look here and only here (probably unecessary)

sFil = Dir("*.xlsm") 'open all .xlsm files in this directory

Do While sFil "" 'loop through the following while the file name is not nothing, i.e. for all files in the directory

Set wbResults = Workbooks.Open(sPath & "" & sFil) 'actual command to open each file

With wbResults
Sheets("Sheet1").Select
Application.Run (wbResults.Name & " !updatemodel")

End With

wbResults.Close True 'close each file after it has been unmerged and copied from

sFil = Dir 'continue to keep looking in the specified directory, as above

Loop

Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True 're-enable these 3 items as they had been turned off earlier to reduce macro run-time and the need
'to click 'No' every time it closes a file and asks you if you wish to save changes

End Sub

I have a spreadsheet I created in Excel 2003 that compares 4 different values and highlights the lowest value by turning the cell background green. It works fine in that version. I just upgraded to Excel 2010 and found that the function no longer worked as before. All cells are green to start. Entering values in each of the cells turns the cell to the normal background. However, the lowest value does not turn the cell back to green. By opening the Conditional Formating button on the ribbon and unchecking the "stop if true" checkbox and then hitting the apply button, the proper cell is highlighted. I then tried unchecking and immediately rechecking the same box (back to the original format) and then hitting the apply button and it worked again. It appears that an activated "apply" button refreshes the function and the proper cell responds. What is keeping the function from automatically performing when the data is entered prior? Code is as follows [=$E48=MIN(IF(ISNUMBER($E$48:$E$54),$E$48:$E$54))] Resulting action is the green cell background for the lowest value. Thank you.

I've tried it. My excel 2003 will not read qpw files. I've tried to
download the converter for excel 2000, but that will not load because I
have excel 2003. I don't know why MS doesn't have a qpw converter that
works with excel 2003.

Niek Otten Wrote:
> If it works for Excel 2000, it works for Excel 2003 too.
>
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "dr88363" ...-
>
> Would some one please tell me why MS does not have a converter for
> qpw
> to excel 2003. Why would they have it for Excel 2000 but not 2003.
> This
> make NO sense to me!!!!
>
>
> --
> dr88363-[/QUO
> TE]

--
dr88363

I have tried various SendKeys combinations like the one below trying
to manipulate the dialog box for uploading a file to the Iseries,
where the transreqfile is a variable with the value of an Excel Range.
I know the file name is getting in the right location, but I can't get
the macro to choose either Enter afterwards or Open, then press OK.

I had all this working in Excel 2003 with:

SendKeys ("/" + "D" + "D" + "D" + "{Enter}" + "{Tab 6}" _
+ TransReqFile _
+ "{Enter}" + "{Tab 2}"), True

I wish we did not have to use the SendKeys method, and that there
would be a real visual basic solution to this.
Here is what I have so far in Excel 2010, with the client access
toolbar items now showing up in the add-ins at this point.

SendKeys ("/xD1" + "Tab 6" + TransReqFile + "{Enter}" + "{ok}")

Thanks for any ideas.

Bruce

I have been attempting to get a solution to this problem for a couple of days - my company cutover to Excel 2010, which killed my ActiveX Calendar - but I was able to work around it with code that I located online (see this thread for details on the calendar and where to get the code: http://www.ozgrid.com/forum/showthre...d=1#post609600). It works pretty well - but it always positions in the center of the spreadsheet. RoyUK helpfully pointed other users to Chip Pearson's form positioner code at http://cpearson.com/excel/FormPosition.htm - but I have a problem. It appears to have been written for an older version of Excel, and, in fact, much of the code within the form positioner references VBA6 (vice VBA7 which is shown on my Excel properties). No matter what I do with this code in 2010, I can't get it to reposition the userform - it always pops up in the center. If anyone is using this code with 2010 - can you tell me what I need to modify to get it running? I get coordinate positions, but the userform won't move.

I've tried the following code in the codeblock for the UserForm - in this case named "DatePicker." This code would be added to the spreadsheet I loaded into my previous post - the file exceeds the upload limits now.


	VB:
	
 cCalendar 
 
Private Sub UserForm_Initialize() 
     
     
    Dim PS As Positions 
     
    Dim HO, VO As Long 
     'Dim HO As cstFormHorizontalPosition
     'Dim VO As cstFormVerticalPosition
     
     'HO = cstFhpAuto '   set these to how you want the form positioned relative to AnchorCell
     'VO = cstFvpAuto '   set these to how you want the form positioned relative to AnchorCell
     
    Set Calendar1 = New cCalendar 
     
     'MsgBox "Calendar1.Left = " & Calendar1.Left
    Calendar1.Add_Calendar_into_Frame Me.Frame1 
     
     'MsgBox "Calendar1.Left = " & Calendar1.Left & " Calendar1.Width = " & Calendar1.Width
    MsgBox "ActiveCell.Left = " & ActiveCell.Left & " ActiveCell.Width = " & ActiveCell.Width & " ActiveCell.Top = " &
ActiveCell.Top & " ActiveCell.Height = " & ActiveCell.Height 
     
    HO = ActiveCell.Left + ActiveCell.Width ' - Calendar1.Width
    VO = ActiveCell.Top + ActiveCell.Height 
     
    MsgBox "HO = " & HO & " VO = " & VO 
     
     '
     ' Call PositionForm to determine the correct positions
     '
     'PS = PositionForm(WhatForm:=DatePicker, AnchorRange:=ActiveCell, HorizOrientation:=HO, VertOrientation:=VO)
     
     ''    PS = PositionForm(DatePicker, ActiveCell, 0, 0, HO, VO)
     
    DatePicker.Top = VO ' set the Top position of the form
    DatePicker.Left = HO ' set the Left position of the form
     
    MsgBox "DatePicker.Top = " & DatePicker.Top & " DatePicker.Left = " & DatePicker.Left 
     
End Sub 
 
Private Sub Calendar1_DblClick() 
     
    ActiveCell.Value = Calendar1.Value 
    Unload Me 
     
End Sub 
 
Private Sub Calendar1_Click() 
     
    ActiveCell.Value = Calendar1.Value 
    Unload Me 
     
End Sub 
 
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) 
     
    Set Calendar1 = Nothing 
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
On the worksheet I've tried this code:


	VB:
	
 Range) 
     
    Dim lastCol3 As Integer 
     
     
    If Target.Cells.Count > 1 Then Exit Sub 
     
    If Not Application.Intersect(Worksheets("Sheet1").Range("TestRange"), Target) Is Nothing Then 
         
        DatePicker.Show 
         
    Else 
         'do nothing
    End If 
     
End Sub 

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


Please see thread started by another member here that seems more appropriate for the Programming forum.

Originally Posted by davidstokes I downloaded some excel games from http://www.happy2-island.com/e/excel.shtml

When i open any of them I get a VBA error saying

Compile Error
The code in this project must be updated for use on 64-bit systems.
Please review and update declare statements and then mark them with the PtrSafe attribute.

I'm running Win 7 / Excel 2010

I've no experience with VBA - These are just some games I wanted to download to past the time.

Is is easy to update and get working ?

Hi, I have a couple hundred Excel (and Word - I assumed these can be handled the same way if there is a solution) files that I've created using MS Office 2000. I now have MS Office 2010 and would like to save these files in the 2010 format. I know how to do them individually, and have already saved a few files. However I'd like to clean things up a bit and save all of my Excel and Word files in the 2010 format, and get rid of Office 2000.

Rather than doing them individually, is there anyway of selecting all of my 2000 folders and files and have them converted or saved to the 2010 format at once. It would sure save a lot of time.

Thanks for your help.

Mike.

Hi all can some one help me with converting a Quattro runtime file .qpw to
open in excel 97??? thanks Andy

e-mail=4pyros at verizon net


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