fileformat

fpath = "\\location\" fname = "folder_" & Format(dte, "ddmmyyyy") Set srcWkb = ActiveWorkbook Worksheets("Thatworksheet").Copy Set destWkb = ActiveWorkbook With destWkb.Sheets("Thatworksheet").UsedRange .Cells.Copy .Cells.PasteSpecial xlPasteValues .Cells(1).Select End With...

Hello! I've made a script that uses IE to search for a product on a site and, if found, downloads its image. The issue is the extension. It downloads the images but I can't figure out how to get it to add the extension of the original URL instead of having it user specified, which makes some...

I have a workbook that I am making copies of and saving those copies as different names. For some reason, what appears to be random, some of the files don't get the .xlsx extension added to the saved file. The files are being saved with the correct name convention I setup, but the file...

I have a spreadsheet that I need to convert into a tab delimited text file. I am writing some vbs code in notepad++ and I just cant get the last line to work, everything else runs perfect, but I just cant get it to save as a tab delimited text file :/ Set ExcelObject =...

Anyone have a list for all of the file format numbers? I've done some poking around on the interwebsbut have only come up with the following... <o:p></o:p> <o:p></o:p> FileExtStr = ".xlsb": FileFormatNum = 50<o:p></o:p> FileExtStr = ".xlsx": FileFormatNum = 51<o:p></o:p> FileExtStr = ".xlsm"...

Hi I'm writing some VBA code to take the value of cell C7 and copy the sheet into a new workbook, unless C7 is blank. The problem is that the file name from C7 has a period in it that is seen as the start of the file type. The period needs to stay! When the process of taking the value of C7...

NEED HELP!! VBA - EXCEL -NEED HELP Renaming file in same path + text addition Hello and thank you for reading/responding. I am using the current code to save as CSV to XLSX. BUT- this is renaming the file with the TEMP<CURRENTFILENAME>... AND placing on my desktop. With Activeworkbook .SaveAs...

Hi there, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I’ve got a file which from a macro sorts the data then splits it into sections, then creates a new workbook for each section, renames the tabs and and saves the new files as the tab name, for us to...

I wrote this code to populate a cell in the file and then save it to a location on a shared folder on the server. When it runs it fails to save it at all. Private Sub BtnOK_Click() ActiveWorkbook.Sheets("Info").Activate Range("A3").Select If IsEmpty(TxtCredentials.Value) = True...