Search results for query: *

you might find that each of the links in the copy-to sheet are being maintained in each cell's formula. it might be somthing in the format of &quot;=[thatWorkbook!thatWorksheet]C5&quot; <sorry- been a long time since messed with this stuff- not exactly sure that it's correct- but the idea is...

Either declare the slWS worksheet variable or turn off option explicit. dim slWS as worksheet is the line you need to add... Kaah. BTW: By first glances, once you fix this one you'll have a few others with the same problem pop up...

guarantee that its good for what? for what industry? for which IT/LAN/WAN environment? for what size userbase? for what reporting requirements? For what time frame of implementation? Kaah thinks it's curious that hudi is able to give advice on so little information...

or even, function KillFile(sFileName as string) as boolean '\\returns true if file is found and deleted, else false KillFile = True if dir(sFileName)<> &quot;&quot; then kill sFileName else KillFile = false end if end function

Hi, This code will give you the basics (and it is very basic!)... Insert this code into the ThisWorkbook object,, it will run automatically every time the workbook is opened... Private Sub ThisWorkbook_open() activesheet.range(&quot;A1&quot;).value = inputbox(&quot;Name?&quot;, &quot;My...

Hi, This code will give you the basics (and it is very basic!)... Insert this code into the ThisWorkbook object,, it will run automatically every time the workbook is opened... Private Sub ThisWorkbook_open() activesheet.range(&quot;A1&quot;).value = inputbox(&quot;Name?&quot;, &quot;My...

or even: sOut = right(sString, Len(sString)-1) k.

Use this command: Workbooks.OpenText <parameters> Like i said before, record the file being opened into a macro to get the correct parameter settings. This will open the file in excel with tab delimiters working correctly. You wont have to do any coding at all using this solution. Never...

you cant indentify a tab character because in a text file a tab is just a a series of spaces. You can either manually process the file through VBA to import it (tedious, slow, code intensive), or, you can record a macro which opens the file as a text file (fixed width obviously) and you set...

Mos, Thanks dude, that did the trick, its all looking good now... regards k.

Hi all, Has anyone tried to dynamically generate activex controls straight onto an excel sheet? I have been messing about with it and am almost there with it but I at present have one last issue to sort out. This is the important code so far. It loops through an array and for each array cell...

that wont work, its an excel 2000 feature, erin has 97. look at this stuff (its straight from the help file), ...... Visual Basic can create new objects and retrieve existing objects from many Microsoft applications. Other applications may also provide objects that you can create using Visual...

In VB when you enclose a parameter in brackets it indicates that you're expecting the function/method to return a result. In the above example, you'll find that if you let your function return a result to somthing then you can keep the brackets there. ie. '\\this will work sMyResult =...

Fred, Thanks so much! That helps a lot- now all I need to do is find a way to force driveshare.exe to close at the end of the excel run. thanks again, K.

Greetings all,, any help would be appreciated, I am running Terminal Services under Win2k and have applied the RDPClip (to allow cut/copy-paste of files between local machine and TS Client session) and Driveshare (to allow local client drives to be mapped in TS Session) patches. Unfortunately...

Karpov, have you tried using the new office web components? They run within the browser and are in general pretty nifty. Search through microsoft.com for more info. I've never seen a whole instance of excel running within a browser, I'm not sure its possible...here's a url...

Sarahnice, yep, there sure is, put your macro into the workbook_open private sub (this way it'll run as soon as the workbook opens), then put into your batch file the command to start excel and the workbook, I dont know what kind of batch file you're talking about (more info next time would...

Andrea (fitchic), the easiest way to do it is using the usedrange property, the usedrange property of a worksheet is a system defined worksheet range that is inclusive of every used cell in the worksheet, its very usefull, but can be tricky sometimes (it is ideosyncratic)...here's code...

B, I dont know the ins-and-outs of coding for data validation tools, Do you really need to use it for this application? The dropdown that comes from the data validation function is system generated and I've never tried to reference it through code... However here's code that will generate an...

Yep, heres code: Private Sub ComboBox1_Change() ComboBox2.Clear ComboBox2.list = PopulateValueArray(ComboBox1.list(ComboBox1.listindex)) end sub Function PopulateValueArray (ListType as variant) as variant dim vReturnArray as variant '\\insert code here to populate an array...