I want to extract X, Y and Z values from xml element <output name="BoundingBox">. There might be multiple instances of this element in same file, so I want to repeat the same.
Here is the link from Stackoverflow...
Just add formula =CONCATENATE("copy ",C2,"\",A2," ",D2) into cell "E2" and autofill it down. Open cmd from Start and copy paste all formulae in cmd. You're done.
Running these formulae from "E" column into cmd can be automated using vba, if needed.
Hi,
I've 7 columns and having many rows and want to highlight same values in each rows and apply some random color. Here I want to compare all values separately in each row. Have added image to illustrate things.
I have names of files in "A" column with 24000 file names and B column onward have column headers. Columns have numerical data. I want to plot line graph but as columns has more than 255, excel gives error says max. allowed is 255 only.
Can please help/suggest me to generate chart from this...
Hi All,
I have macro that is adding countifs formula across 450 columns and 3000 rows. Being around 13,00,000 formulas, it's taking too much time(I do not know how much it's taking since I interrupted it in between). Any alternative in vba to accomplish this work.
I am attaching spreadsheet...
With above change, test1 and test2 sub don't know value "i". So what I did is put value of "i" in one of the sheet and accessed that cell value instead of "i" in sub test1 and test2. With this I could run Main sub in loop.
Hello,
I want to declare integer values say 7 to 13 globally and iterate all sub macros from 7 to 13. How can I do that?
Because my sheets and folder names (from which i am importing data) are ending with number.
e.g. PartData7, PartData8 etc. and H:\FeaturesData\data\7...
I have below code which opens web page, calls java-script function. What next I want is: Switch to iframe named displayFrame. Then select options in drop-downs. Currently I am unable switch to iframe and add values in form. I am new to this, so need your help.
Iframe code:
<frame...
I did ask them, they are providing data. I can also download manually which requires some time but I was thinking automating it as we require data with different option like date or etc.
With above code it's just not hitting OK button (on second navigated web page).
It's really cumbersome to download data manually for 10 years. It's not possible to get solution, if posssible, from GTAC, so can someone please help me.
I have code where IE loads the web page, calls java function.
But I am unable to hit button or call associated function. Then I want to save .csv file from displayed page.
Thanks in advance.
Option Explicit
Sub SaveHTml1()
Dim str1, str2, str3, str7, URL As String
Dim ie, frm As Object
Dim i As...
I have many interconnected macros. I would like to show the macro name (if possible theis sequence no.) while running macros.
Sub FeatureNameandTimestamp1()
Application.ScreenUpdating = False
Columns("C:C").Select
ActiveWindow.SmallScroll Down:=-24
Selection.Replace...