User Profile
Phil-365
Copper Contributor
Joined Feb 25, 2020
User Widgets
Recent Discussions
excel Vba
I have a program issue number eg 10.0009 which i update after any program changes it is incremented by 0.0001 however when implemented the new issue number 10.001 instead 0f 10.0010 Dim iOldId, sNewId Dim iNewId, OldId As Double iOldId = ActiveSheet.Cells(4, 11).Value iNewId = iOldId + 0.0001 I wonder if anyone could please point me in the right direction572Views0likes0CommentsRe: Excel User Form
Hi Doug If I can give you a brief summary I use the program to upload wildlife sightings to a database which is also an Excel Workbook. The different Butterfly, Moths and Dragon fly Species are held on a nother File, so the Workbook opens, writes and saves to two Files. As the error claims that the client was disconnected. I added the Specie data to the main Workbook, so the Workbook that originally held the Specie data was causing the problem of Client disconnected . I would be quite happy to send the Workbook and the code if you still require it. I also use variable to use as a specific Workbook Worksheet detail. Hope this throws a little more light on the subject1.1KViews0likes3CommentsExcel User Form
I have Created a program that has sucessfully used a Form to enter data for several years. Recently as soon as the Form is in Focus i receive an debug Form that states Run-time error '-2147417848 (80010108)': Automation error The object invoked has disconnected from its clients Can anyone help with a solution as this has only just started to appear over the last few days. I have other forms which are not affected in the same program1.4KViews0likes5CommentsRe: Saving Excel File to CSV
Bennadeau Hi Bernard Thanks for your help I will attempt your solution the next time i add data to the list Just out of curiosity a little more information I record wildlife data which is stored in Excel in a file, which i have attached for you. This file is created automatically by a program i have written in Excel VBA when the information is collected the Save routine at the end saves the file first as an Excel workbook, then as a CSV file, it is then that the date changes from dd/mm/yyyy to mm/dd/yyyyu1.4KViews0likes0Commentsexcel Variables
Hi Im trying to use a numeric system of Version numbers for my various programs eg 1.0000 however i seem to try and declare the variable when collecting the Version number from a selected cell, the number is either missing the end zero or the number is placed in quotation Marks any help would be gratefully appreciated1KViews0likes3CommentsRe: Running an Excel macro on cell change in a range of cells, the cell contains a formulae
Hi Thanks Jan I will place it in the required program which will make an immense difference to what we are tring to achieve. I have tried it in the example Workbook which obviously works, it will take out having to test the whole of the Cell range as your code supplies the Row. Once again Thanks for your time. JKPieterse1.2KViews0likes0CommentsRe: Running an Excel macro on cell change in a range of cells, the cell contains a formulae
Hi Jan Thanks for your time What I am trying to achieve is to establish if a cell in the range D2:D10 changes when the formulae is true and so shows Go. I hope that makes sense JKPieterse1.2KViews0likes2Comments
Recent Blog Articles
No content to show