VB export data to EXCEL and automatically save the file-CodePudding

Home > Software engineering > VB export data to EXCEL and automatically save the file

VB export data to EXCEL and automatically save the file

Time：10-25

At the time of export data to EXCEL, some machines can be saved successfully, some of the machines will be prompted to the following error, I do not know where I went wrong, how to change? (data can be successfully exported to EXCEL, but is not automatically saved)

XlBook. SaveAs FileName:=App. Path & amp; "" & amp; StrFolder & amp; "" & amp; StrFilename & amp; ". XLS ", FileFormat:=xlExcel8

Page link：https//www.codepudding.com/Softwareengineering/72152.html

Prev:VB how to modify the TXT text document a row

Next:Found no public class components can be created

Tags：

VBA

Links：
CodePudding