Categories
User Help

Extract external links from multiples Excel files

I’m trying to get all the external links from multiple Excel files and I already found a way to do this with a macro, but this only works for a single file. Right now I have a list of all the Excel files I want to check with the file path where are stored , […]

Categories
Development

Excel VBA On Error Goto not working to stop sheet being added

My code is as below: Sub NewWorksheetTest() Dim wsname As String wsname = InputBox(“Enter a name for the new worksheet”) On Error GoTo BadEntry Sheets.Add ActiveSheet.Name = wsname Exit Sub BadEntry: MsgBox Err.Number & ” :” & Err.Description, vbInformation, “There is an error….” End Sub My understanding is when i input something bad(e.g.duplicated names or […]

Categories
Development

Export Multiple named PDF’s from MS Access

Code: Private Sub Command455_Click() Dim filename As String Dim filepath As String filename = Me.LAST_NAME & “,” & ” ” & Me.FIRST_NAME & “,” & ” ” & Me.STUDENT_ID filepath = “C:\Users\ddennis1\Desktop\” & filename & “.pdf” DoCmd.OpenReport “Humanities_MiniDips”, acViewPreview, , “[Student_ID]=Forms!DIPLOMAS_EXPRESS!STUDENT_ID” DoCmd.OutputTo acOutputReport, “Humanities_MiniDips”, acFormatPDF, filepath MsgBox “Graduate exported”, vbInformation, “Save confirmed” End sub The […]

Categories
Development

How to check if a video or an audio stream is online or not in Vbscript?

I wonder what is the parameter or the value to look for to check if a video or audio stream is online or not in vbscript ? So this what i have tried as code until now, but, it give me a wrong results, because i have checked all those streams with VLC and they […]

Categories
Development

Is There Any Work Around In Exporting Msaccess Query Table With Calculated Field Using Excel Vba Ado?

Hi I have a Calculated Query Table name DataQuery like Date / RJournal / AMount where Rjournal is a calculated field Rjournal : DLookUp(“REFjournal”,”DV”,”ChckID > 0 and Payee = ‘” & [Payee] & “‘ and Dvnumber = ” & [Dvnumber] & “”) And it works fine. But since MS Access is my Database and Excel […]

Categories
Development

How to format time in an Array

I am creating a text-box using an array so that when someone searches a value in 1 column, they get the results from the other 3. For some reason, although the time for “CallTime”/”RequestedCallTime” is formatted “h:mm:ss” on excel, it is coming through as a decimal in the textbox. Private Sub Workbook_Open() Dim PostalCode() As […]

Categories
Development

vba macroc to copy data from one sheet two the next based on two ID columns [on hold]

I have seen many questions and answers regarding copying data from one table to another but unfortunately have not found one that has worked for my case. Details: Workbook (file name can vary): Project_results.xls two Worksheets (sheet names can vary): source worksheet is symb (2), and destination worksheet is Kleur Both worksheets have columns Sample […]

Categories
Development

Macro to compare 2 Excel worksheets and copy differences in a new worksheets (errors report)

With the below code I’m able to compare 2 Excel worksheets and collect the gaps review in a third worksheet (error report). I would like to improve the error report (data paste in sheet 3) by adding a column that specify type of errors. In this columns I would like to have the following categories […]

Categories
Development

records don’t appear in RS when updating records using a userform commandbutton

I’m trying to append/update a certain record in the access db using a userform in Excel. I had the table imported from access DB to a list box, then when rows are double clicked, it copies the entries to text boxes which does it without fail. But when I change the values in the boxes, […]

Categories
Development

How to stack columns on excel

I have a spreadsheet of data that is in the current format of: A1, A2, A3,B1,B2,B3,C1,C2,C3 Im trying to stack the data so that it follows this format: A1, A2, A3, B1, B2, B3 C1, C2, C3 This is so i can import into some software in the correct format. I have found the following […]