Use the previous code I gave you but manipulate the filename to achieve the result you require, it's fairly simple to do and should need no further explanation.
Public Function MonthEnd() As Boolean
Dim myDate As Date
myDate = Date
myDate = myDate + 11
If Month(myDate + 1) > Month(myDate) Then
MsgBox myDate & " is the end of the month."
MonthEnd = True
Else
MonthEnd = False
End If
End...
I transfer my VB6 projects between home, (where I am on XP), and work, (where I was on Windows 98, now Windows NT), have have not yet had a compatability problem.
It would appear that there are no problems in transferring VB6 programs from one Windows system to another.
Derrick
This is the Object Oriented way of doing what you request, and is now the preferred method using the VB file object:
If the function returns True then the file was created, if it returns false then the file already existed or an error occurred.
You must put a reference in to Microsoft...
Thx to anyone who may have looked at this, I have managed to do it using the Outlook objects.
Refer to the address below on how to use it:
http://www.serverwatch.com/tutorials/print.php/1474711
Please regard this question as closed.
Title pretty much says it all, I would like to automatically convert PowerPoint documents to PDF using Visual Basic.
Also, is it possible to load an Excel document into a Word document using VB?
Thanks John,
the solution I have used is shown below, commented out lines can be used to add other options etc.
Sub SendMAPIMessage()
Dim MapiSession As Object
Dim MapiMessage As Object
Dim MapiRecipient As Object
Dim MapiAttachment As Object
Dim Recpt, errObj As Long, errMsg
Const...
Hi,
I need to convert MS Word, Excel and PowerPoint documents into PDF format. I have the full version 5 Adobe Acrobat application.
The PDF buttons appear in the other applications and can be used manually, but I need to convert files in a folder automatically.
I can read a folder and its...
Does anyone know how to automatically mail a document using VB, how to write a message and heading on the e-mail, and attach a document.
Thx in advance
Derrick
Further to the above, I have registered a COM object that I created using VB. I have then used the .dll file successfully in another VB program. Yet when I try to use the .dll with ASP it is totally ignored.
HELP!
I have created a simple .dll and registered it using regsvr32. I now want to use the COM object from an ASP page.
The object registers ok, but only if it is in "C:\WINNT\system". I thought it could be held anywhere but this does not appear to be the case (by using regsvr32...
I would like to know how to open a .pdf document in Adobe Acrobat using VB code.
I have the full version 5.0 of adobe.
If possible I would also like to be able to use SendKeys, but this is not urgent, yet!
Cheers
