Posts by ????706
-
-
i want register the hours in B1 when i input any data in A1.
-
hi
i want a fomula to put hours in cell B1 when i input data in cell A1.can any one help me to write correct formula. -
i attached one of my 400 files.i removed some sheets to reduce size.
your vba works but saved as xlsb. i need to change them to xlsx. -
Thanks to AlphaFrog at MrExcel for this:
Code
Display MoreDim strSourceFile As String Dim strSourceDirectory As String Dim counter As Long strSourceDirectory = "C:\S30\TR\" '[COLOR=#FF0000]Change this to reflect your own actual Path[/COLOR] strSourceFile = Dir(strSourceDirectory & "*.xlsb") Do While strSourceFile <> "" Name strSourceDirectory & strSourceFile As strSourceDirectory & Replace$(strSourceFile, ".xlsb", ".xlsx") counter = counter + 1 strSourceFile = Dir() Loop MsgBox counter & " files renamed.", , "Rename Files Complete"
its works but after that the problem is the files can not open any more.
we saved these files in xlsb format and now we want to saved them in xlsx format
i think we should write a vba to open each file and save it as xlsb formats.
[ATTACH=JSON]{"alt":"Click image for larger version Name:\terorr.jpg Views:\t1 Size:\t15.3 KB ID:\t1206184","data-align":"none","data-attachmentid":"1206184","data-size":"full","title":"erorr.jpg"}[/ATTACH] -
hi.
I have 400 excel files with xlsb format.can anyone help me to write VBA to change all files formats in one specific folder with their own names? -
thanks, it works very well.is it possible before pasting the picture remove previous one?
-
i have some sheets and produce some reports in each page.i want a code to use for each page reports and paste them as picture in the last sheets.
Is there anyway using vba code that copy specific range " C30:j33" and turn them into image in another sheet "A1:H4" ???