|
|
hi all ,
i need to execute data according to the week entered. which means when i key in "4" weeks at the user input, it will execute 8 weeks data and when i key in "6" weeks, it will execute 12 weeks data. at this point i use the formulae offset to extract the data from table. please help me with this...
thanks and regards,
rachel
|
|
|
|
Hi, Rachel.
I`m not clear on what you want to do, but I understand your "database" will be an Excel spreadsheet--correct? Are you writing a VB 6.0 application that works with the data in the Excel spreadsheet? Or are you instead creating an Office Application using VBScript macros in the Excel document?
We need to know from what angle to craft a response.
|
|
|
|
|
|
Troy Wolf,
I`m not clear on what you want to do, but I understand your "database" will be an Excel spreadsheet--correct?
Yes, it in a spreadsheet.
Are you writing a VB 6.0 application that works with the data in the Excel spreadsheet? Or are you instead creating an Office Application using VBScript macros in the Excel document?
Im writing VBscript in Excel document.
Im not sure whether i can attached the file here or another alternative maybe cahn send you my spreadsheet using email so that you can a view to my spreadsheet?
Regards,
Rachel
|
|
|
|
Rachel, if necessary, you can send your spreadsheet to my email address and I`ll take a look for you. This forum does not allow file attachments. I`d like to keep our discussion here in the forum as much as possible so that others can benefit if they have the same questions. My email address is as shown, but replace [at] with @.
Can you answer whether you are wanting to create VBScript macros in Excel or write a full VB application to work with the spreadsheet?
|
|
|
|
|
|
Troys,
Can you answer whether you are wanting to create VBScript macros in Excel or write a full VB application to work with the spreadsheet?
i want to create VBScript macros in Excel...
i`ve sent an email to you with attached file.
|
|
|
Archive Import (rachel) 
Troy Wolf