Recent content by GordonSH

Thank you Chris, Mike, Griff, Dan & Tamar!!!!! You all rock and are awesome! I have it working now. Blessings to you all. Gordon

This code creates the xls file and opens it and saves as xlsx file but the above error happens when I go to open it. *Command7.click - Create the Receipt.xls File Select receipt set safe off copy all to c:\Spotlite\receipt.xls type xls ************************** * Excel workbook version upgrade...

Office 16

When attempting to open the XLSX file I get this error. Thank you in advance, Gordon

Hi Mike, Thank you so much!!! All of you on this group are so wonderfully helpful!!! Gordon

Thank you Chris, So I just neeed to replace FullPath with something like "C:\folderName\" ? Or could I declare a variable Named: "FullPath = "C:\folderName\" You have helped me a lot! Thank you so much! Gordon

Thank you all for your responses. I could not find a solution. *Command7.click - Create the Receipt.xls File Select receipt set safe off copy all to receipt.xls type xls *Want to open the xls file and save as an xlsx file and close the xlsx file within this code if possible and no screen...

I tried to create an xlsx file but the command would not like xlsx. So how can I take an xls file and convert it to xlsx within FoxPro? Thank you in advance, Gordon

Currently I have a routine that creates an XLS file from a .db *Command7.click - Create the Receipt.xls File Select receipt set safe off copy all to receipt.xls type xls *(Can I specify xlsx instead or not?) set safe on Messagebox("Receipt XLS File Created", 0, "Receipt XLS Status") select...

Printer is configured for LPT Port 2 It goes immediately to error in the print que. It looks fine in the Print preview mode. THE CODE FOR PRINTING THE LABLE IS BELOW:*Command14.click - Print a Single Label for current record. PUBLIC Defaultpr, Printerb Local Id_Save SELECT 1 select medspot...

That's not the last problem. It works on my computer but not on my clients computer. Ugh

Hi Nigel, I think I have solved the problem. Somehow the printer won't let me print on the top of the label. So I have combined the Country line with the line above it and moved the remaining lines down. This allows all lines to print on the label.

Hi Nigel, The first line should not be blank because it's the line with the name on it. ALLT(label.title)+IIF (empty(label.title),""," ") +ALLT(label.firstname)+" "+ALLT(label.lastname)

Something wrong with the bands that it doesn't print the first line.