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
I am trying to wrap VB code around a DOS program, and would like to be able to capture the output (stdout).
I can execute some of the functions of the program (Swish-E) using VB, but not all, and can not access the search results.
Any help appreciated
Cheers
Derrick
An excel file was created with column headers, so rows 1-4 contain column titles. These are not included with the sort.
When a column is sorted for the first time, the sort ignores the topmost record that should be included. Yet when the sort is repeated the outcome is as expected.
Any...
I need to read a file containing about 250,000 records, sort them, and write the resulting list to another file.
List boxes are restricted to an index of 32,767. Although I can enter more items in a sorted listbox and refer to them in order by reading the first index, then deleting it so that...
