Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PBAPaul
  • Content: Threads
  • Order by date
  1. PBAPaul

    Problem with Format of Date Using Spinner.

    I have a userform which uses various text boxes operated via spinbuttons. I successfully use the following code to vary the date: Private Sub SpinButton1_SpinDown() TextBox1.Text = Format(CDate(TextBox1.Text) - CDate(SpinButton1.SmallChange), "dd mmmm yyyy") End Sub Private Sub...
  2. PBAPaul

    Using a SpinButton to Cycle Through A Worksheet Range.

    I have a problem, in Excel 2010, using the spinbutton in a form accessing a range in a worksheet. I will try to explain the problem. I have a range in a worksheet called "MyDrugs". It is in a column eg A1 to A20 and contains the names of medications that I have to take. I have a UserForm that...
  3. PBAPaul

    Spinner Button Change Value in Text Box By Formatted Date

    I wish to use VBA to change the value in the relevant text box in a full formatted value. ChangeWednesday, 21 March 2018 With a spin to [indent]Thursday, 22 March 2018 I have a spreadsheet calculation that I can use to show the day from the date but I want a single spin to be able to change...
  4. PBAPaul

    Put Excel Parameter into Word Macro

    Hi All I am sorry that this might be a simple question but unfortunately I am in hospital away from my usual environment of reference books, files and seemingly at the moment – Brains! I have a complex Excel workbook (Medications Control.xlsm) that controls a number of internal and external...
  5. PBAPaul

    Activation of Excel VBA to Print Word Document

    I have Excel VBA code that opens a Word 2010 document and calls the Word macro. The Word macro is a simple print program which I have checked and it works as it should. If I step through the Excel macro then everything works as intended. However if I attempt to run the macro, it gets to the...
  6. PBAPaul

    Excel Macro Layout

    I have stupidly managed to completely buggar up (please excuse that technical term) the layout of the macro sheets in my Excel 2010 Workbooks. I have used the default Excel for layout for so long that I am very used to it. I used to have the Project Explorer Window docked vertically to the left...
  7. PBAPaul

    Trying To Get Computer Name in Excel VBA

    I have just upgraded my systems from Office 2003 to Office 2010. In a VBA project that was created in Office 2003, I need to copy a sheet from a file to each of the other computers on my network. I use the 2003 VBA code of "NameOfComputer" I use this to find the name of the initiating computer...
  8. PBAPaul

    Location of Cursor in Excel

    I have a spreadsheet with 8 columns. There are 8 rows starting at row 2. What I want to do is to show in row 1 a calculation - which is dependent on the column in which the cursor is in and in previous calculations - in the column in which the cursor is located. The problem is that I do not...
  9. PBAPaul

    Use Excel HTML File as HTML body text in email

    Hi All I have a system that will generate an invoice by using a worksheet "Invoice" and using VBA to enter the various details. The worksheet "Invoice" is formatted with borders, left and right aligned text, emboldened text etc. I can send this as an attachment but some recipients may not have...
  10. PBAPaul

    Vertical Caption in MSForm

    Hi I have a form where I have 20 combo-boxes in a line. These represent the useage of rooms in a hotel. I want to place captions above each of these combo-boxes to show the name of the appropriate room. The best way would be for the captions to read vertically ie text turned through 90...
  11. PBAPaul

    How Do I Delete a Word VBA Module and Form

    I need to distribute a new module and associated form to various people. I know that an old version e.g. 'Old_Module' and 'Old_Form' exists on some machines and I want to delete both of these (if they exist) from the existing Normal template before adding my 'New_Module' and 'New_Form'. Please...
  12. PBAPaul

    How To Check Internet Connection

    I have a program that will take a UK Post Code and then open an online mapping system that will show the location of that Post Code. This is done via the VBA code: ActiveWorkbook.FollowHyperlink Address:=L1, NewWindow:=True How can I check that the user has a live internet connection? If the...
  13. PBAPaul

    Use VBA to create user-defined field in Outlook Contacts

    I am accessing Outlook 2003 via Excel VBA to synchronise Outlook Contacts. I need to a) check if a field "MyField1" is present b) create it if it isn't. I will need to create about 6 user-defined fields. Can anyone help please?
  14. PBAPaul

    Office 2003 & Office XP Developer

    My system has been rebuilt and upgraded to Office 2003. I had XP Developer and want to re-install SourceSafe, Packager etc from my XP Developer CDs, but when I try to install, the system states that I don't have Office XP and will not accept Office 2003 as the main package. Does anyone have...
  15. PBAPaul

    Put Pop-up Calendar Into Excel Form

    Does anyone know how I might put a pop-up calendar into an Excel form so that the user can click on a calendar icon and then use the calendar to get a date? Thanks for any help. Paul
  16. PBAPaul

    Get Version Number for Files

    I have accumulated a number of downloaded files (system updates, shareware and freeware files) on my system. I know that using Windows Explorer to examine the properties of the files, I can access the version number of some of them. Does anyone know if this attribute can be accessed via VBA...
  17. PBAPaul

    Word Mailmerged documents still associated with source

    I am using Office XP. I have setup a main document - Master Merge.doc - with an Excel data source - MyDatabase.xls. In the main document, I have various fields from the data source. I mail merge to new documents - I usually merge from record 1 to 100, then 101 to 200 etc so that I have a...
  18. PBAPaul

    VBA Projects not clearing in Projects Explorer

    Hi All I am using Windows XP Pro with Office XP on both my main computer and on my laptop. On my main computer if I open an Excel file containing VBA then when I close it the Project Explorer window still shows the VBA project. Say I open the file MyFile.xls which has macros then I see in the...
  19. PBAPaul

    VBA in Excel to Shell Bat file and Wait for finish

    I have a batch file C_Dir.Bat that has the following script. It simply gets all the directories in C and pipes it to a text file. Dir C:\ /S/B/AD > C:\C_Dir.txt I searched for threads containing "Shell Wait" and I have tried numerous techniques shown but nothing seems to work as the batch...
  20. PBAPaul

    Determining Location of Office Directory

    I have been using VBA code to load references for projects. An example is below. With ActiveWorkbook.VBProject.References .Remove ThisWorkbook.VBProject.References("Microsoft Outlook 10.0 Object Library") strReference = "c:\program files\microsoft office\office10\msoutl.olb" .AddFromFile...

Part and Inventory Search

Back
Top