I have an Excel 97 work sheet with 39 tabs. Each tab is a performance profile for an individual. At month-end, I print each sheet to a pdf file (i.e., I have Adobe Acrobat 4.0 installed). Once I select Adboe Distiller in the print dialog box, adobe asks me where to save the pdf file. I select the network directory and then the file. Since I’m usually overwriting last month’s pdf file, Adobe asks if its okay to overwrite–I select yes. Then Acrobat shows me a preview of the pdf file. I click okay and close acrobat (i.e., if I don’t close Acrobat after the 20th or so printing my system hangs as it is out of memory–Win 98SE 256Meg Memory; 500Mhz Celeron). This process is repeated for all 39 tabs. I am starting to learn about VBA in Excel but wonder if it can handle a “hand-off” to another program (i.e., Adobe Acrobat) and then take control again once Adobe is finished to then print the next worksheet tab. Can this be done as an excel marco or do I need the full blown version of VB 6.0 to accomplish this task? THANK YOU
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Macro printing to Adobe pdf file
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Macro printing to Adobe pdf file
- This topic has 1 reply, 2 voices, and was last updated 24 years, 2 months ago.
AuthorTopicJimmyc5559
AskWoody PlusMarch 23, 2001 at 12:58 pm #354209Viewing 0 reply threadsAuthorReplies-
WSVBNerd
AskWoody LoungerMarch 23, 2001 at 1:08 pm #519998I had a similar problem with Word. All documents in a specific folder had to be converted to PDF files so a group of Unix users could read them. The conversion had to happen on a regular basis. I had to resort to writing a VB app that automates Word.
You can set up distiller to watch a folder for postscript files and convert them to PDF files.
I then had my VB program fire up Word, print each document in the folder to a postscript file. Set a timer in VB to check on the printer spooling in Word. When Word was done, shut Word down.
The distiller would convert all the files in the folder to PDF files.
Granted, there may be a simplier solution, but I haven’t found one or bothered to find out now that this is working.
Mike
Viewing 0 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Login screen icon
by
CWBillow
4 hours, 47 minutes ago -
AI coming to everything
by
Susan Bradley
54 minutes ago -
Mozilla : Pocket shuts down July 8, 2025, Fakespot shuts down on July 1, 2025
by
Alex5723
12 hours, 15 minutes ago -
No Screen TurnOff???
by
CWBillow
12 hours, 37 minutes ago -
Identify a dynamic range to then be used in another formula
by
BigDaddy07
13 hours, 10 minutes ago -
InfoStealer Malware Data Breach Exposed 184 Million Logins and Passwords
by
Alex5723
1 day ago -
How well does your browser block trackers?
by
n0ads
11 hours, 4 minutes ago -
You can’t handle me
by
Susan Bradley
3 hours, 31 minutes ago -
Chrome Can Now Change Your Weak Passwords for You
by
Alex5723
3 hours, 41 minutes ago -
Microsoft: Over 394,000 Windows PCs infected by Lumma malware, affects Chrome..
by
Alex5723
1 day, 12 hours ago -
Signal vs Microsoft’s Recall ; By Default, Signal Doesn’t Recall
by
Alex5723
15 hours, 38 minutes ago -
Internet Archive : This is where all of The Internet is stored
by
Alex5723
1 day, 12 hours ago -
iPhone 7 Plus and the iPhone 8 on Vantage list
by
Alex5723
1 day, 12 hours ago -
Lumma malware takedown
by
EyesOnWindows
1 day ago -
“kill switches” found in Chinese made power inverters
by
Alex5723
1 day, 21 hours ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
1 day, 21 hours ago -
Meet Gemini in Chrome
by
Alex5723
2 days, 1 hour ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
2 days, 1 hour ago -
Trump signs Take It Down Act
by
Alex5723
2 days, 9 hours ago -
Do you have a maintenance window?
by
Susan Bradley
14 hours, 13 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
1 day, 11 hours ago -
Cox Communications and Charter Communications to merge
by
not so anon
2 days, 12 hours ago -
Help with WD usb driver on Windows 11
by
Tex265
2 minutes ago -
hibernate activation
by
e_belmont
2 days, 21 hours ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
3 days, 1 hour ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
3 days, 4 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
3 days, 4 hours ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
2 days ago -
Out of band for Windows 10
by
Susan Bradley
3 days, 9 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
3 days, 16 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.