Re: $$Excel-Macros$$ Export Data on new Sheet with same Id of that column

2015-02-21 Thread Sandeep Sharma
Dear Harpreet Singh:- You should Try to Merge and Cell for this select cell A2:A10 then Click Right through mouse go to Format Cells then Alignment then tick Merge cells With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sat, Feb 21, 2015 at 1:35 PM, Harp

$$Excel-Macros$$ Export Data on new Sheet with same Id of that column

2015-02-21 Thread Harpreet Singh
First of all let me tell you all that i am totally new to Excel. I never used it before.. I am in a little trouble, so i need help of your guyz... Hope you guyz will help me. My Problem is :

Re: $$Excel-Macros$$ Export data from excel to tally.

2014-06-23 Thread xlstime
Need to install ODBC... connect excel with ODBC and use... . Enjoy Team XLS On Fri, Jun 20, 2014 at 9:46 PM, Divaker Pandey wrote: > hi experts, > > Is there any way to export data from excel to Tally 9.0 > > Divaker > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Export data from excel to tally.

2014-06-20 Thread Vaibhav Joshi
Yes Either way. You can export to and import to tally from excel. You need to Google it or take help of tally developer. Cheers On Jun 20, 2014 9:47 PM, "Divaker Pandey" wrote: > hi experts, > > Is there any way to export data from excel to Tally 9.0 > > Divaker > > -- > Are you =EXP(E:RT) or

$$Excel-Macros$$ Export data from excel to tally.

2014-06-20 Thread Divaker Pandey
hi experts, Is there any way to export data from excel to Tally 9.0 Divaker -- 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, accura

Re: $$Excel-Macros$$ Export Data

2011-09-22 Thread dguillett1
py newname = .Name & " - " & Format(Date, "mm-dd-yy") With ActiveWorkbook .SaveAs Filename:=mydesktop & newname & ".xls" .Close End With End With ChDir mypath End Sub From: Mr Excellent Sent: Thursday, September 22, 2011 12:29 AM To: excel-macros@

Re: $$Excel-Macros$$ Export Data

2011-09-22 Thread NOORAIN ANSARI
Dear Surya, Please try below code and See attached sheet.. Sub export_report() Sheet3.UsedRange.Copy Workbooks.Add Set wkb = ActiveWorkbook wkb.Sheets(1).Select ActiveSheet.Paste wkb.SaveAs "C:\Documents and Settings\Administrator\Desktop\" & "Details-" & VBA.Format(Now(), "dd-mm-") & ".xls"

$$Excel-Macros$$ Export Data

2011-09-21 Thread Mr Excellent
Hi Group I have a spread sheet which has 3 TABS and the last tab is saved with the required information and i need a VBA code for exporting only the TAB named as "Details" to be exported on my desktop with xls format and file which has to be saved should be named as "Details - Present Date( DD-MM-

$$Excel-Macros$$ Export Data

2011-02-28 Thread Vikas Chouhan
HI Expats, Greeting for New Day !!! I want to export data from mysql to .csv format. just want to click in command button and data save to define location.. it's very urgent so pls help me ! -- One Team One Dream One Goal Warm Regards, *Vikas Chauhan*

$$Excel-Macros$$ Export data to Outlook Express

2010-04-21 Thread Mayank
Hi, can some one help me, I need a macro which will send selected data from MS-Excel to Outlook. When macro is run pre decided cells should export to outlook. please help. Thank You Mayank -- -- Some important lin