$$Excel-Macros$$ New Web Query get data from existing open IE Browser instead of opening new browser window

With Microsoft Excel 2003, using the "Web Query" feature, I record a macro, put the URL of the website into the New Web Query and that opens a new instance of Internet Explorer. Using the Web Query, I go to a specific table within the tables on the web page and select the table that I want to get

$$Excel-Macros$$ Re: getting the value from a cell that has a forumla in it

Thank You to all of you. I knew this was something simple but I just couldn't get it to work. On Jun 16, 2:21 am, Dilip Pandey wrote: > Hi RCGUA, > > 'Assuming you have the formula in cell A1, use the following code. > Sub test() > Dim i As String > i = Range(&quo

$$Excel-Macros$$ How can I open that workbook to a specific workSheet from a shortcut or batch file outside of Excel?

I have a shortcut on my desktop that will open a specific workBook in Microsoft Excel 2003. How can I open that workbook to a specific workSheet? For example, "sheet3"I need to use a shortcut or some sort of batch file because I am running it from a fingerprint reader. The fingerprint read

$$Excel-Macros$$ getting the value from a cell that has a forumla in it

I'm sorry if this is a really simple question or if the answer could be found in the archives, I could not find it. I have a workseet with a simple that has a simple forumula =D21*D20 in VBA, I need to get the value of that cell. Thanks for your help, I hope it is something very simple, sorry ag