Search results for query: *

Thanks Randy, Surly will do it. Regards Teja

Thanks for quick reply, Here is a code Sub AppendOracleTable() 'Create and set login information variables Dim logon As String Let logon = "scott" Dim password As String Let password = "tiger" 'Set Variables for Upload Dim Cust_id As String Dim Cust_Name As String Dim Product As String...

Hi All, I am new to macro also to this forum, previously i asked two questions but i didn't got proper reply from any one. i am hopeing this time u guys can help me. I wrote a macro which will load excel sheet data into oracle database every thing is fine but when i run macro each time data...

Hi PHV, Thanks for your reply. Below is the code i tried Sub CopyDataOfWorkbooks() Dim objWorkbook As Workbook, objMainWorkbook As Workbook Dim ArrayWorkbooks() As String Dim i As Byte ' Setings '!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ReDim ArrayWorkbooks(1 To 2)...

Hi All, Can any please tell me how to copy data from One Excel file to another excel file. I tried some code but i am not able to do that. If any one share the working code for same it will be great help. Thanks in Advance Teja

Thanks kjv1611/jsteph for your reply, jsteph as you explain me about how my issue can be solve, i am very new to macro so if you can pass macro code for this it will be very helpful. Thanks once again Teja

Thanks for you reply, But i don't want to export from Access to Excel. It is already ther in excel sheets just want to export to Oracle using macros. Regards Teja

Hi All, I am very new to VBA excel Macros, i have a requerment like in need to write a macro script which exports excel sheets fron local file to oracle database. Please can any one help me by give idea how to achive this, if any one share code for this is very helpful. It is very urgent please...