New Posts  All Forums:Forum Nav:

Excel into VB?

post #1 of 6
Thread Starter 
My Dad, has made a 'Voltage Drop Calculator' in excel. You type in 8 variables, it then references LOTS of cells to come up with 5 answers (the colored boxes in the picture), i need to make it a program. What would be the best way of copying or referring to the excel spreadsheet in Visual Basic(08) to make it a working calculator and open just one window?

My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7-720QM Hewlett-Packard 1448 RADEON HD 5650 8GB DDR3 
Hard DriveOSMonitor
640GB Windows 7 64bit 15.6" LED 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7-720QM Hewlett-Packard 1448 RADEON HD 5650 8GB DDR3 
Hard DriveOSMonitor
640GB Windows 7 64bit 15.6" LED 
  hide details  
Reply
post #2 of 6
it would be easier/better to just program in the constants, and the formulas for the calculations. How many is 'a lot'?
OC Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
E8500 @4GHZ Gigabyte P45 4850x2 2GB IT LIVES! 4GB 
Hard DriveOptical DriveOSMonitor
500AAKS+250external CD-DVD combo windows 7 ultimate x64 26" 
KeyboardPowerCaseMouse
MC$ wireless 650w corsair antec 900 Logitech battlefield 2142 G5 
  hide details  
Reply
OC Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
E8500 @4GHZ Gigabyte P45 4850x2 2GB IT LIVES! 4GB 
Hard DriveOptical DriveOSMonitor
500AAKS+250external CD-DVD combo windows 7 ultimate x64 26" 
KeyboardPowerCaseMouse
MC$ wireless 650w corsair antec 900 Logitech battlefield 2142 G5 
  hide details  
Reply
post #3 of 6
Thread Starter 
Quote:
Originally Posted by ZTR1760 View Post
it would be easier/better to just program in the constants, and the formulas for the calculations. How many is 'a lot'?
It's basically just table lookups. Is there anyway to put tables into VB or somehow combine an excel document into an .exe?
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7-720QM Hewlett-Packard 1448 RADEON HD 5650 8GB DDR3 
Hard DriveOSMonitor
640GB Windows 7 64bit 15.6" LED 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7-720QM Hewlett-Packard 1448 RADEON HD 5650 8GB DDR3 
Hard DriveOSMonitor
640GB Windows 7 64bit 15.6" LED 
  hide details  
Reply
post #4 of 6
Probably, you would have to use *cant think of proper terminology right now* but an in-between thingy (specific I know.) but I feel as if it would be better programming to include them as constants, or put it as a DB into the program (as you are using Excel as one pretty much)

I think there is a way to import from excel into access???? Possibly?
OC Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
E8500 @4GHZ Gigabyte P45 4850x2 2GB IT LIVES! 4GB 
Hard DriveOptical DriveOSMonitor
500AAKS+250external CD-DVD combo windows 7 ultimate x64 26" 
KeyboardPowerCaseMouse
MC$ wireless 650w corsair antec 900 Logitech battlefield 2142 G5 
  hide details  
Reply
OC Beast
(13 items)
 
  
CPUMotherboardGraphicsRAM
E8500 @4GHZ Gigabyte P45 4850x2 2GB IT LIVES! 4GB 
Hard DriveOptical DriveOSMonitor
500AAKS+250external CD-DVD combo windows 7 ultimate x64 26" 
KeyboardPowerCaseMouse
MC$ wireless 650w corsair antec 900 Logitech battlefield 2142 G5 
  hide details  
Reply
post #5 of 6
Use an XML file you distribute with your application. DataSets, which are a core piece of ADO.Net easily read from and save to XML files.
Main System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II X6 1090T MSI 890FXA-GD70 XFX Radeon 5850 16 GB Corsair XMS3 DDR3 1333 
Hard DriveOSMonitorPower
3 X 7200 RPM / 1 TB Win 7 Ultimate 64 2 x ASUS 23" VH232H 1080P SeaSonic X-650 
Case
Corsair 600T 
  hide details  
Reply
Main System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II X6 1090T MSI 890FXA-GD70 XFX Radeon 5850 16 GB Corsair XMS3 DDR3 1333 
Hard DriveOSMonitorPower
3 X 7200 RPM / 1 TB Win 7 Ultimate 64 2 x ASUS 23" VH232H 1080P SeaSonic X-650 
Case
Corsair 600T 
  hide details  
Reply
post #6 of 6
i could make you one with c# in a couple of minutes. pm me if your interested.
Pepe Silvia
(13 items)
 
  
CPUMotherboardGraphicsRAM
255 @ 4 Ghz MSI 870-C45 GT 520 @ 1Ghz Crucial Rendition 4GB DDR3 
Hard DriveOSMonitorPower
Hitachi 1TB Win 7 19" 420W 
  hide details  
Reply
Pepe Silvia
(13 items)
 
  
CPUMotherboardGraphicsRAM
255 @ 4 Ghz MSI 870-C45 GT 520 @ 1Ghz Crucial Rendition 4GB DDR3 
Hard DriveOSMonitorPower
Hitachi 1TB Win 7 19" 420W 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Application Programming