0
votes
2answers
442 views

Batch filling multiple forms using data from Excel

I have an excel file which contains many rows of data, each row has columns like last name, first name, gender etc. I would like to batch fill these data into multiple forms of different types. ...
1
vote
3answers
2k views

Batch filling pdf form using data from Excel

I have an excel file which contains many rows of data, each row has columns like last name, first name, gender etc. I would like to batch fill these data into a form which is in PDF format, each row ...
0
votes
2answers
1k views

Automatically import a macro to Excel and run it

I have made a module i.e. a .bas file which does the work I want to do in Excel. I have to work with this same module in four different files everyday. Now I want, let's say, a script which ...
0
votes
1answer
344 views

Replace a batch of cells with scaled values

I have a set of values that I want to replace with 10x (or another factor) scaled ones. Since I have to do it many times, is there any way to do it without calculating on separate cells and copying ...
1
vote
0answers
337 views

Refreshing Crystal Reports through Excel Macro

At work we have an ancient Ingress database that wont allow me to make links between tables using the SQL Query editor in Excel 2007. My current solution is to generate the data in Crystal Reports, ...
0
votes
3answers
786 views

Excel or Batch - Trying to Automate Text Correction (Many Changes; One or More Characters Each)

I have a lot of lines of text. I can put them into a text file or into an Excel spreadsheet. They need many changes. Here's an example of a before and after: Input: I'm buying one! Only ...
1
vote
0answers
316 views

Auto rename files through excel sheet or through folder of these files

I have excel sheets with lot of files names like.. I want to renames all files through excel sheet and renames files itself.. Or 2nd condition is , if i rename files my self and rename in excel sheet ...
1
vote
2answers
7k views

How to run MS Excel 2007 from a batch file?

I can't find a proper *.exe for Excel in the usual places: "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office "c:\program files\microsoft office\office12\excel.exe" Does ...
1
vote
2answers
305 views

find in windows (batch files)

Does the find command in windows (command line) work to search inside of excel files?