Search results for query: *

Input forms (html) Access ,Word tables, email output if it is Tables in HTML, you could cut and paste or make a webquery Txt or ASCII you can import direct Are we talking a few people or 100s or thousands

Certain addins are run my macros then are installed when you load your program First have done a virus , spyware scan Do you open and close your word program frequently sometimes the previous memory allocated is still appears used.

Depending on your version of office , the lastest office allows you to load on one machine with your serial number and you need your number to remove otherwise you can not transfer to another machine. The problem is that the serial number is still embedded probably in the registry and the...

Thanks I think I got it dbs

Skip Very usefully , scroll with forms works great ie ActiveSheet.Shapes("Scroll Bar 1").Select With Selection .Value = 200 .Min = 100 .Max = 1000 .SmallChange = 1 .LargeChange = 10 .LinkedCell = "$C$1&quot...

Can one with VB code set the max and min properties of a scrollbar to a cell ? ie max= a1 min= b1 Can one set the scroll bar color and/or the knob (slider) in VB to change relative to a cell value or value in excel ie last > 100 Blue or .80*(a1) last < 40 Red or 1.20 (b1)...

data has only 4 fields date time price size file can be txt or csv space, delimiter etc search or filter would be the last hour of data for todays date I would have a macro refresh the query every 5 secs The dde data is there to reconcile last sale info and the lag of the refresh function I...

I read two ways to define a range using the offset method and hard coding ie Sub Set_TradeSize() Application.ScreenUpdating = False [tradesize].Activate FirstCell = ActiveCell.Address curcolm = ActiveCell.Column LastCell = Cells(65536, curcolm).End(xlUp).Address rng =...

While not a perfect one Set worksheet Menu bar invisible see previous post Hard code your named ranges for example Sub Set_TradeSize() Application.ScreenUpdating = False [tradesize].Activate FirstCell = ActiveCell.Address curcolm = ActiveCell.Column LastCell = Cells(65536...

I have created a excel spreadsheet that imports ascii data thru webquery directly into the spreadsheet . The information is date,time, trade price,trade size using a product called q collector for esignal and refreshes the data every 5 seconds From the data I use certain array calculations to...