Snapshot (legal size)

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
I have a routine I took over running in access. It exports to snapshot. When I run the macro it exports the report to snapshot but does not make it legal size. Chopping off part and putting it on another 8*11 landscape.
When I export without the macro it goes to legal in the snapshot viewer. What is the Macro missing or is there some know why this is happening.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Hey,

Care to post the macro? I'm not promising anything but that will help!

I wonder, is it really necessary to send to snapshot? What purpose does this serve?

Do you need to convert a report to a graphic, or something to that effect?

Hope we can help,
 
Upvote 0
OpenReport DOMBO 29 - BSW DAILY BACKORDERS - NEW VERSION
OutputTo n:/Backorders/BSW Daily Backorders.snp
Close
OpenReport DOMBO 97 - BSW DAILY BACKORDERS BY RANGE
OutputTo n:/Backorders/BSW Daily Backorders by Range.snp
Close

Any help is appreciated
 
Upvote 0
Oooh,

I didn't realize it was code like that. What is snapshot(I'm guessing an image maker/viewer), maybe if no one around know how to work with that code, we can set something up in Access to do what you need.
I'm thinking something as simple as a report that looks like whatever snapshot was giving you.

Sorry I couldn't be more help.

Let us know about snapshot though, there's always the hope of a work-around,
 
Upvote 0
Upvote 0

Forum statistics

Threads
1,221,510
Messages
6,160,226
Members
451,632
Latest member
purpleflower26

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top