This works because you can do it manually. Note that that method only converts the WK? files in the ConvertFolder's path to XLS format. Obviously, you need to change the string value for ConvertFolder. This is where you copy and paste the VBA code that Anne posted. You can get similar help on how to add a Module. There are many help sites that explain "How to run an Excel macro".
You can get a membership free, by the way. Workbooks.Open FileName:=ConvertFolder & "\" & FileNameĪctiveWorkbook.SaveAs FileName:=ConvertFolder & "\" & Left(FileName, Len(FileName) - 3) & _ 123.Īnyone know of such a batch converter or script that can be used in Lotus or Excel or vb to batch convert all of these?Ĭonst ConvertFolder = "C:\Documents and Settings\Kevin Jones\Desktop\Convert"
I was able to find serval batch converters for wk? files but none for. We have a copy of Lotus 1-2-3 but not the time to manually open each 123 files and save as xls. wk? which excel will open) that need to be converted. This question was posted back in 2002 with no solution posted - just emailed vbscript from what I can tell.
0 kommentar(er)
