Search results for query: *

Something that used to be very easy: in Excel VBA, open Word document as ReadOnly file, do something, close Word doc, move to the next Word doc. So, I have this code in Excel (with the Reference to Word): Option Explicit Sub OpenWordDocs() Dim wdApp As New Word.Application Dim wdDoc As New...

Getting hyperlinks from Word document, but some of them are pretty long, something like http://www.abcd.com/zgx-bin/retrieveEC23y1.0.1.7.18&r=PART#23:1.0.1.7.18.0.1.4 and when I say: oLink.Address, the link is cut at the # character. What do I need to do to get the whole URL, including # and...

My co-worker is working on Mail merge in Word based on data in Excel. She was able to save those docs as individual documents and name those files based on the info in the header (I think). So far so good, but... The issue is, the data in the header is a Project Number that is in the format of...

Trying to write a formula that will give me in the cell: strStepValue = "'" & !PT_COLOR.Value & "'" PT_COLOR will come from cell C5, so my formula is: ="strStepValue = & !" &C5& ".Value & ""'""" but that gives me strStepValue = & !CA_SOL_DISP.Value & "'" in the cell I have managed to include...

I have 2 places with the data: SQL Server and Oracle. I can connect to both of them, Select the SQL Server data and insert record by record into Oracle. But this is slow, too many records. Is there a way to do: Insert Into MyOracleTable (Field1, Field2, Field3, ...) Values (Select FieldA...

A user has an Outlook Template (*.oft file) formatted as Rich Text where they have some text they would like to replace with the data from the data base (instead of typing or copy-n-paste). So I set the text in the Template that needs to be replaced matching the fields in the data base., i.e...

I have SQL Server Management Studio 20.1.10.0 and most of what I do I can manage (pun intended). When I run CREATE TABLE everything seams to be OK, and when I right-click on my new table and do “Select top 1000 Rows”, the basic Select SQL shows up and works just fine, but – all fields and the...

I grab data from SQL Server in ADODB.Recordset where DateTime data comes as: 2024-02-07 16:00:00.0000000 2024-04-12 16:00:00.0000000 2023-11-21 16:00:00.0000000 2023-12-18 16:00:00.0000000 2024-01-04 16:00:00.0000000 But the Users do not care about time portion. They just want to see the Date...

I create an Outlook email from other application in VBA. I can place a text in the Body of the email just fine, but that wipes out the signature. Dim OutApp As New Outlook.Application Dim OutMail As Outlook.MailItem Set OutMail = OutApp.CreateItem(olMailItem) With OutMail[green] .Subject...

To get the values in Excel with this line: Application.VBE.ActiveVBProject.VBComponents.Count I needed to go to: File - Options - Trust Center - Trust Center Settings - Macro Settings and check Trust access to the VBA project object model What do I need to do / set in Outlook to be able to...

I have this huge data base (1669 Tables) that I am trying to 'analyze' and one of the 'checks' is: how many PK-FK Relations do I have between the tables? From this site I've got some good SQL's to list tables with FK and related tables with PK. I have (only) 157 records. Great! Something...

If I have data in two columns (Number and Letter), how can I sort it to get this order: Number Letter 1 2 3 3 A 3 B 4 4 A 5 5 B Number without the Letter would be first, then A and B, as: 3 3 A 3 B ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson

OK, so I have this link: How to Disable Google Chrome Password Manager which says: 1. Click the three dots in the top right corner of your browser window. OK, easy enough 2. Head to Settings and choose Passwords (under the Autofill tab). OK, found it 3. Turn off Offer To Save Passwords. WHERE...

The IntelliSense is Excel works sometimes, and doesn't other times. This works every time: But when I type this, I get some help from Excel: I keep typing, but then cells(1, 1). dosn't give me any hints after the period when I want to have: Cells(1, 1).Value for example The same when I...

Venturing back to VB.NET (2022) world after many years in VB6 I would like to create a (Windows) Project, but start in Sub Main() instead of Form1 since I do not need any forms/controls/etc. or any user input at all. How do I do that in VB.NET 2022 [ponder] ---- Andy "Hmm...they have the...

With the reference to Excel, this code works OK in 2015: Imports Microsoft.Office.Interop Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim xlApp As New Excel.Application Dim strExcel As String =...

New to SQL Server, so I would ask the experts. I see a lot of tables with fields defined as nvarchar(MAX) (up to 2GB of data?) or datetime2(7) (all the way to a millisecond), etc. I like to use a ‘lean-mean’ approach to defining data types in my tables, so if my data will not (should not) exceed...

If I have data like this: FirstName Andy angela Bob bill And I want a list of names that start with a Capitol 'A' or 'B', or lower case 'a' or 'b', so I've tried: Select FistName From MyTable Where Substring(FistName, 1, 1) = 'A' and that does not work, I get records: Andy and angela :-( How...

New to SQL Server Management Studio, and I have noticed these [highlight #FCE94F][ ][/highlight] everywhere. Driving me nuts. Is there any option to set (in Tools - Options... or Customize...) to get rid of them? I did find a 'work around' here, but I would have to do that EVERY TIME ----...

Let's say I have this data in Excel, 2 lists of similar data: A B C D 1 Name Age Name1 Age1 2 Andy 27 Andy 27 3 Betty 21 Ann 24 4 Charlie 77 Betty 21 5 Zak 30 Zak 43 and I would like to find which A/B data matches...