Member Avatar for Lygris

So I've been trying to convert CSV files to XLS. However, this line of code keeps giving me problems:

oExcel.SaveAs FileName:=FilePath_XLS(TableName), FileFormat:=xlNormal

The FilePath_XLS returns correctly... I just can't figure out what's going wrong but it will not execute..

  • 1 Contributor
  • 2 Replies
  • 59 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Lygris
Member Avatar for Lygris

PS, to clarify, my issue is definitely with the FileFormat

Member Avatar for Lygris

Never mind, I figured it out. The appropriate FileFormat was 56.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.