Search results for query: *

OK, I know this is strange and I hope somebody can help. I do some pretty extensive things in Excel. In a general sense, I have a book that contains a "parameter" sheet and 2 modules. One module contains all the code for pulling data from a database and sometimes building a pivot table from...

I do some pretty strange things formatting Excel pivot tables for clients but I've run into a stumper. I am trying to loop through all of the values for the page fields of a pivot table and then copy values and formats onto a seperate worksheet for each set of page values. It works fine except...

I have an Oracle server that I am trying to link to and access from SQL Server 7. I can access the Oracle server using the Oracle sqlplus command "sqlplus user/passwd@server" and "select field from schema.table" In SQL Server osql I issued the following...

Somebody just asked me about a weird problem that they are having. They are running Win98. They have a printer installed. They can print to it fine for days and then (as just happened between 2 print jobs) the printer definition went away. If you go to the printers control panel there is...

Does anybody know if there is a way to execute a series of sql commands from Excel? Everything that I have found requires a destination and that the query return data.

Is there a way using Excel 2000 to create a new workbook and copy 1 of the 2 code modules into the new workbook? What I am trying to do is create a macro that populates a workbook with data and a macro for formatting. I don't want the macro that does this included in the workbook being sent...

I have created several pivot table from a sheet of source data. The pivot tables are the same regardless of the of the source of the data in the source sheet with 1 small exception. For 1 data source certain values are to be excluded. This is easy enough, just...

Does anybody have a GOOD way to cause a detail line to be repeated? For example say I am trying to create a receipt for purchased items. I want to print out the information about the purchased item QUANTITY times. (I know add a quantity field to the receipt, but this is an example not what I...

I have a very dense report. It is showing where data problems exist and is trying to show as many pieces of information as possible on a line. I have already reduced the font size to 8 point. There are some fields that are good for reference, but too long to fit in the space allowed. I don't...