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 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...
Please let me know the steps or utility to transfer the data from ms-access to the sql server when the table name and fields are different!!
Eg:
MS-Access table: ...
The "Step Into" command for macros in Microsoft Word does not work . The path I take is Tools >Macro>Macros>highlight the specific macro>click the "Step Into" box. The editor opens but nothin...
I have the following html tabular data and would like to create a macro to parse and put the data in a row of cells:
Data:
<div class="f2"><div class="f"><table class="t1"><tr class="rs2"...
I like to have a excel vba for
1) Excel VB to open CSV files and write them to mySQL database daily.
2) Automated to run at certain time.
3) ~ 1000 CSV files / day ( Approximately 10 colu...
hello!!
I need to create a method in excel VB that runs a HTA file. What would that look like??
my file is located at
M:\MAS90\Home\MAS90.hta
I am running Excel Macros for several other items in an Excel Sheet. Even with updating set to false (and then to true after my vb loops) my macro runs really slow. What is the best way to i...
I have the following code and breaks on the last line of code. However, if I go to the sheet and run it it runs without errors and can't seem to figure out why it won't run if the macro is ex...
I have 2 seperate instances of Excel open, which both contain open workbooks. How do I access a workbook that open in another instance of Excel? Can I access the contents of a workbook witho...
The code below looks at a cell value in one sheet. If it is a number (IsNumeric) and is greater than the value in another cell from another sheet then it is supposed to copy the cells from th...
In sheet1 I have items in column A and a number in Column B. In Sheet 2 I'd like to get a return of the item in column A with its total in column B...all while running in sheet2 using VB...e...
I have a form with a ListBox, shippingDateListBox. I wish to set the RowSource for it to a recordset definded as follows: Set mShipDate = db.OpenRecordset("SELECT USPSTracking.sDate FROM US...
I have created these file with keys from a excel file and need to know that the file had been created.
I have the following cells in Excel and write out the corresponding in a macro. Is there a way to read the cells and "dynamically" insert the operational (<=, >, <, etc..) part into an IF sta...
I have an if statement that is supposed to remove rows that is not within a specified range (given by the last two columns. However, it is not working correctly...code and example data below:...
Sheet1 and Sheet2 have items in column 'A' that unique keys. I want to update Sheet1 with new columns (starting at the first available column). e.g
Sheet1:
Item Price Desc
Bill 15 ...
I have a vb string for example:
<start> hello how are you doing <end> <start> I am doing fine <end>
I would like to get the contents in between '<start>' and the first '<end>'. What is...
I have data similar to this but with thousands of rows and would like to find the quartiles of the same type (from column A) and their values (column B) using a macro:
Sheet1:
Name Valu...
hi,
what I want to do is to create a serie of variable in a loop in order to save time and typing.
for example:
sub myloop()
for i =1 to 5
variable(i) = 7+i
next i
So in this si...
I want to do the following:
If any cell in column c has anything in it, then I want the numbers in column d to be negative numbers. They all have positive numbers now. I have battled with...
I have the following string (as an example) and want to extract the highest integer only from the "High" column (the 3rd column) using vb:
<table width="100%" cellpadding="2" cellspacing="0...
This would seem to be fairly simple, but I can't make it work. Using VB.Net 2005 Windows Form.
I have a text box and an exit button on the form. If the user changes something in the text bo...
Hi, I found this code on the net, what I need is for the timer to start if a cell value is 0:00 (h:mm) and stop when it is anything but 0:00 in which case it should rest itself to 0:00 .
Th...
Hi,
I have some code in Visual Basic 6 that will retrieve/save an Excel file, open the file, and perform a macro on the file. I am having an issue closing the Excel file after the the macro ...
