Checkout indirect function in excel help.
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
I assume that you would implement these list boxes in a user form. In that
case you can use, the Jet OLEDB Provider For Microsoft Excel Databases, to
query an XLS file. Below is the code snippet to use.
The code demonstrates how to use Jet OLEDB Provider For Microsoft Excel
Databases. You need to
I have large number of arrays with matching names apart from the
integer at the end ie combo!, combo2, combo3, combo4 etc and i need
to input data into each array from a single sheet with similar names
sheet1, sheet2, sheet3, sheet4 etc etc.
Now, the number of arrays is over 50 and i would prefe
hi
i want the code for page numbers to appear on top of the print preview of my
report on top on the right sidesimilarly it has to increment for each
page
for eg: if 3 pages are there it should come like
1st page : 1/3
2nd pg :2/3
3rd pg :3/3
i needed a generalized function so th
When I access my catalog defintion I get over 250 cubes. I'd like to
limit the catalog to specific cubes.
My code is like:
Dim catAdoMD As ADOMD.Catalog
Dim conn As ADODB.Connection
sConnString = "Provider=MDrmSap.2;Data Source=SB2;User
ID=myname;SFC_CLIENT=010;SFC_LANGUAGE=EN;"
Set co
