I need to know how to turn a URL (link) into a document that I can put on Google Drive in a shared folder.  I'd like people to be able to double-click on this document and it sends them to the destination URL.

Thanks

I want to change a text in a function.
I have $A$2 Want to change to $A2.

Thank you,

The ribbon changed in Word.  How do I get it back to normal.  Please see picture.  

Hi

I need to uninstall the latest update of Office 2019. I am worried that if I choose uninstall on the item in the image that it will uninstall Office 2019 completely

I want to update my 4 Office computers to Windows 10 Pro.  I just want to update the OS from Win 7 Pro to Win 10 Pro and leave existing applications and data as is.

I thought purchasing would be very straightforward but I see many options and prices.

On Amazon I see a Win 10 Pro on a USB for $189.  I see other offers for Win 10 Pro OEM for much less.

Question:
Where to buy Win 10 Pro?  I want to get a good price but some of the prices I see are suspiciously low.

Is there a difference between the OEM version and the others?

I have a excel file with all the data in Column A. I wanted to separate this to more columns. The pattern of the data is always the same. Attached is the file I am working on. Here are the columns we want

Column B: First Name and Last Initial. This always the 1st word in the cell then the 2nd initial.
Column C: The 8 digit number after the name
Column D: The first name after the 8 digit number
Column E: The last name after the 1st name
Column F: The part in Parenthesis
Column E: The 1st Date Listed
Column F: THe 2nd Date listed
Column G: The 3rd Date listed
Column H: The last number - it is between 1 and 99.
List2.xlsx

trying to post data from a recordset to sheet.

I have the folloeing recorst created in code:

But trying to loop through the data and place on the worksheet properly

dB2.CommandTimeout = 400
                With rs2
                 .ActiveConnection = dB2
                 .Open strsql
                End With



 
J = rs2.RecordCount

ActiveSheet.Range("A2").Select
      
For i = 1 To J  'rng.Count
    

Do Until rs2.EOF

      
        
        ' place data into sheet
        rng(i).Offset(1, 0) = rs2.Fields(0) '
        rng(i).Offset(1, 1) = rs2.Fields(1) '
        rng(i).Offset(1, 2) = rs2.Fields(2) '
        rng(i).Offset(1, 3) = rs2.Fields(3) '
        rng(i).Offset(1, 4) = rs2.Fields(4) '
        rng(i).Offset(1, 5) = rs2.Fields(5) '
        rng(i).Offset(1, 6) = rs2.Fields(6) '
        rng(i).Offset(1, 7) = rs2.Fields(7) '
        rng(i).Offset(1, 8) = rs2.Fields(8) '
        rng(i).Offset(1, 9) = rs2.Fields(9) '
        rng(i).Offset(1, 10) = rs2.Fields(10) '
        rng(i).Offset(1, 11) = rs2.Fields(11) '
        rng(i).Offset(1, 12) = rs2.Fields(12) '
        rng(i).Offset(1, 13) = rs2.Fields(13) '
        rng(i).Offset(1, 14) = rs2.Fields(14) '
        rng(i).Offset(1, 15) = rs2.Fields(15) '
        rng(i).Offset(1, 16) = rs2.Fields(16) '
     
 

        ActiveCell.Offset(1, 0).Select ' move down to the next row 
       
      rs2.MoveNext
    Loop
 Next i

Select all Open in new window

Thanks
fordraiders

proper passing of variables to sql server procedure in excel vba office 365 (64 bit)

Is this the correct way to pass variables to sql server stored procedure ?

Dim strStart As String
Dim strEnd As String


Dim myValue As Variant
Dim myValue2 As Variant
myValue = InputBox("Supply a Start Date Please. Format YYYY-MM-DD")

myValue2 = InputBox("Supply a End Date Please. Format YYYY-MM-DD")
 

Dim sQuery As String
    Dim i As Long
    Dim SearchCodes As String
    Dim dB2 As New ADODB.Connection
    Dim rs2 As New ADODB.Recordset

Dim dbconnstring As String
Dim strsql As String


Set dB2 = New ADODB.Connection
dB2.CursorLocation = adUseClient




dbconnstring = "provider=sqloledb;Server=B025.us.xxxxx.com;Database=PROGRAM_WORK;Uid=xxxx;Pwd=zzzzz;"

' IS THIS LINE CORRECT ? BELOW
strsql = "EXECUTE [program_work].dbo.[sp_Clm] ] N'" & MyValue & "' & N'" & MyValue2 & "' ;"



dB2.CommandTimeout = 400
                With rs2
                 .ActiveConnection = dB2
                 .Open strsql
                End With


-----  more code

Select all Open in new window

Hi,

My office has mixed win7 and win10. On win10 pc, all network printers can be listed, but on win7, nothing is listed except for a disconnected printer.

On those win7 pcs, I have to add the printer by using IP.

Also, how can I remove the printer that was disconnected when I do the network printer search. thank you

Values to be identified as duplicates will be in the second (B) column (with header). I will need to identify rows with duplicate values in that column, but preserve all values in the other columns of that row.

It would be good to insert the string, "Duplicate" (without quotes) in the column to the far left of the duplicates other than the 1st instance. For the 1st instance, mark as "First Instance", would be desirable. Then I can sort on that column. Non-duplicates should not be marked at all.

Spreadsheet has 75,000 rows.

Using an Inline Function would probably be preferred if possible, rather than a nested VBA loop type macro. But please do what you think best. I'm unable to find a reasonable solution searching the web. -- BTW:  CONDITIONAL FORMATTING hangs the program with too many ROWS.

Sample Content: (sorry, but the "Indent" tags are not working). The point is that the values in other columns of those rows do not affect the logic.
Column A is Blank

Column-B-Title   Column-C-Title   Other-Columns-w-Title
5555 5555 5555 3333 3333 XXXXXX XXXXXX Anything Else
(Note: Sorry about all the edits. Couldn't find a "Preview" button prior to publishing. Not familiar with this new interface.)

Experts,

I have a group of values on a spreadsheet "Sheet 3"  Column A  Rows 2 =15 that I have assigned to a name field called 'East'.  Is there a way to check column "A" on Sheet 1 equal to one of the values in my named field and assign "EAST" to column "B' on the respective row.

Microsoft Excel 2016
Named_Feild.xlsx

How to remove multiple rows with the name "DPL" in the string in column Resource and HLR as string also in Resource Column. Another words can have DPL live as string but will still remove because it found DPL. Thanks in advance

Experts,

II created sheet 2 using formulas with data from sheet 1.   My column letters    (A B C D etc. are missing from Sheet 2.  I am using Excel 2016.  How can I get the column letters to appear?