User Profile

Collapse

Profile Sidebar

Collapse
teja1234
teja1234
Last Activity: Jun 25 '10, 05:52 AM
Joined: Jun 5 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • teja1234
    started a topic Regarding Excel file Location
    in Java

    Regarding Excel file Location

    Hi All,

    I have macro code which will pull excel file from a relative path specified in code shown below
    Set Wkb2 = Workbooks.Open( Filename:=ThisW orkbook.Path & "\Input\Manpowe r_Master_Foreca st_10_BNPPISPL. xls")
    Wkb2.Activate.

    But i got requirment like when macro runs it has to ask input filename to be enter by user based on which it has to pull data from that file.

    Please if...
    See more | Go to post
    • teja1234
      replied to {Excel} Regarding Relative Path in Macros
      in Access
      Thanks NeoPa,
      I got how to use relative path in macro, thanks for explaining me about it. Its working now for me.

      Thanks once again

      Teja...
      See more | Go to post

        Leave a comment:

      • teja1234
        replied to {Excel} Regarding Relative Path in Macros
        in Access
        Thanks for quick reply,

        I have some input excel files in one folder, i am writting macro code in different excel workbook. I have to specify the location on input file as mention above in my 1st post. In that i am using absolute path that i want to make relative. Can you tell me what i need to do.

        Reagards
        Teja...
        See more | Go to post

          Leave a comment:

        • teja1234
          started a topic Regarding Relative path in Macros
          in Access

          Regarding Relative path in Macros

          Hi All,

          I am using absolute path in my macro code, but i want to change it to relative path. I am not sure what exactly relative path will do how to use relative path in macro. Please can any one give me any idea on this.

          Here is my path in code

          Set Wkb2 = Workbooks.Open( Filename:="C:\D ocuments and Settings\admin\ Desktop\Folder\ Input\Manpower_ 10.xls")
          Wkb2.Activate

          ...
          See more | Go to post
          • teja1234
            started a topic {Excel} Regarding Relative Path in Macros
            in Access

            {Excel} Regarding Relative Path in Macros

            Hi All,

            I am using absolute path in my macro code, but i want to change it to relative path. I am not sure what exactly relative path will do how to use relative path in macro. Please can any one give me any idea on this.

            Here is my path in code
            Code:
            Set Wkb2 = Workbooks.Open(Filename:="C:\Documents and Settings\admin\Desktop\Aezaz\BNP_Folder\Input\Manpower_Master_Forecast_10_BNPPISPL.xls")
            ...
            See more | Go to post
            Last edited by NeoPa; Jun 18 '10, 12:02 PM. Reason: Please use the [CODE] tags provided.
            • teja1234
              replied to VBA Macros issue
              in Visual Basic
              Hi Veena,

              Kindly if you have any sample code to clear cell 20 whenever the row updated or changed. Please share with me.

              Thanks in Advance
              Teja
              edit reply report...
              See more | Go to post

                Leave a comment:

              • teja1234
                replied to VBA Macros issue
                in Visual Basic
                Hi Veena,

                Kindly if you have any sample code to clear cell 20 whenever the row updated or changed. Please share with me.

                Thanks in Advance
                Teja
                See more | Go to post

                  Leave a comment:

                • teja1234
                  replied to VBA Macros issue
                  in Visual Basic
                  Thanks for quick reply,

                  If you can give me any idea or help me to get code for clearing cell when row 1 to 19 updated, it will be great help.

                  Thanks
                  Teja...
                  See more | Go to post

                    Leave a comment:

                  • teja1234
                    replied to VBA Macros issue
                    in Visual Basic
                    Hi Veena,

                    I am not sure what u r asking, i am using following code.

                    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 Emp_id As String
Dim Emp_Name As String
Dim Salary As String
Dim Dept
                    ...
                    See more | Go to post

                      Leave a comment:

                    • teja1234
                      replied to VBA Macros issue
                      in Visual Basic
                      No Veena, i don't have any blank cell in my excel sheet.

                      Any idea why it is not updating

                      Regards
                      Teja...
                      See more | Go to post

                        Leave a comment:

                      • teja1234
                        replied to VBA Macros issue
                        in Visual Basic
                        Hi Veena, I have one more issue. I tried your tips and i was working fine for less the 10 rows but when i enter more the 10 row in excel sheet this macro is not updating excel data into orcale database can you please tell why it is not updating....
                        See more | Go to post

                          Leave a comment:

                        • teja1234
                          replied to VBA Macros issue
                          in Visual Basic
                          Thanks Veena, its working fine as u said

                          Thanks once again

                          Best Regards
                          Teja...
                          See more | Go to post

                            Leave a comment:

                          • teja1234
                            replied to VBA Macros issue
                            in Visual Basic
                            Veena,
                            I have a problem with updating the data from excel into oracle database, whenever i am running a macro each time it is updating whole sheet data, but i want to updated only the rows which ever added newly with respect to previous macro run.

                            I don't have ploblem with column updation.

                            So please give any idea this

                            Thanks
                            Teja
                            See more | Go to post

                              Leave a comment:

                            • teja1234
                              replied to VBA Macros issue
                              in Visual Basic
                              Hi Veena, Thanks for your reply
                              I tried your tips but its not working for me, When my excel sheet updated say with 2 rows when i run macro it has to updated only that two rows into database but its not updating. If i use my code it is updated whole data from excel sheet again.

                              Please any other Tips please share

                              Thanks
                              Teja...
                              See more | Go to post

                                Leave a comment:

                              • teja1234
                                started a topic VBA Macros issue
                                in Visual Basic

                                VBA Macros issue

                                I wrote a macro script which will upload excel data into orcale database also it generate excel sheet in othet location and its working fine, but whenever i run the macro it will take all rows from excel sheet and updated database so i am getting same data again and again.
                                Please can any one help me how to update only changed rows from excel to database.

                                Below is my code:

                                Code:
                                Sub AppendOracleTable()

'Create
                                ...
                                See more | Go to post
                                Last edited by Dormilich; Jun 5 '10, 09:52 AM. Reason: Please use [code] tags when posting code
                                No activity results to display
                                Show More
                                Working...