Solved Report Export as Pdf, Export as Excel and Export as Word.

[Michelle Michy]

If you have a lot of file and folder operations, you might find it easier in the long run to use the File System Object, which has simplified calls for a lot of what you are doing. The link gets you to the top of a documentation "tree" for FSO.

FileSystemObject object

Office VBA reference topic

learn.microsoft.com

However, there is another question. I looked at your posts but didn't see it mentioned. Are you using 32-bit or 64-bit Access? The problem you report sounds like you tried to use a 32-bit function in a 64-bit Access environment. If you search the forum for 64-bit Access, you will find lots of posts on using PtrSafe and other methods to keep everything quiet and happy.

Thanks. Working on it. I like this forum

 

[Uiltje]

I suggest you have a look at 4tops document creation using Microsoft Access. It supports all documents you require, Word, Excel, Pdf (also PowerPoint) and gives you full control over the documents you want to create including where data goes in the document. The wizard produces detailed VBA code.

​