Can anybody tell me how I can open the FileName1 xls so that I can manipulate it's contents. The code below works fine if the excel application is open. If it's not alreday open the code will not work.
Set xApp = New Excel.Application
Filename1 = App.Path & "\SSB" & x & ".xls"
FileName2 = App.Path & "\SSB" & x & ".hld"
Set xWork = GetObject(Filename1)
xWork.Application.Selection.NumberFormat = "@"
xWork.SaveAs FileName2, xlCSV