Hi,
Please let me know whether app is running VB or VBA.
Regards
musai.
prakashsakthivel
Last Activity: Jul 20 '08, 10:37 AM
Joined: Oct 19 '07
Location:
-
Is it possible to insert records through view....
Hi Members,
Is it possible to insert records through view in the sql server..
Could you please any of members clarify this.
Regards
musai -
Hi,
We have to use API function when we handle multiple instance of excel application. If you don't have any idea about this I will post code.
musai....Leave a comment:
-
Hi Friend.
Please make sure that whether You have selected latest library or not regarding (DAO or ADO) so that library should support this function.
Please make sure that which version you are using.
Regards
Musai....Leave a comment:
-
Hi,
Please put "Doevents" before the line and then try whether it is working or not.
Musai....Leave a comment:
-
prakashsakthivel replied to If a workbook is closed directly from excel vba and then opened from code within VBA.in Visual BasicThanks for updates.
In .bas Module, I have written the application after executing some task.
Public sub close_file
ThisWorkbook.Cl ose savechanges:=Fa lse
End sub
Ex:
Private Sub Workbook_Before Close(Cancel As Boolean)
Dim strfile as Strfile
Strfile=”c:\Tes t.xls”
Workbooks.Open strfile
End Sub
While try to close the application...Leave a comment:
-
prakashsakthivel started a topic If a workbook is closed directly from excel vba and then opened from code within VBA.in Visual BasicIf a workbook is closed directly from excel vba and then opened from code within VBA.
What I want to know is that while one excel application is closed by VBA code from module, another excel application has to be opened.
That means, I have written code to open new excel sheet in the Workbook_Before Close.
I have written a code like workbooks.open (Path\filename)
If a workbook is closed directly from excel vba and then opened from code within VBA. It is not working.
It is working fine... -
Is it possible to use Outlook 2003 from Excel 2000 through VBA
Hi Members,
Is it possible to use Outlook 2003 from excel 2000.
I am using Outlook 2003 and Excel 2000.
While try to send mail automatically from excel 2000 (VBA), Application is giving error msg like It can not be created.
What I have to do?
Could anybody please tell me to handle this issue. -
prakashsakthivel started a topic In Excel 2000, How to remove exteranl reference from link dialogbox...Urgent.in Visual BasicIn Excel 2000, How to remove exteranl reference from link dialogbox...Urgent.
Hi Members,
I am not able to find link which cells have link with other workbook.
Even I tried through Find, link dialog box.
Now What I want is that I want to romove that reference from link box.
because whenever opening applications, it is asking like update or not.
Musai. -
prakashsakthivel started a topic How to know excel application has reference link...in Visual BasicHow to know excel application has reference link...
Hi Member,
Please tell How to know one excel applicatiion has remote reference that means
one excel application has link with other application.
Manually I tried to find via Edit/link it gives file and location.
But I am not able to find in the cell.
musai -
Thanks for givning information...Leave a comment:
-
In excel how to use Timer....
Hi Members,
I think that there is no timer control in excel vba editor.
It can be used in VB.
I want to know that how to acheive in excel as we do in vb
Is any API function to achieve these.
prakash. -
Thanks for reply,
It is working nice.
Actually I want to know is that I have to transfer all cells (formula) to other workbook, but this workbook contains formula, constants ,,, then whenever required, those formula are transferred to old workbook.
What I have done that when transfering data to other workbook I created comments to each cell for avoidig path of old file that means formula to text.
...Leave a comment:
-
How to delete all formula in the excel 2000....
Hi Members,
What I want to know is, I want to detect formula which cells has formula and converted as text.
let us example,
One excel workbook have 4 sheet. all cells of each sheet contains formula
like internal link with other worksheet and other workbook.
I have used "specialcel ls" to find formula.
I need that is any way to detect all formula at one time.
... -
prakashsakthivel started a topic How to use OLE in excel 2000 for getting or sending to other applications.........in Visual BasicHow to use OLE in excel 2000 for getting or sending to other applications.........
Hi Members,
Could anybody please tell that
How to use OLE in Excel 2000 for sending or getting data from other applications
like .exe, or .xls
Thanks
musai. -
How to send and get more parameter through DDE link........
Hi Members
How to pass more than one parameters via DDE link. to excel from any .exe
or from excel to .exe.
I have done for one parameter through text box from vb.exe.
How I can sent more parameters via DDE link to excel
Could you please guide me
musai. -
I want to change DDE link into OLE link in excel.........Urgent
Hi Members,
"=win|L!'FR0010 415,[CLOSE_D]'"
Syntex: "=Applicationna me|Topic!item"
Now I want to change DDE Link to OLE Link
What are syntax available..
could you please anybody tell diff between DDE and OLE.
musai. -
Hi
Just call this line in this function "display_custom er02_account02_ transaction02() " instead of Form load event.
Set rs1 = db1.OpenRecords et(x$, dbOpenSnapshot)
It will work.
musai.Leave a comment:
-
One excel application (Excel 2003)...
Hi Members,
One excel application (Excel 2003), I set range, formating it is working fine through macro..
After that as per client requirements, I changed Excel 2000 instead of Excel 2003. After changing reference, range, formating has been changed.
It is not working.
Everthing will be impact if we change 2003 to 2000.
Why, What I have to do?
musai... -
I renamed excel add in, it is not working....Urgent..Urgent.......
Hi Members
Old excel add in was working fine.
I wanted to rename that add in
I just renamed that addin.
Now it is not working
I am unable to do refer in all excel vba editor.
what I have to do?
Please help.
musai.
No activity results to display
Leave a comment: