Forum Discussion

ayed8748's avatar
ayed8748
Copper Contributor
Sep 26, 2020

need your help

Hello Everybody

 

My name is Ayed,

I have some problems and i need your help to fix them

1- I want to change the defult net browser from the excel

because when i want to import data from the internet it refuse my broswer and says you have to update the broswer while it is updated with all broswers.

2- I want to know how to copy automaticlly data from the 1st sheet to all sheets(in the first sheet i programm it to referesh the data automaticlly when i open it ).

 

 

Thank you and i will be waiting your help

excel

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Sep 27, 2020

    ayed8748 

     

    1. Change your default browser

    https://support.microsoft.com/en-gb/help/4028606/windows-10-change-your-default-browser

     

    • Select the Start button, and then type Default apps.
    • In the search results, select Default apps.

    • Under Web browser, select the browser currently listed, and then select Microsoft Edge or another browser.

    Is it possible to use Edge or Chrome from Excel when importing data from a website (Data > New Query > From Other sources > From Web)

    https://social.technet.microsoft.com/Forums/office/en-US/6b2d846f-300f-4593-8197-0e77ccbff496/excel-default-browser?forum=excel

     

    2. There are several ways to do this, one of which is VBA.

     

    Sub Copy_data()
Dim Quelltab As Worksheet
Dim Zieltab As Worksheet
Dim Zelle As Range
Dim Zaehler As Long
Zaehler = 1
Bereich = "A1:A10"
Set Quelltab = ActiveWorkbook.Worksheets("Sheet1")
Set Zieltab = ActiveWorkbook.Worksheets("Sheet2")
For Each Zelle In Quelltab.Range("A1:A10")
 Zieltab.Cells(Zaehler, 1) = Zelle
 Zaehler = Zaehler + 1
Next Zelle
End Sub
'as posible, from German in English translate.

     

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

     

    • ayed8748's avatar
      ayed8748
      Copper Contributor
      Oct 02, 2020

      Hello Boss NikolinoDE 

       

      I tried to do the same what did you explain but id doesn't come

       

      i update the offce but still the same

      may be i need to explain more for you to help me

       

      if you don't mind send to me privately how can i contact you and do all by sharring the screen or anyway

       

       

      thank you for your help

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Oct 02, 2020

        ayed8748 

         

        !.

        If you want to set your Own Browser as a default web browser.

        On your computer >> Click Start menu >> Click Settings .

        Open your default apps >> Original version >> Click System Default apps.

        At the bottom, under "Web browser," click your current browser >> "Choose an app" window >> Click or select your own browser.

         

         

        2.

        Open the VBA editor in Excel

        It is very easy to open the VBA editor in Excel and then use it to create some macros. Simply press the key combination [Alt] + [F11].
        You can watch youtube videos on how to do this, you will find a lot about "first steps in VBA".
        Don't forget to save the file as an .xlsm file at the end of the VBA code.


        Attached is a workbook where the code is already inserted.
        If you get stuck, you have the option to click on my profile and send me a private message.

         

        I would be happy to know if I could help.

         

        Nikolino

        I know I don't know anything (Socrates)

         

        * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Resources