Results 1 to 36 of 36

Thread: How to make all versions of excel work in Visual Basic 6 pro

Threaded View

  1. Jul 9th, 2017, 10:22 AM #26
    Eduardo-
    Eduardo- is offline
    PowerPoster
    Join Date
    Feb 2017
    Posts
    5,671

    Re: How to make all versions of excel work in Visual Basic 6 pro

    Quote Originally Posted by ChrisE View Post
    Hi @ll,

    this may be stupid, but is it possible to just Save the Workbook to the newer Excel- Versions?

    Excel 2000 to ???

    Code:
    ActiveWorkbook.SaveAs _
Filename:="C:\Meine.Xls", _  '<----here the new Version
FileFormat:=xlNormal
    regards
    Chris
    Hello,

    Intead of xlNormal try with xlOpenXMLWorkbook (value 51).
    More info:
    XlFileFormat Enumeration.
    SaveAs method.
    Last edited by Eduardo-; Jul 9th, 2017 at 10:50 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width