Sep 26 2020 02:47 PM
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
Sep 27 2020 12:40 PM
1. Change your default browser
https://support.microsoft.com/en-gb/help/4028606/windows-10-change-your-default-browser
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)
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.
Oct 02 2020 05:01 AM
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
Oct 02 2020 06:21 AM
!.
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.