HI Paul.,
Thanks for your ideas, it worked.
As suggested by you, I have changed naming convention so that each filename
must be unique.
Really appreciated.
Regards.
Yours Sincerely,Nitin Balodi
Date: Thu, 4 Sep 2014 06:17:46 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Ass
Okay so I tried to do this on my own. Which in someways was good learned
somethings. On the flip side I have aged 30 years and have pulled half my
hair out. I have tried to get the information to input on the form put I
can not get it in how I would like it. It is all going in the same row and
Thanks Paul. Let me check on this.
Regards,
Ganesh N
On Thu, Sep 4, 2014 at 11:29 PM, Paul Schreiner
wrote:
> Have you tried recording a macro?
>
> When I recorded macros, I came up with:
>
> Sub Open_Macro()
> Workbooks.OpenText Filename:="C:\temp\mfg_appl_log.txt", Origin:=437, _
>
Hi Joshi,
PFA.
On Thu, Sep 4, 2014 at 10:20 PM, Nagendra Joshi
wrote:
> Dear Team,
>
> Please find the enclosed file which contains many sheets but i need a
> solution regarding the first & second sheet.
>
> First sheet is a dump which is directly entered by the fi
Hi LJ,
Follow the below mentioned simple steps to pull up the values of Column G.
- Select the data G2 to G1048576 (mean to say: select the G column data
from G2 to till last the column, Don't select G1 to G1048576)
- Press F5
- Click on Special button
- Select Blanks
- Press O
Have you tried recording a macro?
When I recorded macros, I came up with:
Sub Open_Macro()
Workbooks.OpenText Filename:="C:\temp\mfg_appl_log.txt", Origin:=437, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semi
I update the attached sheet. As you can see there are additional values in
the first 3 columns that will be affected if everything is shifted upward
by using the F5 solution. Thanks again for any help.
Best,
LJ
On Thursday, September 4, 2014 12:57:11 PM UTC-4, LJ wrote:
>
> Hi Everyone!
>
> I
Dear Paul,
Thanks for your reply. your rite but i have to open by macro because i have
to do some automation after i open the .txt file to excel.
Kindly help me how to open the .txt file using macro. I mean code to open
and save the same.
Thanks & Regards,
Ganesh N
On Thu, Sep 4, 2014 at 10:45
Dear LJ,
Can you please share the little detail about your requirement ? with some
other sample ?
Thanks & Regards,
Ganesh N
On Thu, Sep 4, 2014 at 10:40 PM, LJ wrote:
> Ganesh,
>
> Thanks for the reply. When I do that the other products beneath are left
> without values in columns 4 and 6.
>
I'm sure I must be misunderstanding the question.
Assuming your text file has a .txt extension:
Why don't you simply:
launch Excel
File->Open
Change file types to: "Text Files (*.prn;*.txt;*.csv)
do whatever formatting is applicable
when saving, the file should default to .txt
so, what
Ganesh,
Thanks for the reply. When I do that the other products beneath are left
without values in columns 4 and 6.
On Thursday, September 4, 2014 1:08:02 PM UTC-4, Ganesh N wrote:
>
> Hi LJ,
>
> Just select the data -> ctrl + G -> special -> blanks -> ok - > right
> click - > delete - > Shif
Hi LJ,
Just select the data -> ctrl + G -> special -> blanks -> ok - > right click
- > delete - > Shift cells up.
Thanks & Regards
Ganesh N
On Thu, Sep 4, 2014 at 10:27 PM, LJ wrote:
> Hi Everyone!
>
> I am working on a sheet where I have the Product listed in Column A, app
> in Column B and
Hi Everyone!
I am working on a sheet where I have the Product listed in Column A, app in
Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run
into is column 4 and Column 5 have values that don't line up with column 6.
Basically, I don't want to have to drag all the values f
Dear expert,
I want to open the text file in excel (copy all the data from text file)
and have to do some computation on excel and again I need to save the excel
file to text file. I need to know how to open the text file (or how to copy
the data from text file) and how to save the excel data to t
Thanks,
I did not do this for you. God is here working through me for you.
On Thu, Sep 4, 2014 at 5:35 PM, Sunil Kumar Yadav
wrote:
> Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample
> for understanding.
>
>
>
>
> *Thanks & Regards, Sunil Kumar Yadav*
>
>
> On Thu, Sep 4
Anyways.. its Ctr + Shift + 7 .
Cheers!!
On Thu, Sep 4, 2014 at 8:27 PM, GENIUS wrote:
> very easy just create ALL BORDER in the quick access toolbar and choose
> the key assigned by excel to that toolbar
>
> On Wednesday, 12 October 2011 12:19:29 UTC+5, ankit wrote:
>>
>> Dear All,
>>
>> I n
very easy just create ALL BORDER in the quick access toolbar and choose the
key assigned by excel to that toolbar
On Wednesday, 12 October 2011 12:19:29 UTC+5, ankit wrote:
>
> Dear All,
>
> I need shortcut key for all border.plz help me.
>
> Regards,
> Ankit
>
--
Are you =EXP(E:RT) or =NOT(EXP
So, your macro opens all of the (5) workbooks in the folder.
You can still use the loop I've described and use if/elseif/endif like:
Sub ListOpenWorkbooks()
Dim wb As Workbook
Dim file1, file2, file3, file4, file5
For Each wb In Workbooks
If (Left(wb.Name, Len("ForecastLastU
Hi Paul,
Thanks for your response. When the macro executes, it opens a folder and have 5
excel files in it. I am not sure which workbook will be assigned when I type
WorkBooks(1).activate or WorkBook(2).activate and so on.
I want to assign a variable to specific workbook. Workbook names are not s
Yes, Vaibhav Bhai is rock in VBA, his coding explanation is very sample for
understanding.
*Thanks & Regards,Sunil Kumar Yadav*
On Thu, Sep 4, 2014 at 5:23 PM, Ashish Kumar
wrote:
> Vaibhav Bhai,
>
> Superb solutions according to the requirement.
>
>
> Regards
> Ashish
>
>
> On 4 September
Vaibhav Bhai,
Superb solutions according to the requirement.
Regards
Ashish
On 4 September 2014 15:57, Vaibhav Joshi wrote:
> cheers!!
>
>
> On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav
> wrote:
>
>> yeah :-), it is absolutely working as per my requirement.
>>
>> Thank you so much! :-)
I'm not sure what you're expecting with the wildcard.
perhaps you could give specific examples?
The Workbook object contains all of the open workbooks.
You can loop through the Workbook object and save the filenames in a variable
or array, like:
Option Explicit
Sub ListOpenWorkbooks()
D
cheers!!
On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav
wrote:
> yeah :-), it is absolutely working as per my requirement.
>
> Thank you so much! :-)
>
>
> *Thanks & Regards, Sunil Kumar Yadav*
>
>
> On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi wrote:
>
>> Ok, i goofed up in last stat..
>>
yeah :-), it is absolutely working as per my requirement.
Thank you so much! :-)
*Thanks & Regards,Sunil Kumar Yadav*
On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi wrote:
> Ok, i goofed up in last stat..
>
> Check this now..
>
>
> On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav
> wrote:
>
Ok, i goofed up in last stat..
Check this now..
On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav
wrote:
> yes but first filter 5 against filter GPRS by "contains"(all type GPRS),
> if GPRS not found then sub procedure close or find it then fill Correct.
>
> but my create procedure when GPRS n
yes but first filter 5 against filter GPRS by "contains"(all type GPRS), if
GPRS not found then sub procedure close or find it then fill Correct.
but my create procedure when GPRS not found then fill correct against all
number like 6,7,8,9,12 etc. that is wrong.
*Thanks & Regards,Sunil Kumar Yad
It means if you find GPRS & 5 then only you want to paste "Correct" am i
right?
On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav
wrote:
> Sorry sir, but i think u r not understand what i want, may be in this my
> mistake...i tell you again!
>
>
> please find the enclosed file...1)correct
Dear Mahesh Sir,
Thanks for providing support.
Code is provided by you is not meet my requirement. Your code is copy
Highlighted Rows from Sheet 1 and delete whole data in sheet 2 then
after pasted the data. But my requirement is different. Code is
provided by Ashish Sir is working perfect.
Than
Hi,
Anybody revert on this please!!!
*Thanks & Regards,Sunil Kumar Yadav*
On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav
wrote:
> Sorry sir, but i think u r not understand what i want, may be in this my
> mistake...i tell you again!
>
>
> please find the enclosed file...1)correct
Dear Ashish Sir,
Sheet is provided by you is working perfect. Accurate Solution. Thanks
a lot Sir.
Regards
Ashu
--
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
Hey Ashu,
Please Find Attached file.
I hope it is what you expecting.
Regards,
Mahesh
On Wed, Sep 3, 2014 at 9:11 PM, Ashu k wrote:
> Dear Sir,
>
> I have Data Table in Sheet 1, I want that, when i highlight rows in
> sheet 1, these highlighted rows will copy and paste in Sheet 2.
>
> Data wil
31 matches
Mail list logo
