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...
Dim connectionString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Application.StartupPath & "\Inventory.mdb;" & _
"User ID=Admin;" & _
...
Hi, I managed to do the following in Excel's VBA environment:
1) Open Powerpoint (if not already open)
2) Open specific Powerpoint file (if not already open)
3) Loop through slide 2-6 and...
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...
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 ...
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 ...
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...
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 ...
Several users of the attached workbook and add in are getting this error: Run-time error 1004: Unable to set the text property fo the Characters Class. Any ideas why? Other users don't get it ...
I wrote a macro that formats pasted data and then adds page numbers to the footer. In the original workbook that I created the macro it works perfectly, adds the pages numbers no problem. I th...
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 ...
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 ...
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...
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...
Hello,
Does anyone know if it's possible to remove duplicates from a name list? My data is set up very much like it is set up on this contextures spreadsheet.
http://www.contextures.com/...
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...
Hello;
I had a VB Program which got compiled in Windows-XP-Professional - Visual Basic 6.0 and created a new package via 'Package & Deployment Wizard'
Installed in my m/c and in few oth...
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 everyone.
I have another one of those leading zero problems with excel and csv files. I currently have a script that runs and pulls in a csv file, cuts half the fields out, shottens one of...
I want to be able to print multiple pdf files from within Visual Basic 6.0 without the user having to interact with the print dialog box. I get the filepath and name of my pdf files from a re...
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 get the above message when running the included macro. The macro works well until the end when it shows the error message. Please help. You'll notice the comments in the code. I'm a begi...
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...
Hello!
I hope you can help me with this problem:
Say I have an array that is called
Dim test1 as Variant
test1= Array("BFM", "JAG", "JNR")
And I want to delete "JAG" from the ar...
