Search results for query: *

I have problem passing the array into a procedure, is my syntax correct? I am not very familiar with VBA. Function func1(ParamArray array1()) . . . func2(array1()) ' It is a string array. . end Function sub func2(paramArray array2()) . . end sub

Thanks a lot for the codes, vbMax. So, anyone knows how to write script( say ASP) to run a macro in an excel?

Hi, I need to create a web page which will show some updated excel charts. The excel files are assumed to be stored at the web server. What should I do? I have no experience in doing this. Is that possible to have some scripts in the HTML to run macros in the excel files? Then inside the...

Thanks for the codes. I have modify it so that it can have findall(database as range, outputfield as string, criteria as range) format. Function FindAll(database As Range, outputstring As String, criteria As Range) Dim sOut As String Dim rnglookup As Range Dim counter, inputfield...

I need to write a UDF to simulate DGET so that the function will return a string with all the records matched the criteria. For example: =DGETModified(Database,"Name",Criteria) The result will be a cell with value, "Name1, Name2, Name3" Name1, Name2, and Name3 are extracted...

I am a newbie in Access. I need to insert an Excel Chart object into a form in Access 97. Therefore, I created a new form and insert a new Ms Excel Chart object. After that, I went to the object property to enter the "Row Source Type" and "Row Souce". I get a message saying...