PC Review


Reply
Thread Tools Rate Thread

Re: #VALUE error in Excel using Visual C++ DLL

 
 
John Lai
Guest
Posts: n/a
 
      2nd Jun 2005

Hi Chris,
I did some minor changes to your VBA code and it worked for me. I added
the Private modifier as well as added a subroutine:

Private Declare Function get_system_time_C Lib "C:\Program
Files\Microsoft Visual Studio\MyProjects\060205dll\Debug\060205dll.dll"
_
(ByVal trigger As Long) As Double

Function Get_C_System_Time(trigger As Double) As Double
Get_C_System_Time = get_system_time_C(0)

Private Sub CommandButton1_Click()
MsgBox "Result is = " & Get_C_System_Time(2)
'note: change the number 2 to what you need
End Sub

John

*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
 
jack robin
Guest
Posts: n/a
 
      10th Jun 2005
It didn't wark for me any suggesstions. I have spent over 3 hours on
this problem.


*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Visual Basic error File already exists (Error 58) =?Utf-8?B?S2VsbGV5?= Microsoft Excel Crashes 4 16th May 2007 11:01 PM
Excel Visual Basic Error cmar Microsoft Excel Misc 2 10th Jun 2006 01:13 AM
Error at excel 2003 startup: Visual Basis error moduleVBRun97???? =?Utf-8?B?Ym9iIGRlIGpvbmc=?= Microsoft Excel Crashes 2 23rd Dec 2005 11:24 PM
#VALUE error in Excel using Visual C++ DLL chris_j_adams@hotmail.com Microsoft Excel Programming 0 29th May 2005 10:03 PM
Excel 97 Visual Basic Error 419 Aaron Microsoft Excel Crashes 0 25th Jun 2004 08:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:08 PM.