Search results for query: *

I would like to preselect the folder that GetOpenFilename uses. if a drive has been created I know that I can use ChDir and ChDrive, but the folder that I need is on a network and has the path "\\server\folder" I want to just let the users select a file and not open it Any help would be much...

Has anyone got code to convert XML to Excel 2000 ? I know that later versions of Excel can do this (a bit), but I'm stuck with different versions where the lowest is 2000. I've got a routine for Excel to XML which I've not yet tested. Richard

I have a Form called FormInput which I have populated with ListBoxes which the users have to select. I am looking for suitable code to loop through all of these listboxes and return the values of the boxes. I have tried this as is suggested in my VBA book but it doesn't work. Dim a As Integer...

I am looking for a way to activate a particular worksheet from a timer function. The problem I have is that I do not want to use the workbook name in my code (unprofessional). I know that I can use ActiveWorkbook.Name to identify my book, which works fine if that book is active at the time, but...

I have created a button (called StartComms) on a form, and want the button text to change each time it is pressed. The code does NOT work if I just step through it, because although StartComms.Text does equal "Start Logging", the IF statement does not execute. If I force the execution of the...

Can anyone help me with this one please ? I have a bit of code that writes to an Excel file and works fine. I check to see if the file exists before opening it using ...If Dir("C:\testing.xls") = "" Then.... which works too, but I also need to be able to write to the file if the user already...

Can anyone help me with pasting the contents of the clipboard directly into an Excel Text Box (a shape)? My VBA script copies the contents of a Wordpad text file successfully so that I have what I need to paste into Excel, but although I can manually select my Text Box and paste the text into...

I have a program with a lot of Control boxes and I need to be able to get their Name, Linked Cell and Caption. The first 2 were easy, but Caption does not seem to work in the same way. Can anyone help please? Is there any way of just referring to checkboxes and not combo boxes for example ? Sub...

I have opened an Acrobat file from Excel in order to read its contents into Excel. That works fine. I would like to be able to detect the path to the open Acrobat file in order to write an Excel file back to the Acrobat directory. Thanks in advance, Richard

Can any of you Word specialists please help me with the following........ I have written a macro in Excel which cleans up a mainframe text file, imports it into Excel, saves it as an Excel database, and runs Word from Excel to automatically create labels using data from the database. This all...

Can anyone help me with improving my Mail Merge macro. The code below works OK,it creates a Word 2000 doc. with labels and reads in the contents of an Excel file. I need to format the resulting labels, (Font size & Bold). Is there an elegant way to format the text field after insertion ...