Nov 21, 2009

Manipulating Excel File With VB? - opening and doing data stuff in vb

 		free web hosting
Open Discussion & Free Web Hosting > Computers & Tech > Programming > Programming General > BASIC / Visual Basic (.NET)

Manipulating Excel File With VB? - opening and doing data stuff in vb

connectpal
May 23 2005, 02:41 AM
Part of my VB program is written with :

'(1) open Excel files
currentDate = Format(Date, "YYYY") & " " & Format(Date, "MM") & " " & Format(Date, "DD") & " " & "0000" & " " & "(WIDE)"
filePath = "C:\nbutane\rsview\DLGLOG\RSVIEW\" & currentDate & ".dbf"


When the VB executes, it'll open the file called 2001 11 23 0000 (Wide) with Excel.

My problem is when the file name changed to 2001 11 23 0001 (Wide) , the VB can't access it because it's reading from '0000'. Sometimes the file will change to '0002' .... and so on.

Please help. Thanks.

Comment/Reply (w/o sign-up)

kalyan
May 17 2006, 05:17 AM
QUOTE(connectpal @ May 23 2005, 02:41 AM) *

'(1) open Excel files
currentDate = Format(Date, "YYYY") & " " & Format(Date, "MM") & " " & Format(Date, "DD") & " " & "0000" & " " & "(WIDE)"
filePath = "C:\nbutane\rsview\DLGLOG\RSVIEW\" & currentDate & ".dbf"

My problem is when the file name changed to 2001 11 23 0001 (Wide) , the VB can't access it because it's reading from '0000'. Sometimes the file will change to '0002'

I dont understand onething... u have hard coded the 0000 like

" & "0000" & "

so when u want to open 0001 obviously u have to change.......

and .dbf for excel files... when microsoft chaged the exetnsion xls to dbf...and what is the extension for MSaccess files......

anyway how u r opening u r excel files in vb what are the extension or COM objects u have added i hope u cant handle ur excel files with out the extension or DOM object..like ordinary files..

be clear while asking

 

 

 


Comment/Reply (w/o sign-up)

CaptainRon
May 23 2006, 12:28 AM
connectpal wrote on May 23 2005, 08:11 AM
kalyan replies on May 17 2006, 10:47 AM
laugh.gif

You are asking him to be clear after 1 year? tongue.gif
Hey Kalyan, anyway how deep did u dig to get to this super old post???? ohmy.gif

Comment/Reply (w/o sign-up)

Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)


See Also,

*SIMILAR VIDEOS*
Searching Video's for excel, vb, opening, data, stuff, vb
advertisement



Manipulating Excel File With VB? - opening and doing data stuff in vb

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com