Hello All,
I have managed to create a sub that will add an appointment to outlook calendar.
However I want to be able to create a new calendar and add appointments to that one.
Have been ...
I need to create a utility in VB 6.0 (for yesterday) that runs through all the subfolders of a specific folder eg C:\Backup. It needs to look for all files in each subdirectory with an ".ini" ...
The VB.Net File Copy and Move commands are easy to use if you want to rename the files.
Dim fFile1 As New FileInfo("C:\\abc1.txt")
fFile1.CopyTo("C:\\abc2.txt", True)
Dim fFile1 As New Fi...
run-time error '2147417851' (80010105') method of 'open' of object 'workbooks' failed while opening excel -workshooet in vb 6 program
program coding
-----------------------
Private S...
First, I am completely incompetent at VBA, so absolutely any help is greatly appreciated. I've created an Excel VBA UserForm that allows the user to select a name from the 1st ComboBox & that...
When an Excel sheet with Macros is passed from one PC to another, it may not work due to broken or missing preferences.
Ideally I would like to check for broken links, remove them, if possibl...
I have a folder that has files, I would like to move it to another location. My source is "C:\Hold\050108" and I would like to move it to "C:\Data\". The problem is that each day, a new fold...
How do I find a number in a specified string of characters? I am looking for an "M" immediately followed by 9 numbers (any numbers) within a string.
strFid = Mid(sBuffer, intCounter, 10)
...
I am comparing to excel worksheets. It seems to work fine. I am comparing name and size. The size part works fine but when comparing the 2 names it comes back that they are not equal, even tho...
i need to make vba program of value at risk. i tried to make it,but it is too hard for me..Dose antone have idea? any help is appriciated!
what is the code in VB to get current user logon in windows?
here is the code I am using
Function GetUserName() As String
If TypeOf My.User.CurrentPrincipal Is Security.Principal.Wind...
Hi,
I have a device that generates its logging in one continuous stream using using the pipe " | " character to distinguish one entry from another.
What I want to do is run a script ag...
Dim crystal As CRAXDRT.Application 'FOR LOADS REPORT FROM FILE
Dim report As CRAXDRT.report
' Ejemp:
your_variable = klave.Text 'if your parameter is a value in a textbox
Set cr...
Hi Experts !
I have just migrated my web server from the 2000 to 2003 . My sites uses VB dll that reads values from registery and creates a connection string and opens a connection to the ...
I am using an old version of an accounting program that stores it numbers as a 7 byte string.
I convert the string to a currency value using the following code:
===========================...
Hi
I am creating a report in my access application and need to merge cells in the report the following code won't work the syntax is wrong help much appreciated. The output is dependant on th...
I need to find and select the first cell in a row that contains a formula. The previous cells in the row contain values that were generated by the formula and then pasted.
I have a document with a table. I need to put the interleaving text to 0 on every cell of the table. I need to do this by programmation from Visual Basic 6 By interleaving I mean the space bet...
Is there a VBA code that can look to a cell with a date entered in text format "Sep-07" for example and automatically change it to the next month in text format "Oct-07". Then when it sees "D...
I am a developer for VB6 applications. I have developed a pos system that needs to print to a receipt printer on occasion. I don't want to change the default printer settings but have all rece...
I have a MSHFlexGrid. Visual Basic 6.0
6 rows, 7 columns. 42 cells. Fixed as such.
I have a loop that can range from 1 to 42.
Depending on the loop count, I want to fill the grid one cell ...
I have an Visual Basic application that utilizes an AxWebBrowser. How can I detect if a submit button has been clicked in the AxWebBrowser to trigger an action in the application.
I am receiving a very generic windows error from one of my users. I do not expect that anyone will be able to provide a specific solution. I am requesting advice on how to proceed to try and i...
I want to create a calendar program in VB.net , before that I need to populate the date details in to the XML format....Format should be the following,
<Calendar>
<Year>
<Month>
<Day>
</d...
I have a macro to convert numbers with decimal places in column A to whole integers. I want the macro, if ran, to do nothing if column A contains no data. This macro is ran when a custom but...
