troubleshooting Question

Macro in Access to format Excel

Avatar of slatefamily
slatefamily asked on
Microsoft Access
10 Comments1 Solution428 ViewsLast Modified:
I am working on a macro in Access to format a spreadsheet in excel.  Right now I noticed that the print preview was cutting off some columns I recorded a macro where I did a page break and added in the all the columns in the view.  I am getting an error .

Compile Error:  Method or Data member not found
With xlWS
    .View = xlPageBreakPreview
    .VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
    End With
NorieAnalyst Assistant
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
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 10 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