$$Excel-Macros$$ Need macro to copy data from excel file to another excel file

2014-11-15 Thread Ujjwal Desai
Hello, Awaiting for your reply. ...yudy -- 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

Re: $$Excel-Macros$$ Pasting Data from Different Files in One Worksheet

2014-10-31 Thread Ujjwal Desai
Hello , Can we get the combined output in a new worksheet with the help of this macro. Thanks, Ujjwal On Saturday, October 18, 2014 7:42:09 PM UTC+5:30, Ashish Kumar wrote: HI, PFA.!! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Re: Need Help with the macro file

2014-10-23 Thread Ujjwal Desai
Hello , Awaiting for your help !. Thanks, Ujjwal On Sunday, October 19, 2014 6:48:36 PM UTC+5:30, Ujjwal Desai wrote: Hello , I need your help with regards to the attached macro file. I am trying to convert the pdf file to excel format but the conversion is not as expected. *Issue

Re: $$Excel-Macros$$ Need a macro to get consolidated report

2014-10-16 Thread Ujjwal Desai
Thanks Vaibhav !!! Your file is working perfectly matching with my requirement. -- 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,

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-14 Thread Ujjwal Desai
Hi Pramod, Can you please advise ??. Thanks, Ujjwal -- 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$$ Need help with time sheet

2014-09-14 Thread Ujjwal Desai
Yes absolutely right. In order to track time for each document # separately. -- 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,

$$Excel-Macros$$ Need help with time sheet

2014-09-08 Thread Ujjwal Desai
Hello , I need your help in regards with the attached timesheet. 1.The Time should be captured for each row separately. 2.Reset tab vba code is not working properly. Please provide your inputs. Thanks, Ujjwal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Need help with time sheet

2014-09-08 Thread Ujjwal Desai
AM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hello , I need your help in regards with the attached timesheet. 1.The Time should be captured for each row separately. 2.Reset tab vba code is not working properly. Please provide your inputs. Thanks, Ujjwal -- Are you =EXP(E:RT

$$Excel-Macros$$ Need macro to covert pdf to excel

2014-09-02 Thread Ujjwal Desai
Hello guys, Still awaiting for your response. Ujjwal -- 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.

$$Excel-Macros$$ Need macro to covert pdf to excel

2014-08-30 Thread Ujjwal Desai
Hello, Need your help to convert pdf file to excel without changing the format of pdf. Also the pdf file converted to excel result should be into different sheets(As per attached invoice forming one workbook). i have attached two sample files. Awaiting for your positive solution. Thanks,

$$Excel-Macros$$ Re: Need VBA code to convert multi-pages PDF file into multiple sheets Excel Spreadsheet

2014-08-24 Thread Ujjwal Desai
Hi Sandeep , Did you received the solution for your query ??? If yes,then could you share me the solution for the same. Thanks, Ujjwal On Monday, August 4, 2014 9:42:45 PM UTC+5:30, Sandeep Kumar Baranwal wrote: Hi Could anyone help me with the VBA code to convert multi-pages PDF file to

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-19 Thread Ujjwal Desai
Deleted the lines. Emails are also going properly Now getting Automation Error On Aug 19, 2014 12:29 PM, Vaibhav Joshi v...@vabs.in wrote: Delete these 3 lines.. On Tue, Aug 19, 2014 at 11:25 AM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hi Vaibhav , on the below line : If Dir

$$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
Hello , I am trying to send multiple email with attachment with the help of Vba. Unfortunately I am getting an error “Automation error 440” Need your help in regards to the attached file. Awaiting for the reply ! Thanks, Ujjwal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
, Aug 18, 2014 at 4:32 PM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hello , I am trying to send multiple email with attachment with the help of Vba. Unfortunately I am getting an error “Automation error 440” Need your help in regards to the attached file. Awaiting for the reply

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
).Value .Display '.Send or .Save End With Next rngEntry Set objOutlook = Nothing Set objMail = Nothing Set rngEntry = Nothing Set rngEntries = Nothing End Sub Cheers!! On Mon, Aug 18, 2014 at 5:52 PM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

2014-08-18 Thread Ujjwal Desai
, 2014 at 12:40 AM, Ujjwal Desai ujjwal1...@gmail.com wrote: Hi Vaibhav , Finally now working ! But once the macro is executed it does generates the auto email with attachment too. But it prompts an error Type Mismatch How can we fix this problem ??? Thanks, Ujjwal On Mon, Aug

$$Excel-Macros$$ Need a quick help

2014-08-16 Thread Ujjwal Desai
Hello i have a file which contains a macro to convert excel data to .xml format. I am very new to vba but trying to find a solution. i would appreciate if anyone can help me with the below query : 1.File contains field of purchase order with 00(10 times 0) but when converted to xml