Recent content by nateshk

hi SBendBuckeye , it worked smoothly. thanx a ton. but i have one more concern. when i use savecopyas syntax, it copies the macro code also which i donot want to happen. can u solve this one also. thanx again natesh

Hi All, I need to create a new excel workbook from an existing workbook keeping the column structure intact as the existing one using a macro. i open the existing worksheet using Workbook.open command, then i save it using a different name using command workbook.saveas. but in this case the...

Hi Rob, Yes i have got Outlook as my mailing sw, can u tell me how to move ahead. Thanx Natesh

Hi All, I need to send a mail from Word document using a macro. The mail will contain some message and additional the document itself will have to be sent as attachment. I need to send mail to different persons seperately. Say Email1 to person A, Email2 to person2 etc.. The content of the...

Hi All, I need to send a mail from Word document using a macro. The mail will contain some message and additional the document itself will have to be sent as attachment. I need to send mail to different persons seperately. Say Email1 to person A, Email2 to person2 etc.. The content of the...

Hi dgillz , is the memo datatype available in report ver 9.0 ? i tried creating a parameter field and memo datatype is not available in the drop down for datatype. can u further elaborate, how do i do it ? Regards Natesh

Hi All, I am using parameter field in my Report which is defined to be of String datatype.The report is created in ver 9.0 from my VB code iam pasing value which can be 4000 charc long. But the progran crashes. is there any way i can overcome this limitation. is this limitation of string...

Hi Ido, Iam working with Crystal Report Control ( Crystal32.ocx) in ver 8. is this control still available in ver 9 Thanx Natesh

Reebo, Unfortunately no.... Natesh

Hi All, Iam using Crystal Reports ver 8.0, for reporting purposes. I had been using Crystal Reports Active X control in my VB form for displaying the report. But recently i have upgraded to ver 9.0. Problem is Active X control is no longer there. Has it been removed in ver 9.0. I needed...

Hi Reebo, How do i do it ? Natesh

Hi, Iam using Crystal Report Active X Control for displaying my report. Within VB iam trying to connect to a new database. But it is unable to do so giving error "Cannot Open SQL Server Error No :20599" Hope somebody can help me. Thanx Natesh Code : With crxReport...

Hi All, Iam using CrystalReportViewer to display my report. The ReportSource value is assigned during click of a button. Also iam changing the database at runtime. for the first click of the button it works properly. but for the second click it gives "Out of Memory". Its logging...

hi RobBroekhuis , Thanx Rob, but i found out the problem. The menu was custome generated thru code. Thanx for the help. Regards. Natesh

Hi, I have created a custom menu and menu item with in it to call a macro. The Custom menu appears on the top of the sheet along with File,Edit... menu options. But after i close the sheet and later open it , the custome menu is no longer there. Can anyone help me on it ? Thanx a ton Natesh