Search results

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.

I'm just amazed with the macro. It's just working as expected. Thank you so much @Kenneth Hobson

I think I shouldn't have used random colors. There might be set of predefined 7 colors since I've 7 colors and the sequence of colors would be same.

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.

Ok. Got it. Thank you, I will try.

Ok. Will you please tell me how can I do that?

vletm, I didn't get you...

@vletm Yes, I just want to create scattered type graph from all columns and rows.

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...

Thank you, Hui! Just one query can we directly modify 1st table because ultimately I want this one to be modified.

Hi, I have main table with many columns. I have to map columns from 2nd table for given rows and add values in table1. Please find below attachments.

:awesome:Really I didn't think of this. Thank you so much!

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...

Thanks for pointing this out, I was not aware of this (that I should do this).

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).

Any help please...

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.

Hmm. You're right! But I am downloading large amount data when manually try, for one year, even Chrome does not load data. So thought of automation.

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...

Working fine, just needed to put code like this: Application.StatusBar = "Your message"

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...