Hi, I have this simple Excel add-in project based on the standard VS template, however, I cannot call the below test() function from Excel VBA.

\[Guid("9E88FA9A-4E7D-4bba-8D94-439BFA2B0AEC")\]

\[ClassInterface(ClassInterfaceType.AutoDual)\]
\[ComVisible(true)\]
public class MyFunctions
{
    public void test()
    {
        Microsoft.Office.Interop.Excel.Application xlsApp = new ApplicationClass();
        Worksheet ws = (Worksheet)xlsApp.ActiveSheet;
        ws.Cells\[1, 1\] = "Edited by C#";
    }

Please help, Thanks.

Works like a charm :) Thank you!

Hi, Ever tried to copy into/replace a file inside System32?? I keep getting invalid path error message when it works just fine elsewhere. Please advise.

Hi, Can you kindly shed some light on what's wrong with the below code? Many thanks,

    private Image DownloadImage(string \_URL)
    {            
        try 
        {
            WebClient client = new WebClient();
            Stream stream = client.OpenRead(\_URL); //The problem seems to be here
            Image img = Image.FromStream(stream);
            stream.Flush();
            stream.Close();
            return img;
        }
        catch (Exception e) 
        {
            MessageBox.Show(e.Message);
            return null;
        }
        
    }

Hi, I'm trying to block some websites using the hosts file located on C:\Windows\System32\drivers\etc\ contents are: 127.0.0.1 www.facebook.com Any idea why Windows7 ignores it?? Many thanks

Thank you Alan! That was very helpful.

Thank you mate, you've helped a lot and you sound like an expert in DOS so I thought maybe you can assist with this.. The file to be copies has a name format of "PO 123.2011.txt" Now it is copied, is it possible to generate the next name (i.e. "PO 124.2011") probably using an expression for the math, concatenation and storing it into a temporary variable?? I'm using this for now..

FOR /F "delims=" %%I IN ('DIR . /B /O:-D /T:C') DO COPY "%%I" .\new.txt & GOTO :END
:END
START /MAX new.txt

Many thanks mate!

Thanks mate!

This works:

FOR /F "delims=" %%I IN ('DIR . /B /O:-D') DO COPY "%%I" .\t.xls & GOTO :END
:END

however, it takes the date of modification instead of creation, hence, if an old file in that folder got edited, it takes it! Any ideas?? Thanks.

Thanks mate, I've already got over it, i just needed to reinstall it!

It was the hard drive boot sequence. BTW: Do you have any idea how to access a flash drive from within the mac os?? Thanks

Hi, If you are using mac snow leopard loaded on vmware, how would you access a flash disk drive?? Thanks

Thanks Rain, I actually did and it worked, but suddenly, now i keep getting the kernel panic message when booting, any idea?? Many thanks mate!

Thanks.

Hi, I'm running windows7 and VMWare workstation v.7.. When trying to load an image of Mac Snow leopard I get a strange message saying: Mac OS X is not supported with software virtualization. To run Mac OS X you need a host on which VMware Workstation supports hardware virtualization. Ignoring this problem, how would you install Snow Leopard on VMWare?? Apart from buying Mac laptop, any suggestion?? Many thanks,

Ed: moved on Saturday, July 2, 2011 9:34 PM

Thanks Holmes, you're absolutely right, actually, I never used the designer when it comes to database programming and this's exactly why I'm asking now.. Guess I'll just have to forget about the designer.. I thought if it will make my life easier, why not to go for it.

Thanks Luc, Of course I'm not editing the totals and they're set to read only, I just need the user to see it as the values are entered.. The funny thing is that, I've done it before and I just don't seem to remember how.. Thanks mate!

SELECT ID, PRODUCT, PRICE, QTY, PRICE*QTY AS TOTAL FROM PRODUCTS I added the expression PRICE*QTY in the adapter select statement in the design time, now the values can't be updated when running the bound datagridview ie. loads but doesn't save changes. Please help.

Hi, Suppose I have this customer orders table in which we have to specify a customer for the new order, however, customers are most of the time the same so we just need to make it easier when creating the new order and list the customer name from the box. I tried changing the datasource, value member and display member but it doesn't work. Please help.

Thanks, it works fine now.. I just had to reinstall VS!!