Search results for query: *

So to get information from the shape I need to read through the shapes. Whilst doing this is there anyway to determine the cell location of the shape on the worksheet? I want to take the email address from the shape/hyperlink and write into the cell to the left of where the shape is located.

Thanks for this combo. I am having a bit of trouble. Firstly, as the hyperlinks I am trying to unravel are small envelopes that I copied and pasted from an internet site - I assume these would be classed as 'shapes'. In your example you coded Set h = ActiveSheet.Shapes(1).Hyperlink Is it...

I have an excel worksheet that contains cells which have an envelope icon. In excel if I move my mouse over the icon the mail address is displayed. Is there any way that I can obtain this information programmatically using VBA? Any solutions would be gratefully appreciated and save me a lot of...

Thanks for your help here folks. I used the QCDRCMDI api within a CL program and passed the output from each call into a program that wrote the details onto a disk file. Thanks again

thanks flapeyre, but what I am looking for is a command that I can run that puts the details of all command programs in a library to a disk file (*OUTFILE) (bit like DSPOBJD), rather than run DSPCMD for each command individually - I have got about 500-600 to look at.

I have a lot of *CMD programs on my AS400 which run CL programs which are not the same name as the command. Is there a command that I can run and output the information contained in 'Program to Process command'. I have tried DSPOBJD to an *OUTFILE but this doesn't show the information...

I have a VB6 application that uses ADO to write to an MS Access database, via an ODBC link. I am writing entries to a log file in Access depending on events happening in my application. My problem is that the process works fine in debug mode, but in normal mode it doesn't always write the...

In VB6 I used an ADO data control with an ODBC link to my Access database. The Recordsource of my ADO Data control holds the SQL statement "Select * from Table". I then had a Datagrid control which has the Datasource set to my ADO Data Control. When using VB.NET I have set up the ADO data...

I have programmatically created an Excel spreadsheet from my VB6 program. I then go on to update the Excel spreadsheet by creating new sheets and adding data into those sheets. My problem is that is an inconsistency in its performance - in some cases the process works fine, but at other...

Hi, I have a text file that I wish to break up into a number of smaller sized files. I am reading the input file using INPUT #1, Textline and writing the output file using PRINT #2, Textline However, some of the lines include commas, and this results in two output records being created...

I am new to vb.net and trying to connect a datagrid to an Access database via ODBC. In VB6 I used an ADO data control and set the properties to use my ODBC and then set the recordsource with an SQL string. I then linked the datagrid to this ADO Control. This involved no direct coding. I...

My SQL exposure is relatively basic. I was wondering if it is possible to build a command that can retrieve data from a table into new columns. I have a table with the following columns: AccountNo Ccy Amount where the Ccy is always either GBP or USD. I want to create an SQL statement that...

Here is the code I am using briefly - i m reading the xl sheet to determine the number of records so that I can use a progress bar, then I am reading the xl sheet to derive information from selected rows and then populating the arrays in the sub. The excel file I am accessing has about 10...

I have a vb application that opens and reads a worksheet in Excel. The process is quite slow. I was wondering if there are any tips or pointers on speeding up the process. Thanks

Sorry folks, this was a red herring. I have resolved my problem - the code above worked, the error I was getting referred to me trying to access a non-existent cell in the worksheet.

I am accessing an MS Excel file and wish to position on a specific worksheet using a variable. this is my code: *********************************** Dim ExcelApp As Excel.Application Dim ExcelWorkbook As Excel.Workbook Dim ExcelSheet As Excel.Worksheet Set ExcelApp =...

Thanks very much for all your comments and setting me straight on this issue.

I have a strange situation and I do not what to do about it. I have two fields Dim A As Double Dim B As Double In my code I am accumulating values from Excel cells and then I am doing a comparison of A and B. With the 'Add Watch' facility in the debugger I have A = -3263.18 B = -3263.18 In...

Hi, Is there any way I can highlight a specific record/row on a tabular form based on the value of a particular field/column in that record/row? If so where do I insert the code? Thanks in anticipation.

I'm having some trouble with dates. I am writing a VB6 application and using MS Access. When I write a date say 10/3/2006 (UK format) to my database it appears as 03/10/2006 (US Format) on the file. Are there any settings I need to change in Access? if not is there any recognised procedure to...