What would be the VBA code for a macro in Excel that clears the contents of all cells in a range that were populated by a formula that said return "". (=IF(I2=0,"",H2)))
I want to clear the...
Hi,
How do I check if the current date is between 01/01/current year and 31/01/current year?
Looking at the data below I need to check if..
Date is between start and end of Jan. If s...
Hello,
I am trying to reset some global variables that are currently maintaining their values from the previous execution of the code. Does anyone have any simple solutions to this probl...
I have the following VB 6 code (w/Office 2000) which is to load an XLS file and create a chart of the data in column F, rows 10 to 85. When I launch the program and run the SubProgram once it ...
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 have a VB6 application, running under Windows 2000.
The application reads data from enormous text files - 5 million records. The files are on DVD. The program runs in batch mode (overnigh...
I have a database, whose data I have managed to extract to Excel. I now need to combine the address from B to Cl, there are over 4000 rows to work on so I need a to use a macro/ visual basic i...
Hey Guys!
I'm writing a programming in Excel using VBA. For one part of the program, i need the program to access outlook and export the data from the open excel workbook to the calendar fo...
Hello and thank you in advance for your help. Would this be possible?
I'm trying to create a macro that copies data from one excel worksheet into multiple other worksheet tabs in the same ...
I am trying to mark column B for all rows starting with 1's (1,11,21,31 etc) with the number 1. Here is the code I have so far; but it just adds 1 for all rows of column B.....offset does not ...
I need to create a macro that will identify and copy unique data from one workbook to another.
There are 6 different worksheets that have data in them from different sources. In each worksh...
Dim connectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Application.StartupPath & "\Inventory.mdb;" & _
"User ID=Admin;" & _
...
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" ...
I have a routine text file that is supplied in comma delimited format. Each field is set off with quotation "" marks; however, the total columns are all grouped together in quotation marks, b...
Hello to all,
I'm using a VB code in 100 excel files(in one folder).
This code will save a back up copy everytime the data is change.
Can I somehow autoenable macros, so I wont get everytim...
Hi im really struggling on this one, I have vba code written in an excel sheet but my manager is insisting i insert the results into a word form and then email this form, i have managed to do ...
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...
I'm using VB6 and I want to use date function to work with Months like (Jan, Feb ....) would you please advice how I
can do this
Mostafa
Hello,
I need to copy entire rows from an excel sheet to another sheet in the same book. I need to do thir based on the value in a spesific column.
Exsample: ...
This code produces and error in vb 2005 .net 3 framework. How do I get the textbox which is an Access database backend and text datatype to show 45.00 rather than 45 I don't need the Currenc...
Using VBA withing MS Word (Office 2000 onwards).
I would like to save a temporary copy copy of the current document, which I will later check into Sharepoint 2001 using PKMCDO.
I cannot ...
run-time error '2147417851' (80010105') method of 'open' of object 'workbooks' failed while opening excel -workshooet in vb 6 program
program coding
-----------------------
Private S...
Hi Experts
I am trying to write a Auto Form Fill and Submit application using visual basic 6. I need to get the data to be submited by running a for loop. ie.. to iterate and submit new for...
Team,
I have been creating SQL queries in MS Excel using the .dqy extensions created when I go to Data > Import External Data > New Database Query or Edit Database query. As I've been succe...
I use
Range("A1").CopyFromRecordset rs
all the time to dump a recordset to a spreadsheet and it works fine. But I need to copy just one field at a time from a recordset with several fields...
