Re: $$Excel-Macros$$ Macro error in opening file

I tried that option... When I am using Workbooks.Open (path & MyFile) Then my loop is going in infinity and every time it is reopening the first file only.. Which 04 L1. Xlsx Pls suggest On Apr 28, 2016 11:02 AM, "Abhishek Jain" wrote: > In your first macro, instead of: > > Workbooks.Open (My

Re: $$Excel-Macros$$ Macro error in opening file

In your first macro, instead of: Workbooks.Open (MyFile) use: Workbooks.Open (path & MyFile) HTH On Thu, Apr 28, 2016 at 9:26 AM, Secret Shot wrote: > Hi all, > > Can anybody pls look into it. I am really hoping that I will get > resolution from this forum. > On Apr 28, 2016 1:35 AM, "Secre

Re: $$Excel-Macros$$ Macro error in opening file

Hi all, Can anybody pls look into it. I am really hoping that I will get resolution from this forum. On Apr 28, 2016 1:35 AM, "Secret Shot" wrote: > Dear Experts, > > I want to open all files in a folder with suffix of "L1", where i have > below files in a folder > > 04 L1.Xlsx > 04 L2.Xlsx > 05

Re: Re: $$Excel-Macros$$ Excel VBA code to handle "choose file to upload " window in internet explorer

Hi All, In my project I am having a requirement to upload file from IE browser browse button. We are invoking this browser through macro in excel VB. HTML code for webpage is :- please share VB code to select any file from my system. Gaurav On Sunday, May 12, 2013 at 2:33:26 PM UTC-7, Matha

$$Excel-Macros$$ Macro error in opening file

Dear Experts, I want to open all files in a folder with suffix of "L1", where i have below files in a folder 04 L1.Xlsx 04 L2.Xlsx 05 L1.Xlsx 05 L2.Xlsx 06 L1.Xlsx 06 L2.Xlsx I want macro to open Only files which contain "L1", (Means 04 L1.Xlsx, 05 L1.Xlsx, 06 L1.Xlsx). I created 2 macros but b

Re: $$Excel-Macros$$ Applying formulas in large number of rows using VBA

Hi Victor, Thanks for your input. i am using the following code. Sub filldown_basedonA() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim LastRow As Long With ActiveSheet LastRow = .Cells(.Rows.Count, "A").End(xlUp).row .Range("C2:C"

$$Excel-Macros$$ Finding Overlapping dates

Hello Team, I need a help to fit in a formula to find if there are any overlapping dates for multiple date range. Please note that column can increase or decrease. Attached is the sample spreadsheet. Thanking in advance. Regards Atul -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

Re: $$Excel-Macros$$ Screenshot in different designs

Thanks.. On Wednesday, April 27, 2016 at 12:50:04 PM UTC+5:30, Abhi wrote: > > Try searching for something like "screen capture with effects" > > BTW, the TNT Screen Capture tool has paper-tear effects like the one in > your example. > > > > On Wed, Apr 27, 2016 at 12:31 PM, Pravin Gunjal > wrot

Re: $$Excel-Macros$$ Screenshot in different designs

Try searching for something like "screen capture with effects" BTW, the TNT Screen Capture tool has paper-tear effects like the one in your example. On Wed, Apr 27, 2016 at 12:31 PM, Pravin Gunjal wrote: > Dear Friends, > > This is apart from excel knowledge, I would like to know to how to ta

$$Excel-Macros$$ Screenshot in different designs

Dear Friends, This is apart from excel knowledge, I would like to know to how to take such different designs screenshots: Attached one example. Please confirm. Thanks, Regards Pravin Gunjal -- 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) ! Jo