Forum Discussion
nserrano111
Apr 26, 2023Copper Contributor
Run-Time error "1004"
Hello, I hope I am able to explain this as best as I can. I am going through a tutorial to automatically create and save invoices. However, I am getting stuck on the part where it actually sa...
HansVogelaar
Apr 26, 2023MVP
It should be
.SaveAs Filename:=path & fname, FileFormat:=51
i,e. with := instead of =, and with FileFormat as second argument, not Filename again.
nserrano111
Apr 26, 2023Copper Contributor
okay, now it is saying that 51 is already specified... do I just keep it as .SaveAs Filename:=path & fname ?
- HansVogelaarApr 26, 2023MVP
It's worth a try!