troubleshooting Question

Exporting Excel Info to Access DB w/VBA - Export Cell Value Instead of Formula?

Avatar of Mikayla
Mikayla asked on
Visual Basic Classic
12 Comments1 Solution222 ViewsLast Modified:
Hello!  I am writing VBA code to pass information from an Excel spreadsheet to an Access database.  A few of the Excel cells have calculations, but the value does not pass into Access.  Only a zero or a 1 will pass. (?)  How can I get the cell value to pass?

Here is one of the lines:

!PercentOverall = ws.Cells(86, 3)

Do I need to somehow specify "value" when I reference the cell?

Thanks for any help/insight!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros