Hello,
I have a super simple problem that I just can't figure out. I want to export data from an Access table to an Excel spreadsheet. I'm still pretty new to VBA, and I just can't figure out what I'm doing wrong here....
Here is the code I have written:
However, I am getting an error that states "Compile Error: Object Required."
Please Login or Register to view this content.
Can anybody shed some light on this?
Thanks!
Hi Forest,
I'd bet you don't have a folder on your hard drive named "PathNameHere"Look at the example on:
https://msdn.microsoft.com/en-us/VBA...-method-access
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Lol! I deleted the path before copying the code here. On my end the actual path name is included. Unfortunately, that is not the issue.Originally Posted by MarvinP
Hi Forest,
I'd bet you don't have a folder on your hard drive named "PathNameHere"
https://msdn.microsoft.com/en-us/VBA...-method-access
Hi ForestCruise,
You don't assign a string variable using "Set". It's just like so:
HTHPlease Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks