Re: $$Excel-Macros$$ Re: Data-Import External Data-New web query
Dear Muddan What changes in file? Not working file as per my requirment Regards amar On Fri, Apr 11, 2014 at 8:55 AM, Muddan Madhu muddanma...@gmail.com wrote: find the attached file On Thursday, April 10, 2014 2:30:10 PM UTC+5:30, amar takale wrote: Dear Muddan Pls help me on this small issue. Regards Amar On Wed, Apr 9, 2014 at 5:26 PM, amar takale amart...@gmail.com wrote: Dear Sir Thank very much... Regards Amar On Wed, Apr 9, 2014 at 5:12 PM, Muddan Madhu mudda...@gmail.com wrote: replace For I = 0 To TbleID.Rows.Length - 1 For X = 1 To 8 ActiveSheet.Cells(I + 1, X).Value = TbleID.Rows(I).Cells(X).innertext Next X Next I you have to use shell control to work on selected data to populate On Wednesday, April 9, 2014 10:39:05 AM UTC+5:30, amar takale wrote: Dear Muddan Thanks alot.its perfect. Can we extract data with heading name as per my selection cell point where I select cell then data extract from that cell. Regards Amar On Wed, Apr 9, 2014 at 8:17 AM, Muddan Madhu mudda...@gmail.com wrote: Try this Option Explicit Sub GetDataFromWeb() Dim STR As String Dim IE As Object Set IE = CreateObject(InternetExplorer.Application) STR = http://www.investing.com/indices/major-indices; Dim I As Integer, X As Integer IE.Visible = True IE.Navigate STR While (IE.Busy Or IE.ReadyState 4) DoEvents Wend Dim TbleID As Object Set TbleID = IE.Document.getelementbyid(cr_12) For I = 1 To TbleID.Rows.Length - 1 For X = 1 To 8 ActiveSheet.Cells(I, X).Value = TbleID.Rows(I).Cells(X).innertext Next X Next I IE.Quit Set IE = Nothing End Sub On Tuesday, April 8, 2014 3:03:58 PM UTC+5:30, amar takale wrote: Dear Experts, I want to below link attach in excel for data import (Data-Import External Data-New web query).I will try it but not working.After Import data in excel Then automatic refresh in excel. http://www.investing.com/indices/major-indices Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor
Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file
Dear Ashish sir Pls help me on this solution. I would appreciate very much Sir Regards Amar Takale On Mon, Apr 7, 2014 at 4:47 PM, amar takale amartak...@gmail.com wrote: Dear Expert team can anyone give me solution on this topic? Regards Amar On Wed, Apr 2, 2014 at 12:59 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).there are more than two table with different range.I want all table copy paste in one word file one by one below after one click button. Single Excel sheet one table 1) I will create button click then automatic table copy paste in word.(First data range fixed of table).code not asking for select range. As always Thank you all for your help. I greatly appreciated it. Regards Amar On Wed, Apr 2, 2014 at 12:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Actually it show like Missing: Microsoft Word 14.0 Object Library Attached screen shot here Regards Amar On Wed, Apr 2, 2014 at 12:09 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Press alt + F11 then go in tools then reference select Microsoft Word 14.0 Object Library library number can b 12.0 or else. Please see attached excel file. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi ravindervbacli...@gmail.com wrote: have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library in Tools-reference option but show it as Microsoft Word 11.0 Object library Pls look in this issue. Regards Amar On Mon, Mar 31, 2014 at 5:39 PM, Ravinder ravindervbacli...@gmail.com wrote: Note:- add word library Microsoft Word library This is simply copy and paste value from excel to word and you need to select range (will be asked by program) which you want to transfer in word Sub Button1_Click() Dim wrd As New Word.Application Dim doc As Word.Document Dim RNG As Range Set RNG = Application.InputBox(Please Select Range to Transfer in Word:, Type:=8) Set doc = wrd.documents.Add wrd.Visible = True 'if you dont want to show wrd application then just use false instead of true RNG.Copy wrd.Selection.Paste Set tbl = doc.Tables(1) doc.SaveAs2 ThisWorkbook.Path \ ActiveSheet.Name .doc 'change save as path as per ur requirement End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, March 31, 2014 3:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA Code to Import Excel table in Word file Dear Ashish Sir, I learned many VBA work from your Code which is a lot of time saving easy to do. Before one week on our excel forum one topic discussed as (Macro to Import Word Tables to Excel from a folder). I got code from word to excel but I required excel to word.I use excel 2003. Can you share code excel to word table as proper in one sheet with respective sheet name. I would appreciate very much if you can help me on this. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE
$$Excel-Macros$$ Need a help on sumproduct for MTD data
Hi Team, Kindly help me out to do sumproduct the data for MTD. (monthwise). Please find the attachment for your reference. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. sumproduct.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Problemi di sincronizzazione una macro
Salve a tutti! Non riesco proprio a cavarci le gambe...Quando si usa il comando 'SHELL' per eseguire una funzione esterna di sistema, come si può sapere se questo comando ha avuto buon esito oppure se ci sono stati errori? Io sto provando ad effettuare un upload da Excel mediante il comando: Shell ftp-s: MyFileTxt in generale la cosa funziona, ma, in assenza di connessione, ad esempio, potrebbe fallire: come faccio a sapere, dentro la macro Excel, se l'upload ha avuto successo? Detta in altre parole, esiste la possibilità di intercettare l'evento che segnali la conclusione dell'esecuzione di un comando esterno all'ambiente VBA, ma lanciato in modalità shell da una macro VBA? grazie per il vostro prezioso aiuto Stefano -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Cell value distribution formula
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Quantity distribution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need a help on sumproduct for MTD data
=SUMPRODUCT(($B$2:$DC$2=B9)*($B$4:$DC$4)) On Fri, Apr 11, 2014 at 4:50 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, Kindly help me out to do sumproduct the data for MTD. (monthwise). Please find the attachment for your reference. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
RE: $$Excel-Macros$$ Need a help on sumproduct for MTD data
Hi Ganesh, Use the below formula. For Forecast 1 =SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$4:$DC$4) For AHT =SUMPRODUCT((MONTH($B$3:$DC$3)=MONTH(B$10))*$B$5:$DC$5) Regards, Excel Beginner From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ganesh N Sent: Friday, April 11, 2014 4:50 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a help on sumproduct for MTD data Hi Team, Kindly help me out to do sumproduct the data for MTD. (monthwise). Please find the attachment for your reference. Thanks Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.