$$Excel-Macros$$ Problem in file..?

2013-05-22 Thread Prabhu Pinky
Hi experts, I have one excel file. Size is below 1mb. Even though it is very slow working in that file. If I do copy paste any single cell, it takes too much time. What could be the reasons...? Prabhu R -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

$$Excel-Macros$$ Import Data From large size text file to Excel using VBA

2013-05-22 Thread vincentmca
Hi, i need to import data from text file to excel. Please help to use macro. Find below my data example. Name*:*Anbu Age*:*20 Se

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
Thanks Abhishek sir. but it will be a long process. i have many more files to insert as hyperlink. Can it be automated like -whatever the file contain in the folder, it wil insert as object and will create hyperlink to the corresponding object file. say Excel file A if A insert as object then for t

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Abhishek Jain
Yes Chaya, it can be done. But if that is your only issue, I'll suggest a simpler alternate option. Save all your files in a folder, store that folder on root of any drive, rearrange the hyperlinks, zip the folder and send. You can tell the receiver on which drive letter the folder is to be extract

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
Yes Abhishek sir. Can it be done by macros. i mean by first inserting all the files as object in the master file and creating hyperlink to the object. can be done like sir ? :-) chaya On 5/22/13, Chaya wrote: > Thanks David sir and Paul sir for your quick reply. and thanks to all. > > No si

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
Thanks David sir and Paul sir for your quick reply. and thanks to all. No sir the file is to be sent by mails and no network share folder will contain. Can it be done by macros. _ Chaya On 5/22/13, David Grugeon wrote: > Can they open the files through the network manually while the files are

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Abhishek Jain
If by* "**i don't have to send all the file across to some one except Master file"* you mean you don't want to attach all the files one by one, you can embed them all in your master file. See - *Insert>Object>Create from file* On Wed, May 22, 2013 at 6:47 PM, David Grugeon wrote: > Can they op

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread David Grugeon
Can they open the files through the network manually while the files are on you computer On Wednesday, 22 May 2013, Chaya wrote: > Dear experts, > > > I have more then three excel (Say A, B, C) file in under folder > (D:\Master File). Now I have a single workbook know as “Master file”. In > t

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Paul Schreiner
You basically have two choices. You either have to put the files in a shared folder (that others would also have access to) or you have to include the files in the "Master file". You said that you don't want to send the files, so that leaves you with storing them in a shared folder.   Paul -

Re: $$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread David Grugeon
Can they open the files through the network manually while the files are on you computer and they are on their computers. If so they will use a network path to do so. You will need to use this network path in the hyperlink. On Wednesday, 22 May 2013, Chaya wrote: > Dear experts, > > > I ha

$$Excel-Macros$$ External excel file insert to single excel file

2013-05-22 Thread Chaya
Dear experts, I have more then three excel (Say A, B, C) file in under folder (D:\Master File). Now I have a single workbook know as “Master file”. In the Master file i have created hyperlink to all for the workbook (A, B, C) in the cell A1 = A excel hyperlink, A2= B excel hyperlink, A3 = C e