batch

I’m trying to create a simple macro where the user can batch edit cells by entering a reference number. Here is the idea. Suppose I want to track shipments for different items on my inventory. There are 4 columns on my spreadsheet (Item#, Product Description, Order Date, Delivery Date) and...

Hello everyone, I have searched a lot in the web for the solution but I cannot find it. The issue is this: I need to open or run a batch or txt file from VB. The code I have is this: Sub Example() Dim RetVal RutaCompleta = Ruta & "\" & "texto.txt" RetVal = Shell("C:\BatchFile.txt") End Sub...

Hi. I need to: - Import all files and file properties including but not limited to path and tags for a specific directory (including subdirectories) - Then I need to add tags to files manually on the tags column - And then add those tags back to the files.(excel or batch for csv file created...

Hi folks, I've seen a few similar posts to this but not one that seems to fit my needs. I'm looking to import multiple text files into the same sheet, placing subsequent text files below the previous one. I'd also like to remove the headers in the text file (just the first row) as the files...

Dear All, I am using this great Macro, for printing financials reports, developed by Chandoo.org. There's just one problem with the code: It prints all sections on a separate sheet, rather than in a single batch. Not necessarily a problem when physically printing a report, but it does become a...

Hi guys, Today I have a question totally not related to Excel. But I hope that your expertise can also support in this case. This has been bugging for a long while now. I have a question about influencing the Win7 wallpaper rotation via batch or other code. The issue I encounter is like...

i have batch file that run from VBAexcel But the thing is i dont want to run batch file i want everything on VBA . for example you use vba to cmd and then run this line of command i have try but i just new to VBA and programing :) how can i do it here the code this is from batch @echo off...

Hello Everyone, First, I haven't found my answer in other threads, so if it does exist, please redirect me. Now, here is my problem. I have thousands of excel files each containing a varying quantity of sheets. There are two logos in each file first sheet (at the same position) and these...

I'm trying to call a .bat file which is located in My Documents. Is there a way of making VBA in Excel to understand %userprofile%, so that it can be launched from different windows accounts? Example: Call Shell("C:\Documents and Settings\william\My Documents\AutoFormat.bat", vbReadOnly) Call...

I have written a Dos Batch file that asks the user some informtion then renames a directory with that info. such as "Job No." "Company" In the batch file I use the Set command to get the info Set /p number=Job No. I would like the Batch file to then go onto open a excel file and input...

Hello all, Talking about Excel 2007 on Windows 7. Here is the deal: Let's say I have two xml docs, that, if opened in excel, and opened as an XML table would like like this: #1 Case Info: here's a link to the file- it just needs to become a sheet- no transformation needed...

Hi, Feeling about foolish as at my age your suppose to know these things....... Anyway, Im trying to create a folder with 4200 excel files, the files are identical but I need to name the files numerically, ie: start at 2300 and end at 6500. I am presently renaming them individually which is...

I'm currently merging similar Excel workbooks in one file. And they use the same cell names. And i will need to reuse those values in another worksheet later. SO I need to rename a lot of cells and it would be really long doing it with the name manager, is there a faster way to do it? Also, i...

Hi, I'm working with super heavy txt files (50 000lines), all formated in the same way. I'm trying to bring them together in a csv or xls file. I normally do it by hand but the sheer size of the files makes Excel - Import - Convert prone to errors and crashes. The separator for the fields is...

Hello, I'm in the process of creating a custom gantt formulation for a specific batch production case, without using excel charts. This uses some basic operations research methodology, but the problem is the the code, not in method. The production case is like this: I have 4 processes -...

Hello- I recently discovered that there is a bug in the vba code of a template excel file that has been copied to over 3000 files. I figured out how to fix the problem, but I would like to update the previous 3000 files that had the bug. Is there any way to do some sort of batch copy and...

hello, i'd like to run a batch file in cygwin. my script is: Sub test() Shell "c:\cygwin\bin\bash /K c:\test.bat", vbNormalFocus End Sub but this doesn't work. the cygwin window opens then immediately closes without running the batch. (and no, i can't run test.bat in cmd.exe because it...