Search results for query: *

Hello All, how can I re-size a worksheet and it's ActiveX buttons based on a user's PC resolution? Is there a way to reliably detect the screen resolution and adjust the worksheet with the ActiveX controls? I have developed a worksheet with ActiveX controls in resolution 1600 x 900. When a...

Hello all, I have a text box on a ActiveX form. I have an image on my clipboard. The image can be bitmap, jgp, gif, etc. Is it possible to past that image into the text box? What would I need to code for this to work? Thanks in advance for any help.

Hello all, I have an ActiveX toggle button on a worksheet How can I pull the Value ("True" or "False") from the Toggle in a module using Excel VBA? Thanks in advance for any help.

Hello All, I have a worksheet that has hyperlinks in some of the cells. I am using a macro to prevent scrolling on this worksheet. When I prevent the scrolling, via Developer tab ===> Properties ===> ScrollArea A1:Y1 the hyperlink are not clickable. Is there a way to prevent a sheet from...

Hello All, How can I dynamically create EXECL tabs from a list of names in a master tab from a macro? I have a master tab with personal data. In that tab there is a column that has a list of names that repeat - I need to get a distinct list of names from that column - I need to take that list...

Hello all, I have a single source file that I want to split into multiple target files. The source file will vary and contain the target path and file names. See below for details. I want to create generic process that will not rely on hardcoded target path and file names. Is this possible...

Hello everyone. I am brand new to UNIX and need write a script that will run every ten mins. The script will look at a directory full of files that have been FTPed to it. The logic will be: 1) Look at a directory for new files that have an extension of ".send" 2) If there are new ".send"...

Hello All. Does anyone know of a Java code analyzer that will produce/export a data dictionary or glossary? Thanks in advance for any help

I would like to implement spell check in my application front-end using a custom dictionary. Would someone provide some guidance? Thanks in advance for any help.

Hello everyone. First let me say that there will probably be some silly questions coming from me, as I am not a VB front end developer. I normally work on back end coding. I'm trying to develop a VB front end application that will perform graphical data mapping. What I want to do is build an...

Hello everyone. First let me say that there will probably be some silly questions coming from me, as I am not a VB front end developer. I Normally work on back end coding. I'm trying to develop a VB front end application that will perform graphical data mapping. See first two sample images...

Hi all. Not sure if this is the correct forum. I have a PDF file that I want to save as a text file. When I open the file in adobe reader 8 I can go File ==> Save as Text and I'm done. I need to do this for 7,000 + pdf files. Is it possible to executed File ==> Save as Text from a dos...

Hello everyone. I have an excel spreadsheet linked as a table in a database. I have several queries that use this table. The column names in the linked spreadsheet is constantly changing, which is impacting all the queries. Columns are constantly being added and deleted as well. Can someone...

Hello everyone. I have an excel spreadsheet linked as a table in a database. I have several queries that use this table. The column names in the linked spreadsheet is constantly changing, which is impacting all the queries. Columns are constantly being added and deleted as well. Can someone...

Hello everyone, I want to use VBA in excel to find the column heading and line title for each cell in a very large spreadsheet. In the example below I would like to see VBA resoled C6 to C6 = LineGrpHead.Linehead_1.Col_1, D7 to D7 = LineGrpHead.Linehead_2.Col_2 and so on. Is this possible...

How do I get the line number of every occurrence of a string in an ASCII text file with minimal reads and counting each line? I have an ASCII text file with close to 8 million records in it. I need to scan the file and provide the line number for every occurrence of a string. Thanks in...

Hi all. I need to import a group of excel spreadsheet. They all have the same columns names but are in different order. In sme cases the used has added an extra column or two. See examples below MS Access Target Table Column_A Column_B Column_C Source_Spread_Sheet_1 Column_A Column_B...

Hello everyone. I have a MS Access 2003 report that is displaying data from a DB2 database. The MS Access database tables are linked to the DB2 database tables via odbc. There is a column in the DB2 database that has a data type of varchar 255. That DB2 column has new lines in it that was...

Hi all. Where can I download .NET 2003 Runtime environment and C++? This is a prerequisite to other software I'm installing. I looked on the web and could not find the download site. Thanks in advance for any help.

Hi all, I have a SATA drive with a XP image. I need to retrieve data files from this drive. The XP file windows\system32\config\system is corrupted. I have a laptop with a W2K Pro image that I want to use to access the SATA drive. I have a USB SATA/IDE converter to accomplish this. When I...