Search results for query: *

Hi, I want to know if I have a named cell e.g. A1 is Named as "AValue" and holds the number 33.6. So in a formula if I AValue I get the number 33.6 Now if I have A2 holding "AVa" and B2 holds "lue". If C2 has the formula "=concatenate(A2,B2)" the result in C2 is "AValue" as text. Now the...

Hi, Does anyone know of a library package or similar that will allow me to convert and save jpeg images into PGM format using VB6? Thanks George

Hi, I used your code in thread222-1000041 but I get an error on this line COMMData.NewDataString = S in Private Sub MsComm1_OnComm() ' this sub fires whenever new data has arrived at the Comm port Dim S As String S = MSComm1.Input ' send this new string to the COMMData class for assembly...

Hi, Suddenly one of my databases which has forms produces an error when ever I use a control that has an event procedure attached. For example when I have an event procedure On Mouse Down and click on it, I get "The expression On Mouse Down you entered as the event property setting produced...

Hi, I want to insert an image in an Excel workbook so that each time the workbook is opened the image is refreshed so that I get the latest version of the image. I am sure this is easy but today has been long and obviously the mind is mush. Any help most appreciated. Thanks George

Hi, I have a spreadsheet that has many formula and decided it was better to name the cells used in those formulas with meaningful names. Presently they are in $C$R format. So having named the appropriate cells, I now want to change all the formula references from $C$R type to my Names. Is...

Hi, I am trying to develop an application and it seems as though all my projects are linked which causes them to all update each time I save the current project. What I want to do is to make a new version of my project by saving the present project with a new name e.g. if my present project...

Hi, I have been given an excel workbook to check the macro coding and each time I run any of the macros I get an error "Compile Error Can't find project or library" on a line such as "ThisRow=2" if I declare the variable with a Dim statement the macro will proceed until the next variable...

Hi, I have a combo box on a Userform (initiated by clicking a command button)that I want to show all the names of the sheets in a workbook - no problem to achieve this - I added the names using AddItem on the Userform Initialise event, then I show the Userform. The inital value shown in the...

Hi, I have an event procedure that is triggered when any data in the sheet is changed, part of this event should unhide (make visible) a command button to re-calculate other information in the workbook. I am having trouble hiding and unhiding the command button. I have used the Control toolbox...

Hi, Using Names for cells, ranges or variables is really useful especially using them in macros but does anyone know if they can be restricted to use on just one sheet, or perhaps some sheets but not others. Generally they are available on all sheets in the workbook. Thanks George George

Hi, I have two excel data files that have a DateTime column in the following format dd/mm/yyyy hh:mm:ss What I want to do is take the first DateTime value in file one and find the closest time in file two and then copy some data from file two to file one. All the copying etc is no problem, my...

Hi, If a spreadsheet has 50 columns x 250 rows and you delete great chunks of them, say to only have 10 columns by 50 rows left, then use Print Preview, Excel shows the preview as if all the columns and rows(50x250) contained data. If the shortened spreadsheet is saved and then re-opened...

Hi, I have multiple forms in an Access extraction application where when the user presses the Next button it closes the present form and opens another. My problem is that they seem to have a mind of their own where they are displayed on the screen. I have been very careful to ensure that all...

Hi, I am writing a Wizard type approach for non Access gurus to extract data from a database. Each form drills further down into the data with only those records based on previous forms being presented. I have got it all generally working but have this annoying problem. The first form asks the...