Hi All,
I am using a VBA macro to access or update a external internet page using
internet explorer. The internet explorer is opened in the background and
then the site is opened.
However, in recent Internet explorer versions, if I access a new page, the
internet explorer goes offline and request
Hi All,
I have a excel file containing various macros that provide access to the
file after everyone enters their login credentials. These login credentials
are included in the hidden worksheets.
This file would be used by my colleagues across the world. Now my
colleagues in Germany would be usin
Hi Bill,
For your question about Enable Reference.
In VBA window, where your VBA code is, under Tools menu you will find this
option.
Basole,
I am still struggling to make this code work (without using Outlook). I
still get the error "transport failed to connect to the server".
Regards,
Aa
There are tools available to pick-up/trace points on a picture of a plot.
One such tool is Enguage Digitizer (http://digitizer.sourceforge.net/). It
is free and quite useful.
Many engineers use it to convert a old research chart into numbers so that
they can compare latest results with the old one
ou really want to prevent your code then go for COM
> addin Using VSTO.
>
>
> On Wednesday, 31 July 2013 23:58:25 UTC+5:30, Aashish Watve wrote:
>>
>> Dear All,
>>
>> I have a very particular question. Is there a way to prevent opening a
>> macro enabled excel
Dear All,
I have a very particular question. Is there a way to prevent opening a
macro enabled excel spreadsheet being opened in OpenOffice products?
One method suggested on some other forum was to check if the file is opened
by excel application or other. If it is not excel then close it.
1) Ho
nme.Visible = False
Next nme
End Sub
Regards,
Aashish
On Sun, Jul 7, 2013 at 7:29 PM, Sam Mathai Chacko wrote:
> Aashish,
>
> Even if you hide the name manager button, one could still envoke it using
> CTRL + F3.
>
> Regards,
> Sam
>
>
> On Sun, Jul 7, 2013 at
Hi,
I am working on a excel dashboard, where I have hidden many worksheets.
However, the name manager shows the formulas I have used referring to the
hidden worksheets.
I am however not able to find a way to hide the formula's, cell references,
lists I have used in various formulas. They appear i
Hi All,
I am seeing many examples of SUMPRODUCT formula on this forum and very
interested in using this in my assignment. I see that this formula is very
short and fast.
I am presently using SUMIFS for most of my calculations, where I am
creating the SUMIF formula in a cell by concatenating entri
