file creation

I am working on a quote tracking program in excel and would like to streamline the quoting process. I have an office form my sales staff can fill in which populates an excel table for me to see the information. Within the table I have formulas to do many things and one is to compile a lot of the...

I have a VBA program that loads a pivot table into a VBA array. The program then creates various spreadsheets required. It opens a new excel file, populates the data, then saves the file and closes the file. The program creates circa 270 excel / CSV files. However, just recently we have run...

Hi still more or less a newbie here. I have an excel export of items that have a hyperlink to some online documentation. I haven't figured out how to do the following: Capture the links along with their associated par name Put the links in the corresponding folders on the network in...

Hi, I'm trying to create a command in a file "Directory Creation Test.xlsm" which will, on pressing a button, do the following: 1)Search for a folder, and if it does not find it, create one. Example: Find the folder "Test" in the directory C:\Filing System, and if it does not exist, create...

Greetings! I'm working on an portion of code in my workbook to FTP some files. To do that, I'm creating a FTPcmd.txt file via code containing the FTP commands, closing the file and then shelling the FTP command in the CMD window. It looks like the command file is taking too long to complete...

I have created a macro that when you click the button in excel it lists the information in a few certain cells from multiple excel files. It works okay apart from the fact it opens a new excel to do it rather than doing it in the excel with the button in it. Please can some one look at my code...

Hi all, This may be something obvious but I simply want to create a new .mdb (Database) file via VBA code. I would normally enable the Access reference in VBA and just create a new database that way, however the system where I plan on using this doesn't have Access references so I need to...