General information
Category:
Coding, syntax & commands
I got the impression from your first post that you were already using Excel automation. Is that not the case? All I was suggesting is that, rather than looping through each line and copying, that you instead use automation to run the "save as" command through Excel.
I don't know the proper syntax, but what I'm suggesting is something along these lines:
oExcel = CREATEOBJECT("Excel")
oExcel.Load("MySpreadsheet")
oExcel.Save("MySpreadsheet","DBF")
Keep in mind that that is very much pseudocode and probably far off from the actual syntax. :) That's why I suggested turning on macros in Excel and see what syntax it uses when doing a save as DBF. Then translate that into VFP.
Does that make more sense?
Michelle
>Michelle:
> I don't quit get the save as command. In order for me to do the save as command, I have to open the Excel file in foxpro. I tried to open the excel file with modi file command. All I got is a text file with unreadable information in it. I tried to do the save as command, dbf file type was not one of the available file type. That was why I asked if I should use the "save as" command in Excel or vfp? thanks.
>sherry
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only