browsing

Hi, I created a macro today to rename two tabs. Since then, when I tried to launch excel, it doesn't bring a blank worksheet but it asks me if I want to open a new sheet or one of my most recent files. Is there anything under options>Advanced that i need to tick? to bring me to a sheet 1...

Hello! I have data in three columns: A,B,C and each columns has several rows with numbers. I want to return all the A numbers that match: B= 4 or 3 AND C = 5 Any idea? I have been browsing through several websites but most at horrible in explaining bit by bit the formulas. Thanks!

Hi , currently using this code to browse a folder :- objWindowsFolder = objShell.BrowseForFolder(0, "Select a Windows folder:", 0, "") I want to change it , so that it selects the current workbook folder automatically instead of browsing and selecting the folder. Please help.

hi All, I am looking for a VBA code that allow me to click a tab (provided as image) on a web page. The web page is not showing any id specific to the tab. Here is the source code. td height="36" valign="bottom"> a href="javascript:submitTab('pair_search')" tabindex="6" img...

I been reading up codes available on the net from various sources and have debug with self-taught programming to make it work but I'm having difficulty proceeding on. As you can see, it comes from a source. Browsing a folder & reading the files works fine with the code, I need to copy values...

Hello, Short and simple question. I have a macro that opens a url with the Shell command. At the end of the macro I want a msgbox to prompt and bring me back in Excel even if I am browsing on Chrome. It doesn't necessarily need to be a msgbox by the way but a code line that makes my Excel be...