current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0

Tagged Questions

3
votes
2answers
57 views

Opening an excel file manually allows formulas to run, opening an excel file with VBScript or Python's win32com doesn't

I'm having a problem with a script not updating an excel file, and I reduced it to the following problem: If I open an excel file, I can go to the Formulas tab and click "Calculate Now" and it'll ...
0
votes
1answer
39 views

VB Script FileSystemObject methods throwing 424 error

I have been searching the Internet for the past few hours trying to find a reason why this always throws a 424 Object required error in excel. Can someone explain why this is, and the best way to fix ...
0
votes
1answer
46 views

List or Enumerate MSForms.dataObject Clipboard Format Identifiers

Is it possible to list or enumerate the format identifiers within a MSForms.dataObject Clipboard? Currently using Excel 2007 VBA... I have the correct references set up and am able to set the text ...
0
votes
1answer
79 views

How to download attachments from lotus notes using vb script

I have a code which downloads the attachment from the lotus notes. The problem is that each time it runs it downloads all the attachment. How can I give the condition not to download the previously ...
0
votes
1answer
25 views

Using the QuickSort/SortVals VB Script on a selection, not just the active cell

Is there an easy way to get this code to execute for a selection, not simply the active cell? My brain is fried and I can't make this work...I need to be able to do this for about 10,000 rows. Option ...
-2
votes
0answers
37 views

Excel macro/VBA script to convert CSV cell data into rows based on Date-Time-Stamps in the last column

I need some help. I am a novice at this. I have written Macros before and somehow that make me the resident expert in my office. The task Ihave before me is a bit beyond my skills and would greatly ...
5
votes
2answers
72 views

Ignore “Do you wish to save” box on exit of excel

I have a script that opens an excel file and runs a macro, then quits the file. Since the file is in read only mode, and the script makes temporary changes to the file, when the script calls ...
0
votes
2answers
67 views

I need to write a Batch file (.bat) to Open and Save an Excel file

I have an Excel file on server(.xls) format. But I think this is generated in some higher versions of Microsoft Office Excel. The problem is I have some SSIS packages which are failing in reading ...
0
votes
2answers
42 views

delete cells but not rows

I have an excel sheet where I am pulling data from other worksheets into separate columns per worksheet I pull from. I am trying to find any duplicates in any of my columns and delete all the ...
0
votes
0answers
32 views

Copying data in curly braces and adjacent column to a new spreadsheet

I'm writing a script that copies all of the information in braces across to a Sheet1 along with the data in. At the moment I am having some issues copying over the results to a new spreadsheet , it ...
0
votes
2answers
44 views

How to read string after dash?

The code below, takes strings from column F and extract and converts it to a number in column G. I have a string 'J-60'(column F), which is currently not converting. The code should be able to extract ...
1
vote
3answers
40 views

Move VBA code to standalone VBS file

I have a macro in excel vba that runs a shell to execute a simple pdf editor by command line, exports a list of the page names and numbers, searches for a keyword to find the page we want, gets the ...
0
votes
0answers
110 views

RUN VBS SAP from VBA Object required error

I'm trying to write a macro to start a VBS SAP script and to possible change some of the variables of the VBS code. Any help would be great! With the below I get Object required error Public Sub ...
1
vote
1answer
33 views

VBA Declaring a library vs dynamically loading it

I'm creating an application in VBA that uses a reference from vbscript.dll I'm trying to figure out the best way to load the library, and am having difficulty distinguishing between using a declare ...
0
votes
0answers
33 views

VBA loop though visible column in printing

I have a pivot table and I sliced my printing table to filter selection. SO when filter is ALL it show all of my list; However I would like to print my pages and print filter selections as the title ...
0
votes
1answer
43 views

FSO file rename code running twice

Scenario - OutFolder contains XML files which are named by their created datetime (like 20140524110115, 20140524110120, 20140524110122 and so on). I want to rename these files based on their ID and ...
6
votes
4answers
78 views

Replace all text in text file using regular expression

I have a text file with following text 161624.406 : Send:[sometext1] 161624.437 : Send:[sometext2] 161624.468 : Send:[sometext3] 161624.499 : Send:[sometext4] 161624.531 : Send:[sometext5] I want ...
0
votes
0answers
23 views

How discover a ClassID/COM UID of an Early Binding reference to use on Late Bindind?

Putting it simple: I need to discover the Namespace and all the public Methods exposed by a COM Library avaliable to be used. I have this as an example: The closest place I have come is the ...
0
votes
0answers
104 views

How to add a .XLAM add-in to Microsoft Excel 2013 using VBA

I have written a vbscript to install an add-in to Excel 2013. Dim oXL Dim oAddin Set oXL = CreateObject("Excel.Application") oXL.Workbooks.Add Set oAddin = oXL.AddIns.Add("C:\Apps\FMP.xlam", True) ...
1
vote
2answers
80 views

Why i am getting type mismatch error when calling macro from vbscript

When i am calling below macro from vbscript why i am getting type mismatch error Macro in parameter.xlsm Sub Proc(sParam1 As String, iParam2 As Integer) MsgBox sParam1 & " is " & iParam2 ...
1
vote
2answers
54 views

Basic macro commands and functions [closed]

I'm about to embark on writing a macro(or VBScript) inside a Microsoft Excel worksheet. Recording a Macro is not an option for this project. I have no background in development or computer science ...
-3
votes
1answer
95 views

How do I fix this “Input past end of file” error? [closed]

I must find all the Steps containing PGM=FTP then read all the lines until I find another step that does not has PGM=FTP. It could be anything except FTP. I need all the chunk of lines to be written ...
0
votes
3answers
196 views

Calling VBA macro from .vbs file throws 800A03EC error

I'm trying to run a VBA macro through .VBS file(File name: Check_final.vbs). Here is the code Option Explicit run_macro Sub run_macro() Dim xl1 Dim sCurPath Dim xlBook Dim ...
0
votes
1answer
116 views

How to find elements in MSXML2.XMLHTTP

I'm trying to find the fields to fill in some data online. first I wrote it in IE, what works, but is sow and hideous. IE code 'For Internet Explorer With IE .Navigate URL .Visible = True ...
0
votes
2answers
64 views

VB Script Join Function is throwing a type mismatch error

I'm trying to fetch the data from an excel which contains a single query in each sheet. so, here are my steps : 1) creating an excel application --> workbook --> worksheet objects 2) get all the ...
1
vote
1answer
73 views

Unknown Runtime Error occurs when setting a range

This is a subroutine of a larger program (I can copy and paste the whole thing if needed). I'm getting an unknown runtime error, and I can't for the life of me figure out why. I've spent a couple ...
0
votes
1answer
2k views

VBscript: Copy/Paste data from one workbook to next blank row (specific cells) of another workbook

I'm just a newbie in VBscript (and code). I have a problem when trying to copy/paste data from one workbook to next blank row of another workbook using "Excel macro - VBA". For example: I want to ...
1
vote
1answer
65 views

Why does workbook turns hidden after vba executes

Here is the sub Sub test() With ThisWorkbook .Worksheets("Sheet1").Range("A1").Value = 5 .Save End With End Sub Here is the vbscript that starts the sub dim eApp set eApp = ...
1
vote
2answers
414 views

How to set recurring schedule for xlsm file using Windows Task Scheduler

I have a xlsx macro enabled file . How can I set it in the task manager so that everyday at 9 AM task manager would open the workbook, fire the macro and close the workbook. So far i am using ...
0
votes
1answer
109 views

Running a testcomplete script from an external application

I am trying to run a testcomplete project and the script routines within it. i used the following code: Dim pn As String, un As String, rn As String 'Set ProjectSuiteName = ...
0
votes
1answer
70 views

Select a Column as a Range after Finding a Specific Cell

I'm using these lines of code to find a specific cell in my VBScript. Set FoundCell = objSheetSrc.Range("A1:BZ1").Find("Device", , , 1) For Each Cell In Range() If Cell.Value <> "*MSP430*" ...
0
votes
1answer
15 views

data are copied to column instead of row

below is the code which is used to copy all the rows from one csv file and paste it in another csv file. Set xlWkb = xlApp.Workbooks.Open(file) Set combineCSV = ...
0
votes
2answers
82 views

Delete first few rows containing merged cells

I am working on some VBScript that combines data from a bunch of excel files in a certain directory. All of these excel files contain anywhere from 10-20 merged cells with useless information. How ...
0
votes
2answers
279 views

VBS to compile information from multiple excel files into one

I'm working on VBScript to move all the information from multiple excel files into one sheet on a master excel file. It would basically be 1000-2000 rows of information and about 20 columns. There ...
0
votes
1answer
75 views

Convert Xls to Csv for a Range of Cells

I have a VBA Macro to convert all .xls files present in a folder to .csv files , but there is some additional requirement to be done. I have to select a range of columns (like from A to AQ and all ...
0
votes
0answers
38 views

Using Tab in ComboBox in Excel

I have a list of items(Inventory) in sheet1 in excel 2007. I want to use comboboxes in excel so that it picks up items from my inventory and makes making my bill easier. However i cant seem to use ...
0
votes
1answer
151 views

How to recursively check all subfolders for existing Excel files and extract all VBA code

I'm looking for a way how to combine PowerShell script with VBscript to extract all VBA/win32 code from a lot of excel files in complicated folder structure. I need to recursively check all ...
0
votes
1answer
29 views

How do I parse every string while comparing two excel spreadsheets?

Good evening, I'm attempting to compare two excel spreadsheets by using the IF and MATCH functions as follows: =IF(ISERROR(MATCH(fromADP!$C2,fromSMS!$A$2:$A$4792,0)),"No match found",fromADP!$C2) ...
0
votes
0answers
47 views

Excel 2010 VBA - pattern searching

I need to search large ranges of cells for values matching a regular expression. The Range.Find methods will definitely do part of that, but I cannot find any detailed documentation on what the ...
0
votes
0answers
105 views

Multiple-step OLE DB operation generated errors- excel vba

I have .vbs script file that calls a macro inside an excel file using below code: Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open("C:\Users\Report.xlsm", 0, True) ...
2
votes
0answers
215 views

Can I access and query web-based Crystal Report Viewer through Excel VBA?

I download reports through web-based access to a Crystal Report Viewer. (Admittedly, my first problem is that I am not at all proficient with Crystal.) I generally have success using Excel VBA in ...
0
votes
2answers
42 views

Search for string on cell starting with two specific letters and highlight entire row

I want to highlight the row that contains letters starting with "ZZ*" green Then highlight the row that contains letters starting with "ZV*" yellow and so on. I used conditional formatting formula ...
1
vote
0answers
111 views

vba, include functions like c++(or many other languages)

I have recently started working on lots of vba/excel work. Coming from python/sas/c++ environment I am having some issues getting comfortable with the methodology. Realizing I am using same macros ...
0
votes
3answers
150 views

does vbs scripting still work in windows 7/8

Apologies in advance for my terminology or possible lack of knowledge in this area. This is a *.vbs script that will open a excell workbook WBName = "\WorkBookName.xlsm" (generally in the same ...
0
votes
1answer
407 views

CreateOleObject opened workbook won't run macro containing Application.Run “Solver.xlam!…” causes error 400

This problem has a relationship to a previous post I saw (not my question), which was closed: Excecute Excel macros through Delphi But I believe I have debugged my issue to a more general OLE/VBA ...
0
votes
0answers
61 views

VBScript Excel FormulaR1C1

When I want to set new formula into excel cell from VBScript I do this: ObjE.WorkSheets(1).Cells(3,3).Select ObjE.ActiveCell.FormulaR1C1 = "=R1C1*2" Then I save workbook and its OK. But when I want ...
0
votes
1answer
62 views

VBS Reg error in Win7 32bit & 64bit

I have made the following script in VBS but although it does work in windows xp & vista, I cant get it to work in win7 both 32 & 64 bit. set myclip = createobject("clipbrd.clipboard") bcode ...
0
votes
1answer
65 views

read comma separated integers in INI file

I have a INI file that looks like this ! [columnNumber] Number1=2,4 this is my code the ini file is read using function defined here the columberNumber is taken as string "2,4" i want to split ...
0
votes
4answers
314 views

VBScript To Launch Internet Explorer With A URL Generated

Currently I'm a learning HTA programming. I have a requirement as follows. There are two input boxes in the form (both are mandatory). When I enter the values and click on search button, a url ...
0
votes
3answers
1k views

Multiple TextBox for Input in VBScript

Can we have multiple input text boxes in VBScript? I'm trying to create a form window using VBScript itself. I should get two values as input. Please help me.

1 2 3 4 5 6