I'm attempting to manipulate an excel spreadsheet from within Access (add worksheet, move worksheet, rename worksheet, alter cells, save, etc).
Quite often when I open the spreadsheet from within Excel to see if I was successful in programming from Access, I get a message that the spreadsheet...
I remember reading that there is a property that can be set when you open a spreadsheet that suppresses user qustions such as 'Do you want to save?'.
Don't remember what it is.
Anybody remember?
Thanks
I have a program that reads an Access database and write email Contacts to Outlook.
Unfortunately there are about 9,000 names. This takes at least 30 minutes to write.
Since Outlook displays the names in alphabetical there must be some type on indexing taking place during writing the contacts...
I'm attempting to do some programming from MS Access to Outlook or Outlook Express.
Can anybody explain to me the difference between local contacts (or address books) in either?
If both are installed on the same computer, do they share the same Contacts and Address Book or are they separate...
Is there a Folder property in Outlook 2000 that is the equivalent of Shos asOutlookAB.
I am creating a folder, populating it with contacts and I would like it to appear as an address book folder when creating email messages.
Thanks.
This is odd.
Programatically I've figured out how to add contacts to the contacts folder.
I' ve figured out how to add a sub-folder withing the vontacts folder.
I moved contacts from the root folder to the new sub-folder.
Now the problem.
When I go into Outlook and create a new email...
I am attempting to write code in MSAccess to do the following in Outlook.
I've been able to write contacts to the default contact folder (Code1).
I've been able to create a new folder within the contacts folder (Code2).
What I cannot figure out how to do is create the contact items in the...
I'm using MSAccess 2k and Outlook.
I have been able to write (and/or delete) contacts from Access to Outlook.
The end result is that I would like to have all of the newly added contacts placed in one Distribution List for email purposes.
The emails will eventually be sent using Outlook so...
I am using MSAccess 2000 and Acrobat 6.0
I have several reports using the 'Adobe PDF' printer.
I added a port to print the pdf files to a scecific directory.
I have set Adobe PDF settings:
View Adobe PDF results - Off
Prompt for Adobe PDF file name - Off
Ask to replace existing...
I am using MSAccess 2000 and Acrobat 6.0
I have several reports using the 'Adobe PDF' printer.
I added a port to print the pdf files to a scecific directory.
I have set Adobe PDF settings:
View Adobe PDF results - Off
Prompt for Adobe PDF file name - Off
Ask to replace existing...
For learning purposes I am looking for some VBA (VB) programming examples using some of the CAcroPDDOC functions.
I have used a few such as Open, Save, InsertPages, DeletePages, GetNumPages.
The ones I am specifically interested in are AcquirePage, Create, ReplacePages, MovePage and any...
I am attempting to save part of a PDF into an new document using VBA in MSAccess 2k.
I realize I can open a PDF document, delete unwanted pages and save with a new name. I've done that.
I would like to try to open an existing document, create a new document, then insert the desired pages into...
I am attempting to open directly an Excel spreadsheet and retrieve data from various cells (one at a time) in the spreadsheet using DDE.
Linking as a table causes problems with data types and cells containing more than 255 characters. I would like to try DDE.
I have been able to initiate a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.